Skip to main content

SQL_ServerPrincipals Job

The SQL_ServerPrincipals Job provides information on server principals at the instance level across targeted SQL or Azure SQL servers.

Analysis Tasks for the SQL_ServerPrincipals Job​

Navigate to the Databases > SQL > 3.Users and Roles > SQL_ServerPrincipals > Configure node and select Analysis to view the analysis tasks.

CAUTION: Do not modify or deselect the selected analysis task(s). The analysis task(s) are preconfigured for this job.

Analysis Selection

The default analysis tasks are:

  • Determine user details – Creates the SA_SQL_ServerPrincipals_Details table accessible under the job’s Results node
  • Summarize by Instance – Creates the SA_SQL_ServerPrincipals_InstanceSummary table accessible under the job’s Results node

In addition to the tables and views created by the analysis tasks, the SQL_ServerPrincipals Job produces the following pre-configured report.

ReportDescriptionDefault TagsReport Elements
Server PrincipalsThis report determines all server principals on a per-instance basis. Users are considered stale if they have not authenticated to the domain in 60 days. This threshold can be configured in the 3-AD_Exceptions job in the .Active Directory Inventory job group.NoneThis report is comprised of three elements: - Bar Chart – Displays top instances - Table – Provides details on principal count by instance - Table – Provides details on principal details