Close Menu
    Facebook X (Twitter) Instagram
    Monday, May 12
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM 2007»SCCM report to list machines where and When RAM changed?

    SCCM report to list machines where and When RAM changed?

    Eswar KonetiBy Eswar KonetiJune 12, 4:15 pm1 Min Read SCCM 2007 443 Views
    Share
    Facebook Twitter LinkedIn Reddit

    This report will list the computers where and When the RAM is changed ?

    select
    CS.Name0,
    CS.UserName0,
    RAM.TotalPhysicalMemory0,
    RAM.TimeStamp,
    HRAM.TotalPhysicalMemory0,
    Max(HRAM.TimeStamp)
    from
    dbo.v_GS_COMPUTER_SYSTEM CS,
    dbo.v_GS_X86_PC_MEMORY RAM,
    dbo.v_HS_X86_PC_MEMORY HRAM
    Where CS.ResourceID = RAM.ResourceID
    and CS.ResourceID = HRAM.ResourceID
    and RAM.TotalPhysicalMemory0 != HRAM.TotalPhysicalMemory0
    Group by
    CS.Name0,
    CS.UserName0,
    RAM.TotalPhysicalMemory0,
    RAM.TimeStamp,
    HRAM.TotalPhysicalMemory0

    Configmgr 2007 configmgr report SCCM 2007 SCCM report for RAM changed SCCM Reports SMS SQL Where and When RAM Changed
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    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

    SCCM report list collections with no deployments

    December 05, 12:04 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-2024 Eswar Koneti, All rights reserved.

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