Count of Domain roles

Select   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 ‘Unknown’

end as ‘Domain Role’,

Count (‘Domain Role’) as ‘Count’

from v_GS_COMPUTER_SYSTEM

group by DomainRole0

order by ‘Domain Role’

Leave a Reply

Your email address will not be published. Required fields are marked *