Posted by Eswar Koneti on 19th January 2012
Usually when applications are installed,they wont repot to site server with installed software and its details why because the value that should report to site server is not picked by sms agent by default and you should edit SMS_DEF.MOF file which you find it from your site server installed drive,inbox folder,clifiles,hinv .
Below is the group to make TRUE from FALSE to get the requirement information. You dont have to compile this mof file on clients as they get it by its next policy cycle.
Monitor the MOF Changes from site server logs (dataldr.log)
SMS_Group_Name (“Installed Software”),
SMS_Class_ID (“MICROSOFT|INSTALLED_SOFTWARE|1.0″) ] as TRUE from ur SMS_DEF.MOF file
SELECT A.ARPDisplayName0, A.InstallDate0, A.InstalledLocation0, A.InstallSource0
FROM v_GS_INSTALLED_SOFTWARE A, v_GS_COMPUTER_SYSTEM B
WHERE A.ResourceID = B.ResourceID
AND B.Name0 = @computer
AND A.InstallDate0 >= DATEADD(day, -7, CURRENT_TIMESTAMP)
ORDER BY A.InstallDate0, A.ARPDisplayName0
Prompt for Computer:
select Name0 from v_GS_SYSTEM
Tags: 7 days report with softwares, applications installed report for 7 days, Configmgr 2007, configMgr reports, Report for softwares installed with in 7 days, SCCM 2007, SCCM Reports, software installed report, SQL, SQL Quiries
Posted in SCCM 2007, SCCM Reports, Software Distribution, SQL Quiries | No Comments »