
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-02-2012 03:17 PM
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
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
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-03-2012 04:13 PM
Could you try the report below.
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.
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.
3 REPLIES 3

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-04-2012 01:14 PM
works! thx! 🙂

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2012 04:13 PM
Could you try the report below.
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.
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-07-2025 08:30 PM
Hi, Hemoco.
The table "tblComputers" doesn´t exist. I just found tblComputersSystem and tblComputersSystemProduct.
