• Management Pack:  SQL Server 2012
  • MP Version:  7.0.4.0
  • Released:  4/18/2018
  • Publisher:  Microsoft

Discoveries

Name Enabled Target Class Description
  [Deprecated] Discover Replication Components
0
 
SQL Server 2012 DB Engine This object discovery discovers all SQL Server Replication components on an SQL Server 2012 DB Engine. The discovery is disabled by default. Considered to be obsolete in this Management Pack.
  [Deprecated] Populate Microsoft SQL Server 2012 Replication Computers Group
0
 
[Deprecated] SQL Server 2012 Replication Computers This object discovery populates SQL Server 2012 Replication Component computer group with all computers that are running an instance of SQL Server 2012 DB Engine and have some replication components configured. Considered to be obsolete in this Management Pack.
  [Deprecated] SQL Server 2012 Replication Publications and Subscriptions Discovery Provider
0
 
SQL Server 2012 DB Engine This object discovery discovers replication publications and subscriptions for each SQL Server 2012 database. The discovery is disabled by default. Considered to be obsolete in this Management Pack.
  Alerts Scope Group Discovery
1
 
SQL Server Alerts Scope Group This object discovery populates the Alerts Scope group to contain all SQL Server Roles.
  Alerts Scope Group L3 Discovery
1
 
SQL Server Alerts Scope Group L3 This object discovery populates the Alerts Scope group L3 to contain all SQL Availability Groups.
  Alerts Scope Group L3 Discovery
1
 
SQL Server Alerts Scope Group L3 This object discovery populates the Alerts Scope group L3 to contain all SQL Server Roles.
  Discover Database Mirroring direction
1
 
SQL 2012 Mirroring Group This object discovery discovers SQL Server 2012 Database Mirroring direction.
  Discover Databases for a Database Engine
1
 
SQL Server 2012 DB Engine This object discovery discovers all databases running for a given instance of SQL Server 2012 DB Engine. By default, all databases are discovered and monitored. You can override the discovery to exclude one or more databases from being discovered using the Exclude List. This list takes a comma-separated list of database names or * wildcard to exclude all databases.
  Discover Filegroups
1
 
SQL Server 2012 DB Engine This object discovery discovers the Filegroup information for each SQL Server 2012 Database.
  Discover Files
1
 
SQL Server 2012 DB Engine This object discovery discovers the file information for each SQL Server 2012 Database. The discovery is used in specific databases or DB Engine instances, where a deeper file monitoring is required.
  Discover Mirrored Databases for a Database Engine
1
 
SQL Server 2012 DB Engine This object discovery discovers all mirrored databases running for a given instance of SQL Server 2012 DB Engine. By default, all mirrored databases are discovered and monitored. You can override the discovery to exclude one or more databases from being discovered using the Exclude List. This list takes a comma-separated list of database names or * wildcard to exclude all databases.
  Discover Mirrored Databases Witnesses
1
 
SQL Server 2012 DB Engine This object discovery discovers all mirrored databases witnesses running for a given instance of SQL Server 2012 DB Engine. By default witnesses for all mirrored databases are discovered and monitored. You can override the discovery to exclude one or more databases from being discovered using the Exclude List. This list takes a comma-separated list of database names or * wildcard to exclude all databases.
  Discover SQL Server 2012 Agent Jobs
0
 
SQL Server 2012 Agent This object discovery discovers all SQL Server 2012 Agent jobs. The discovery is disabled by default.
  Discover SQL Server 2012 Analysis Services (Windows Server)
0
 
SQL Server 2012 Installation Seed This object discovery discovers all instances of SQL Server 2012 Analysis Services. By default, all instances are discovered and monitored.
  Discover SQL Server 2012 Database Engines (Windows Server)
1
 
SQL Server 2012 Installation Seed This object discovery discovers all instances of SQL Server 2012 DB Engine running on Windows Servers. By default, all instances are discovered and monitored. You can override the discovery to exclude one or more instances from being discovered using the Exclude List. This list takes a comma-separated list of instances or * wildcard to exclude all instances.
  Discover SQL Server 2012 Integration Services (Windows Server)
