cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
DMermod
Engaged Sweeper
Hello everybody,

I'm currently trying to build a report that list all local administrator accounts belonging to a computer. Then determine if those accounts are currently enabled or disabled. I'm having a problem putting it together and am asking for some assistance. Not a pro, just winging it.

Thanks in advance,

- DRM

1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Please try the report below.

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblUsers.Name As Username, tblUsers.Disabled
From tblComputers Inner Join
tblUsers On tblComputers.Computername = tblUsers.Computername
Where tblUsers.SID Like '%-500' And tblUsers.LocalAccount = 1
Order By tblComputers.ComputerUnique, tblUsers.Name


To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.

View solution in original post

3 REPLIES 3
Hemoco
Lansweeper Alumni
The report already includes a "Disabled" field. Disabled users will have a check mark in this field.
RavageVJS2D
Engaged Sweeper
I appreciate the effort in this report. It looks great. There is one more thing I need from it though and that is to see all local members of the Administrators group that are enabled or disabled.

For example....

Group User Disabled
Administrators Administrator True
Administrators LocalAdmin False
Administrators TestUser False

Etc....

I appreciate the effort thus far, hopefully only a quick step away from resolution.

Thank you,

- DRM

Hemoco
Lansweeper Alumni
Please try the report below.

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblUsers.Name As Username, tblUsers.Disabled
From tblComputers Inner Join
tblUsers On tblComputers.Computername = tblUsers.Computername
Where tblUsers.SID Like '%-500' And tblUsers.LocalAccount = 1
Order By tblComputers.ComputerUnique, tblUsers.Name


To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.