none
Need report to list the system name, client status, client version, OU name info for a particular collection of systems

    Question

  • Hi Friends,

    Need report to list the system name, client status, client version, OU name info for a particular collection of systems.

    Please help as it would be appreciated much as i am not familiar with creating custom reports in SCCM. Thanks.

    Regards,

    Thangaraj

    Wednesday, July 02, 2014 8:54 AM

Answers

  • Select v_R_System.Name0, v_R_System.Client_Version0, v_RA_System_SystemOUName.System_OU_Name0,
    
    case  when v_R_System.Client0 = '1' then 'Client is Installed' 
    else 'Client Not Installed'
    end as 'Client Status'
    
    
    FROM v_R_System JOIN v_RA_System_SystemOUName ON v_R_System.ResourceID = v_RA_System_SystemOUName.ResourceID WHERE System_OU_Name0 LIKE '%HR'


    John Marcum | Microsoft MVP - Enterprise Client Management
    My blog: System Center Admin | Twitter: @SCCM_Marcum | Linkedin: John Marcum

    • Marked as answer by Thang Raj Thursday, July 17, 2014 9:50 AM
    Monday, July 07, 2014 12:17 PM
    Moderator

All replies

  • Quick search turns up this page with everything you need.

    http://vasanthsccm.wordpress.com/2012/02/10/sql-queries-for-sccm/

    You can't be a SCCM admin and not learn how to write reports. Make an effort, and post when you run into problems.


    John Marcum | Microsoft MVP - Enterprise Client Management
    My blog: System Center Admin | Twitter: @SCCM_Marcum | Linkedin: John Marcum

    Wednesday, July 02, 2014 7:04 PM
    Moderator
  • Hi John,

    That was a valid point. Have tried to write query for my first report! . Below is the one.

    Select v_R_System.Name0, v_R_System.Client_Version0, v_RA_System_SystemOUName.System_OU_Name0 FROM v_R_System JOIN v_RA_System_SystemOUName ON v_R_System.ResourceID = v_RA_System_SystemOUName.ResourceID WHERE System_OU_Name0 LIKE '%HR'

    Using the above one, I can get system name, its client version, OU name with condition as OU name like '%HR' in the report.

    However i need to get whether client is installed or not (say Yes or No) for a given collection of systems.

    How do i do that? Thanks

    Regards,

    Thangaraj

    Monday, July 07, 2014 8:15 AM
  • Select v_R_System.Name0, v_R_System.Client_Version0, v_RA_System_SystemOUName.System_OU_Name0,
    
    case  when v_R_System.Client0 = '1' then 'Client is Installed' 
    else 'Client Not Installed'
    end as 'Client Status'
    
    
    FROM v_R_System JOIN v_RA_System_SystemOUName ON v_R_System.ResourceID = v_RA_System_SystemOUName.ResourceID WHERE System_OU_Name0 LIKE '%HR'


    John Marcum | Microsoft MVP - Enterprise Client Management
    My blog: System Center Admin | Twitter: @SCCM_Marcum | Linkedin: John Marcum

    • Marked as answer by Thang Raj Thursday, July 17, 2014 9:50 AM
    Monday, July 07, 2014 12:17 PM
    Moderator