List all PC where a service is set to automatically start and the service is not “Running”By Eswar KonetiJanuary 03, 10:28 am SCCM 2007 1 Min Read380 Views SELECT GS.Name0 as 'PC Name', GSS.DisplayName0 as 'Service', GSS.StartMode0 as 'Startup', GSS.State0 as 'State' FROM v_GS_SERVICE GSS, v_GS_COMPUTER_SYSTEM GS Where…