Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
FrankW
Engaged Sweeper III
Hi,
i'm trying to generate a report which is showing me all local admins (local admins + domain admins + users which are added to the local administrators group) on my servers.
I've already build a report which only shows me the local users (16 times!), but i'm not sure about how the sql statement (i'm not very familiar to sql) should look like if i want to see the result i mentioned above.
Does anyone already have this report or can anyone help me out on this report?

thx in advance 🙂

-frank
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Could you try the report below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblUsersInGroup.Domainname, tblUsersInGroup.Username,
tblUsersInGroup.Groupname, tblUsersInGroup.Admingroup
From tblComputers Inner Join
tblUsersInGroup On tblComputers.Computername = tblUsersInGroup.Computername
Where tblUsersInGroup.Admingroup = 1
Order By tblComputers.ComputerUnique, tblUsersInGroup.Domainname,
tblUsersInGroup.Username

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
FrankW
Engaged Sweeper III
works! thx! 🙂
Hemoco
Lansweeper Alumni
Could you try the report below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblUsersInGroup.Domainname, tblUsersInGroup.Username,
tblUsersInGroup.Groupname, tblUsersInGroup.Admingroup
From tblComputers Inner Join
tblUsersInGroup On tblComputers.Computername = tblUsersInGroup.Computername
Where tblUsersInGroup.Admingroup = 1
Order By tblComputers.ComputerUnique, tblUsersInGroup.Domainname,
tblUsersInGroup.Username

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.

Hi, Hemoco.
The table "tblComputers" doesn´t exist. I just found tblComputersSystem and tblComputersSystemProduct.

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now