ConfigMgr(SCCM) report for softwares installed within 7 days

 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_Report     (FALSE),
  SMS_Group_Name ("Installed Software"),
  SMS_Namespace  (TRUE),
  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

 

Leave a Reply