All Local User Accounts

[sfbcic-lcarr]

I've seen posts regarding local administrative accounts; however, I need to be able to provide a report for all local user accounts (regardless if they have admin priveleges or not).

[sfbcic-lcarr · Accepted solution]

This is resolved.



I just looked at the query for "Computer: Local administrator account name". All I had to do was remove the reference to the Admin SID.

Remove this entire line: Where tblUsers.SID Like '%-500'


This will list all local user accounts:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Description, tblUsers.Name, Web40OSName.Compimage As icon From tblComputers Inner Join tblUsers On tblComputers.Computername = tblUsers.Computername Inner Join web40ActiveComputers On web40ActiveComputers.Computername = tblComputers.Computername Inner Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Order By dbo.tblComputers.Computer

[sfbcic-lcarr]

I did want to point out that I saw this post:

http://www.lansweeper.com/forum/yaf_postst5893_Users-that-logon-locally.aspx

It looks to me like that would only report on local user accounts that had actually logged in before. I need a report that includes all local accounts (even those that have not yet logged into the computer).