This page looks best with JavaScript enabled
Useful SCCM SQL Queries
Get all server services and the accounts they are running under
1
2
3
4
5
6
7
8
|
select vrs.Name0 + '.' + vrs.Full_Domain_Name0 [computername],
vgs.DisplayName0,
vgs.Name0,
vgs.startname0,
vgs.startmode0
from v_GS_SERVICE vgs
left join v_r_system vrs on vrs.resourceid=vgs.resourceid
where vrs.operatingSystem0 like '%server%' and startname0 like 'domain\%'
|
WRITTEN BY
Michael
IT Engineer
