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

Thanks to jones for original post.