
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-12-2012 09:34 PM
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).
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-12-2012 10:06 PM
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
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
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-12-2012 10:06 PM
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
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-12-2012 09:42 PM
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).
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).
