cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Anonymous
Not applicable
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
1 REPLY 1
Hemoco
Lansweeper Alumni
Thanks, we'll add a slightly modified version of the report in 4.1.

PS. thanks for mentioning Lansweeper in your new blog

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now