SCCM Report for computers with service status (started,stopped,disabled)By Eswar KonetiJune 12, 5:10 pm SCCM 2007 1 Min Read11,971 Views select Distinct CS.Name0, SER.Displayname0, SER.Started0, SER.StartMode0, SER.State0 from dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_GS_SERVICE SER, dbo.v_FullCollectionMembership FCM where CS.ResourceId = SER.ResourceID and CS.ResourceId…
