Notification

Icon
Error

Local Admin Group Members

Posted: Monday, November 3, 2014 1:41:27 PM(UTC)
kevinoie

kevinoie

Member Original PosterPosts: 8
1
Like
This issue has been solved! Click here to view the solution
Hi. I am trying to generate a report to find ALL user accounts and groups who have Local Admin rights on all pc's and servers on my domain.


I can find the report for Unathorised users but I need a report for all users and groups who have local Admin rights.

Any help would be greatly appreciated.

Thank you.

Kevin.
Lansweeper
#1Lansweeper Member Posts: 13,442  
posted: 11/4/2014 3:24:01 PM(UTC)
You can use the following report to get all local administrators.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblUsersInGroup.Username,
tblUsersInGroup.Domainname,
tblUsersInGroup.Groupname
From tblAssets
Inner Join tblUsersInGroup On tblAssets.AssetID = tblUsersInGroup.AssetID
Where tblUsersInGroup.Groupname = 'administrators'
Order By tblAssets.AssetName
kevinoie
#2kevinoie Member Original PosterPosts: 8  
posted: 11/5/2014 11:46:28 AM(UTC)
Thanks a million. Exactly what I need.
Diego Tomazzoni
#3Diego Tomazzoni Member Posts: 14  
posted: 8/27/2015 2:05:25 PM(UTC)
Very useful report, tks a lot!
S.B
#4S.B Member Posts: 7  
posted: 10/30/2018 2:42:01 PM(UTC)
Thanks a lot, works perfect.
ggbce
#5ggbce Member Posts: 4  
posted: 10/30/2020 2:28:50 PM(UTC)
Hi,

It's an old post and very useful. But because I'm in a situation where we have multiple OS languages, the "local Admin group" is not always named "Administrators". Does something is possible with LanSweeper to use the "local Group GID" to ensute is working ?

Active Discussions

Action Remote Uninstaller
by  miek_g   Go to last post Go to first unread
Last post: 10/28/2020 3:52:20 PM(UTC)
Action Setting Computer AD Description Attribute
by  DJSMC  
Go to last post Go to first unread
Last post: 10/27/2020 12:39:54 PM(UTC)
Action Open Teams/SfB Chat with user
by  marceman   Go to last post Go to first unread
Last post: 9/10/2020 4:10:18 PM(UTC)
Lansweeper Report showing app even after it has gone
by  TimHolmes1973  
Go to last post Go to first unread
Last post: 9/9/2020 11:50:17 PM(UTC)
Action Remote Device Manager
by  steveb   Go to last post Go to first unread
Last post: 9/4/2020 9:52:01 PM(UTC)
Action View Windows Defender detections remotely
by  steveb  
Go to last post Go to first unread
Last post: 9/4/2020 9:37:48 PM(UTC)
Lansweeper Filter Assets' groups by WinSystemLocale
by  Alex Beaumier   Go to last post Go to first unread
Last post: 8/20/2020 4:17:17 PM(UTC)
Action Chrome History
by  csys  
Go to last post Go to first unread
Last post: 8/14/2020 2:14:21 PM(UTC)