1
 
SQL Server 2012 Installation Seed This object discovery discovers if SQL Server 2012 Integrate Services is installed.
  Discover SQL Server 2012 Mirroring Service
1
 
SQL 2012 Mirroring Service This object discovery populates Microsoft SQL Server 2012 Mirroring Service with Mirroring Groups.
  Discover SQL Server 2012 Reporting Services (Windows Server)
0
 
SQL Server 2012 Installation Seed This object discovery discovers all instances of SQL Server 2012 Reporting Services. By default, all instances are discovered and monitored.
  Discover SQL Server Agent for a DB Engine
1
 
SQL Server 2012 DB Engine This object discovery discovers the SQL Server Agent for an instance of SQL Server 2012 DB Engine. There will always be one SQL Server Agent instance for each DB Engine instance.
  Discover SQL Server Components Group membership
1
 
SQL Components Populates the Components group with all SQL Server 2008, 2008 R2 and 2012 related components.
  Discover SQL Server Computer Group membership
1
 
SQL Server Computers Populates the computer group to contain all computers running SQL Server 2008, 2008 R2 or 2012.
  Discover SQL Server Computer Group membership
1
 
SQL Computers Populates the computer group to contain all computers running SQL Server
  Discover SQL Server Instance Group membership
1
 
SQL Instances Populates the Instance group to contain all SQL Server 2008, 2008 R2 and 2012 DB Engines
  MSSQL : SQL Server Always On High Availability Group Discovery
1
 
SQL Server Always On High Availability Group This object discovery populates the Always On High Availability Group to contain all SQL Server Always On Availability groups.
  MSSQL 2012: Alerts Scope Group Seed Discovery
1
 
SQL Server Alerts Scope Group This object discovery populates the Alerts Scope group to contain all SQL Server 2012 Installation Seeds.
  MSSQL 2012: Always On Seed Discovery
1
 
SQL Server 2012 DB Engine This discovery is used to define which machines have Always On enabled.
  MSSQL 2012: Database Replicas Always On Discovery
1
 
Availability Group Health Discovery of database replica Always On objects
  MSSQL 2012: Discover Data Files
1
 
SQL Server 2012 Local Database Group This discovery rule discovers the file information for each SQL Server 2012 Database.
  MSSQL 2012: Discover DB Group Seed
0
 
SQL Server 2012 DB Engine This discovery rule discovers the file information for each SQL Server 2012 Database.
  MSSQL 2012: General Always On Discovery
1
 
Always On Seed Discovery of Always On objects
  MSSQL 2012: General Custom User Policy Discovery
0
 
Availability Group Health Discovery of Custom User Policies for Always On objects
  MSSQL 2012: Mirroring Common Group Discovery
1
 
SQL Server Mirroring Components This object discovery populates the Mirroring Common group to contain all SQL Server Mirroring components.
  MSSQL 2012: Mirroring Group Discovery
1
 
SQL Server Mirroring Groups This object discovery populates the Mirroring Group to contain all SQL Server Mirroring groups.
  MSSQL 2012: Populate SQL Server 2012 Agents Group
1
 
SQL Server 2012 Agents Group This discovery rule populates SQL Server 2012 Agents group with all SQL Server 2012 agents.
  MSSQL 2012: Populate SQL Server 2012 Databases Group
1
 
SQL Server 2012 Databases Group This discovery rule populates SQL Server 2012 Databases group with all SQL Server 2012 databases.
  MSSQL 2012: Populate SQL Server 2012 DB Engines With Many DBs Group
1
 
SQL Server 2012 DB Engines With Many DBs Group This discovery rule populates the SQL Server 2012 DB Engines With Many DBs Group with all SQL Server 2012 DB Engines with many DBs.
  MSSQL 2012: Populate SQL Server 2012 Instance Group
1
 
