List all PC where a service is set to automatically start and the service is not “Running”

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 GSS.StartMode0 = ‘Auto’ and GSS.State0 != ‘Running’

            and GSS.ResourceID = GS.ResourceID

ORDER BY GS.Name0, GSS.DisplayName0