Close Menu
    Facebook X (Twitter) Instagram
    Sunday, July 20
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»CM2012»SCCM Configmgr SSRS Report: Count of PC’s By Role

    SCCM Configmgr SSRS Report: Count of PC’s By Role

    Eswar KonetiBy Eswar KonetiSeptember 24, 7:50 am1 Min Read CM2012 1,228 Views
    Share
    Facebook Twitter LinkedIn Reddit

    With the default report,you can get Count or list of PC’s from domain Eg: Computers in a specific workgroup or domain.

    If you want to know the count of PC’s with specific role like standalone workstation a.k.a Workgroup computers,member workstation,member server,standalone server etc,use the below report .

    I use property called DomainRole0 from V_GS_Computer_system view with case statement.

    select "Role"=
    case domainrole0
    when 0 then 'Standalone Workstation'
    when 1 then 'Member Workstation'
    when 2 then 'Standalone Server'
    when 3 then 'Member Server'
    when 4 then 'Backup Domain Controller'
    when 5 then 'Primary Domain Controller'
    else 'No'
    end,
    Count(*) [Total] from v_GS_COMPUTER_SYSTEM
    group by DomainRole0

    Here is the referral link which you can get information about domainrole and its values. http://msdn.microsoft.com/en-us/library/aa394102(v=vs.85).aspx

    CM12 configmgr Count of PCs By Roles Domain Roles SCCM 2007 sccm report SSRS Report workgroup
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM SQL Report – Compare Installed Apps on TWO Different Computers

    July 13, 10:35 am

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

    February 11, 9:50 pm

    Identifying devices managed by Intune but not reporting to WUfB using KQL

    November 09, 10:28 am

    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.