SQL Server 2012 Instance Group This discovery rule populates SQL Server 2012 Instance group with all SQL Server 2012 DB Engines.
  MSSQL 2012: Populate SQL Server 2012 Integration Services Group
1
 
SQL Server 2012 Integration Services Group This discovery rule populates SQL Server 2012 Integration Services Group with all SQL Server 2012 Integration Services.
  MSSQL 2012: Populate SQL Server 2012 Mirroring Groups Group
1
 
SQL Server 2012 Mirroring Groups Group This discovery rule populates SQL Server 2012 Mirroring Groups Group group with all SQL Server 2012 Mirroring Groups.
  MSSQL 2012: Populate SQL Server Express 2012 Instance Group
1
 
SQL Server Express 2012 DB Engine Group This discovery rule populates SQL Server 2012 Express Instance group with all SQL Server Express 2012 DB Engines.
  MSSQL 2012: SQL Server Always On Database Replicas Discovery
1
 
SQL Server Always On Database Replicas Group This object discovery populates Always On Database Replicas to contain all SQL Server Database Replicas.
  MSSQL 2012: SQL Server Always On Groups Discovery
1
 
SQL Server Always On Availability Group This object discovery populates the Always On Groups to contain all SQL Server Availability Groups.
  MSSQL 2012: SQL Server Always On High Availability Group Discovery
1
 
Group of Always On High Availability Groups This object discovery populates Always On High Availability Group to contain all SQL Server 2012 Always On Availability groups.
  MSSQL 2012: SQL Server Always On Replicas Discovery
1
 
SQL Server Always On Availability Replicas Group This object discovery populates Always On Replicas to contain all SQL Server Availability Replicas.
  MSSQL: Populate SQL Server Agent Group
1
 
SQL Server Agents This discovery rule populates the Agent group with all SQL Server 2008, 2008 R2 and 2012 Agents.
  MSSQL: Populate SQL Server Database Group
1
 
SQL Server Databases This discovery rule populates the Database group with all SQL Server 2008, 2008 R2 and 2012 Databases.
  MSSQL: Populate SQL Server Instance Group
1
 
SQL Server DB Engine Group This discovery rule populates the Instance group with all SQL Server DB Engines.
  MSSQL: Populate SQL Server Instance Group
1
 
SQL Server Integration Services Group This discovery rule populates the Instance group with all SQL Server Integration Services.
  Populate Microsoft SQL Server 2012 Computer Group
1
 
SQL Server 2012 Computers This object discovery populates SQL Server 2012 Computer Group with all computers that are running one or more components of SQL Server 2012.
  Populate Microsoft SQL Server 2012 Instance Group
1
 
SQL Server 2012 DB Engine Group This object discovery populates SQL Server 2012 Instance Group with all SQL Server 2012 DB Engine.
  Populate SQL Availability Group
1
 
Group of Availability Groups This discovery rule populates the Availability Group.
  Populate SQL Availability Replica Group
1
 
Group of Availability Replicas This discovery rule populates the Availability Replica Group.
  Populate SQL Database Replica Group
1
 
Group of Database Replicas This discovery rule populates the Database Replica Group.
  Server Roles Group Discovery
1
 
Server Roles Group This object discovery populates the Server Roles group to contain all SQL Server Roles.
  SQL Server 2012 Database Custom User Policy Discovery
0
 
SQL Server 2012 DB Engine Discovery of Custom User Policies for SQL Server 2012 Database
  SQL Server 2012 DB Installation Discovery Source
1
 
Windows Server This object discovery discovers a seed for Microsoft SQL Server 2012 installation. This object indicates that the particular server computer contains Microsoft SQL Server 2012 installation.
  SQL Server 2012 Event Log Collection Target Discovery
1
 
SQL Server 2012 Installation Seed This discovery rule discovers an event log collection target for a Microsoft SQL Server 2012. This object is used to collect module errors from event log of computers that have SQL Server 2012 components.

See Also for SQL Server 2012 Management Pack


Downloads for SQL Server 2012 Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED