Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Report to show local administrators

I am trying to create a report that will show domain users who are members of the local "Administrators" group. Any tips?

Find more posts tagged with

Accepted answers

LGarvin

I am trying to create a report that will show domain users who are members of the local "Administrators" group.

There appears to be a 'bug' in the Groups report in Local Users, Groups, and Logon Information, and the last field "Members" is not being generated in the SQL query.

Please edit the Groups report, and drag the bottom field named "Members" to an earlier position in the field list.

This will allow the "Members" field to be properly displayed in the report, and here you will find the list of accounts that belong to each group.

Filter on SID (Group) = 'S-1-5-32-544' if you want only the local Administrators group.

All comments

LGarvin

I am trying to create a report that will show domain users who are members of the local "Administrators" group.

There appears to be a 'bug' in the Groups report in Local Users, Groups, and Logon Information, and the last field "Members" is not being generated in the SQL query.

Please edit the Groups report, and drag the bottom field named "Members" to an earlier position in the field list.

This will allow the "Members" field to be properly displayed in the report, and here you will find the list of accounts that belong to each group.

Filter on SID (Group) = 'S-1-5-32-544' if you want only the local Administrators group.

jrcollins50

Perfect! This worked. Thanks for the quick reply!

kpiccininno

Hi Lawrence,

I was asked to perform the same report. Is there a template based on this case somewhere or can you send me what is needed to create the report based on finding all Local Admins?

kpiccininno

Hi Jason,

Are you able to export this report so others can use it?

oncyte

Sorry...not really clear on how to create a report to list who are members of the local administrators group for all nodes. We purchased SAM fairly recently and still learning. Would it be possible to give a step-by-step? Cheers and thanks!