Close Menu
    Facebook X (Twitter) Instagram
    Saturday, October 11
    X (Twitter) LinkedIn Reddit RSS
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM 2007»ConfigMgr(SCCM) report for softwares installed within 7 days

    ConfigMgr(SCCM) report for softwares installed within 7 days

    Eswar KonetiBy Eswar KonetiJanuary 19, 4:05 pm1 Min Read SCCM 2007 1,857 Views
    Share
    Facebook Twitter LinkedIn Reddit

     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

     

    7 days report with softwares applications installed report for 7 days Configmgr 2007 Report for softwares installed with in 7 days SCCM 2007 SCCM Reports software installed report SQL
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM SQL Report – Compare Installed Apps on TWO Different Computers

    July 13, 10:35 am

    Monitoring Endpoint Security Applications with SCCM ConfigMgr SQL

    October 11, 8:48 pm

    Efficiently Identify Co-Managed Devices: Techniques and Tools

    January 17, 8:37 pm

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

    © Copyright 2009-2025 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.