none
Report-List of all active system (Laptops/desktops) RRS feed

  • Question

  • Hi

    Can I generate below 2 reports from SCCM:

    1- Report-List of all active system (Laptops/desktops)

    2- Report-List of all active system (Laptops/desktops) for a subnet

    Regards

    Wednesday, September 11, 2019 8:15 AM

Answers

  • Hi

    Use the below collection query

    1- Report-List of all active system (Laptops/desktops)

    select SMS_R_System.Name, SMS_R_System.Client, SMS_R_System.OperatingSystemNameandVersion, SMS_G_System_CH_ClientSummary.ClientActiveStatus from  SMS_R_System inner join SMS_G_System_CH_ClientSummary on SMS_G_System_CH_ClientSummary.ResourceID = SMS_R_System.ResourceId where SMS_G_System_CH_ClientSummary.ClientActiveStatus = 1 and SMS_R_System.OperatingSystemNameandVersion not like "%server%"

    2- Report-List of all active system (Laptops/desktops) for a subnet

    select SMS_R_System.Name, SMS_R_System.Client, SMS_R_System.OperatingSystemNameandVersion, SMS_G_System_CH_ClientSummary.ClientActiveStatus, SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress from  SMS_R_System inner join SMS_G_System_CH_ClientSummary on SMS_G_System_CH_ClientSummary.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId where SMS_G_System_CH_ClientSummary.ClientActiveStatus = 1 and SMS_R_System.OperatingSystemNameandVersion not like "%server%" and SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like "10.101.%" (change the IP subnet)

    • Marked as answer by Sajidami82 Sunday, September 15, 2019 9:05 AM
    Wednesday, September 11, 2019 8:59 AM

All replies

  • Hi

    Use the below collection query

    1- Report-List of all active system (Laptops/desktops)

    select SMS_R_System.Name, SMS_R_System.Client, SMS_R_System.OperatingSystemNameandVersion, SMS_G_System_CH_ClientSummary.ClientActiveStatus from  SMS_R_System inner join SMS_G_System_CH_ClientSummary on SMS_G_System_CH_ClientSummary.ResourceID = SMS_R_System.ResourceId where SMS_G_System_CH_ClientSummary.ClientActiveStatus = 1 and SMS_R_System.OperatingSystemNameandVersion not like "%server%"

    2- Report-List of all active system (Laptops/desktops) for a subnet

    select SMS_R_System.Name, SMS_R_System.Client, SMS_R_System.OperatingSystemNameandVersion, SMS_G_System_CH_ClientSummary.ClientActiveStatus, SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress from  SMS_R_System inner join SMS_G_System_CH_ClientSummary on SMS_G_System_CH_ClientSummary.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId where SMS_G_System_CH_ClientSummary.ClientActiveStatus = 1 and SMS_R_System.OperatingSystemNameandVersion not like "%server%" and SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like "10.101.%" (change the IP subnet)

    • Marked as answer by Sajidami82 Sunday, September 15, 2019 9:05 AM
    Wednesday, September 11, 2019 8:59 AM
  • have you look at the builtin reports for this?

    Garth Jones

    Blog: https://www.enhansoft.com/blog Old Blog: https://sccmug.ca/

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleashed

    Wednesday, September 11, 2019 9:19 AM
    Moderator