Close Menu
    Facebook X (Twitter) Instagram
    Saturday, October 11
    X (Twitter) LinkedIn Reddit RSS
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»Collections»SCCM Configmgr collection report how to check Group policy file updated or not for X days

    SCCM Configmgr collection report how to check Group policy file updated or not for X days

    Eswar KonetiBy Eswar KonetiJuly 15, 5:24 pm1 Min Read Collections 3,451 Views
    Share
    Facebook Twitter LinkedIn Reddit

    This gives list of machines where the group policy database file not updated .Before creating the SCCM web report,software inventory has to be enabled for GPO file secedit.sdb file which will is available in  %windir%\security\database.

    collection(WQL):

    select SMS_R_SYSTEM.ResourceID

    ,SMS_R_SYSTEM.ResourceType

    ,SMS_R_SYSTEM.Name

    ,SMS_R_SYSTEM.SMSUniqueIdentifier

    ,SMS_R_SYSTEM.ResourceDomainORWorkgroup

    ,SMS_R_SYSTEM.Client

    from

    SMS_R_System inner join SMS_G_System_SoftwareFile

    on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId

    where

    SMS_G_System_SoftwareFile.FileName = “secedit.sdb”

    and DATEDIFF(dd,SMS_G_System_SoftwareFile.ModifiedDate,GetDate()) > 15

    Now you have to figure out why it is not updating Smile

    SCCM Report(SQL):

    select a.Name0 ,cs.UserName0 [Last loggedin],os.Caption0 [OS]
    , CONVERT(VARCHAR(12),b.ModifiedDate,107)As "GPO Date Last Applied"
    from v_R_System a
    join v_GS_SoftwareFile b on b.ResourceID=a.ResourceID
    join v_GS_OPERATING_SYSTEM OS on Os.ResourceID=a.ResourceID
    join v_GS_COMPUTER_SYSTEM CS on cs.ResourceID=a.ResourceID
    where b.FileName='secedit.sdb'
    and DATEDIFF(dd,b.ModifiedDate,GetDate()) >15
    order by b.ModifiedDate

    %windir%\security\database Configmgr 2007 configmgr report Group Policy not updated report for GPO is not updated for 7 days SCCM SCCM 2007 SCCM Reports secedit database secedit.sdb SMS SQL
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM SQL Report – Compare Installed Apps on TWO Different Computers

    July 13, 10:35 am

    Optimize Your Intune Workflow with a Powerful Browser Extension

    March 22, 10:39 am

    Migrate Microsoft 365 Updates from SCCM/MECM to Intune for Co-Managed Devices

    February 11, 9:50 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.