Check services running on user accounts

[Anonymous]

I'll share this one, I think it should be included on Lansweeper by default. It's useful for checking where are services running under "non standard" system accounts:

SELECT     TOP (1000000) tblcomputers.Computername, tblcomputers.ComputerUnique, tblcomputers.Domain, tblServices.Caption, tblServices.Lastchanged, 
                      tblServices.Startname
FROM         tblServices INNER JOIN
                      tblcomputers ON tblServices.Computername = tblcomputers.Computername INNER JOIN
                      tblComputersystem ON tblcomputers.Computername = tblComputersystem.Computername
WHERE     (tblServices.Startname <> 'LocalSystem') AND (tblServices.Startname <> 'NT AUTHORITY\LocalService') AND 
                      (tblServices.Startname <> 'NT AUTHORITY\NetworkService')
ORDER BY tblcomputers.Computer

[Hemoco]

Thanks, we'll add a slightly modified version of the report in 4.1.

PS. thanks for mentioning Lansweeper in your new blog