Skip to main content

SG_LocalAdmins Job

The SG_LocalAdmins job identifies the effective membership for all local administrator groups. The purpose of this job is to gain an understanding of what accounts within the environment are privileged and should be monitored closely.

Queries for the SG_LocalAdmins Job

The SG_LocalAdmins job uses the UsersGroups Data Collector for the following query:

CAUTION: The query is preconfigured for this job. Never modify the query.

Queries for the SG_LocalAdmins Job

The query for the SG_LocalAdmins job is:

  • Direct Membership – Returns direct membership from targeted hosts

Analysis Tasks for the SG_LocalAdmins Job

Navigate to the Windows > Privileged Accounts > Local Administrators > SG_LocalAdmins > Configure node and select Analysis to view the analysis tasks.

CAUTION: Do not modify or deselect the selected analysis tasks. The analysis tasks are preconfigured for this job.

Analysis Tasks for the SG_LocalAdmins Job

The default analysis tasks are:

  • Expand Effective Membership – Creates the SA_SG_LocalAdmins_Details table accessible under the job’s Results node
  • Membership Summary – Creates the SA_SG_LocalAdmins_MembershipSummary table accessible under the job’s Results node
  • Privileged Accounts – Creates the SA_SG_LocalAdmins_PrivilegedAccounts table accessible under the job’s Results node
  • Track Changes – Creates the SA_SG_LocalAdmins_Changes table accessible under the job’s Results node

In addition to the tables created by the analysis tasks, the SG_LocalAdmins job produces the following pre-configured reports.

ReportDescriptionDefault TagsReport Elements
Local AdministratorsThis report identifies servers with the largest local administrator groups in the environment.GDPR, SOX, HIPAA, PCI-DSS, GLBA, ITAR, FERPA, FISMA, ISO27001This report is comprised of three elements: - Stacked Chart – Displays largest local administrator groups - Table – Provides membership details - Table – Provides a local administrator groups summary
Membership ChangesThis report identifies changes in effective membership between two scans of the environment.NoneThis report is comprised of one element: - Table – Displays membership changes
Privileged AccountsThis report highlights user accounts with a large number of local administrator rights.NoneThis report is comprised of two elements: - Stacked Chart – Displays top trustees by administrator rights - Table – Provides details on privileged accounts

Least Privilege Model

The SG_LocalAdmins job typically uses an account that is a member of the Local Administrators group on the target host. However if a less-privileged option is required, you can instead use a regular domain user that has been added to the Network access: Restrict clients allowed to make remote calls to SAM Local Security Policy.

User added to the Local Securtiy Policy