 Rank: Premium user Groups: Member, Premium Users
Posts: 203
Location: PT
|
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: Code: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
|
