MSSQL 2012: Availability Database |
Hosted |
This object represents Availability Database object. |
MSSQL 2012: Availability Database Health |
Hosted |
A hidden object, which is used to roll up the health from agents to availability database level. |
Always On Seed |
Hosted |
|
Availability Group |
Non-Hosted |
|
Availability Group Health |
Hosted |
|
Availability Replica |
Hosted |
|
Database Replica |
Hosted |
This is representation of Database Replica State SMO object |
Availability Group Critical Policy |
Hosted |
Custom User Policy which has Availability Group as Facet and one of the error categories as Policy Category. |
Availability Group Warning Policy |
Hosted |
Custom User Policy which has Availability Group as Facet and one of the warning categories as Policy Category. |
Availability Replica Critical Policy |
Hosted |
Custom User Policy which has Availability Replica as Facet and one of the error categories as Policy Category. |
Availability Replica Warning Policy |
Hosted |
Custom User Policy which has Availability Replica as Facet and one of the warning categories as Policy Category. |
Database Replica Critical Policy |
Hosted |
Custom User Policy which has Database Replica State as Facet and one of the error categories as Policy Category. |
Database Replica Warning Policy |
Hosted |
Custom User Policy which has Database Replica State as Facet and one of the warning categories as Policy Category. |
SQL Server 2012 DB Engines With Many DBs Group |
Non-Hosted, Singleton |
A group containing Microsoft SQL Server 2012 DB Engines With Many DBs |
SQL Server 2012 Local Database Group |
Hosted |
A group containing a part of databases of a particular Microsoft SQL Server 2012 DB engine |
SQL Server 2012 Installation Seed |
Hosted |
It is 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 DB Engine |
Hosted |
An installation of Microsoft SQL Server 2012 Database Engine. The database engine hosts databases and other SQL Server components. |
SQL Server 2012 DB |
Hosted |
Microsoft SQL Server 2012 database |
SQL Server 2012 Agent |
Hosted |
Microsoft SQL Server 2012 agent component |
SQL Server 2012 Reporting Services |
Hosted |
An installation of Microsoft SQL Server 2012 Reporting Services |
SQL Server 2012 Analysis Services |
Hosted |
An installation of Microsoft SQL Server 2012 Analysis Services |
SQL Server 2012 Integration Services |
Hosted |
An installation of Microsoft SQL Server 2012 Integration Services |
SQL Server 2012 Computers |
Non-Hosted, Singleton |
A group containing all Windows computers that are running a component of Microsoft SQL Server 2012. |
SQL Server 2012 DB Engine Group |
Non-Hosted, Singleton |
A group containing all instances of Microsoft SQL Server 2012 database engines |
SQL Server 2012 DB Filegroup |
Hosted |
Microsoft SQL Server 2012 database Filegroup |
SQL Server 2012 DB File |
Hosted |
Microsoft SQL Server 2012 database file |
SQL Server 2012 DB FILESTREAM Filegroup |
Hosted |
Microsoft SQL Server 2012 FILESTREAM Filegroup |
SQL Server 2012 DB Log File |
Hosted |
Microsoft SQL Server 2012 database log file |
[Deprecated] SQL Server 2012 Distributor |
Hosted |
All Microsoft SQL Server 2012 distributors. The distributor is a component used in SQL Server Replication; it is considered to be obsolete in this Management Pack. |
[Deprecated] SQL Server 2012 Publication |
Hosted |
All Microsoft SQL Server 2012 replication publications. Considered to be obsolete in this Management Pack. |
[Deprecated] SQL Server 2012 Subscription |
Hosted |
All Microsoft SQL Server 2012 replication subscriptions. Considered to be obsolete in this Management Pack. |
[Deprecated] SQL Server 2012 Publisher |
Hosted |
All Microsoft SQL Server 2012 publishers. The publisher is a component used in SQL Server Replication; it is considered to be obsolete in this Management Pack. |
[Deprecated] SQL Server 2012 Subscriber |
Hosted |
All Microsoft SQL Server 2012 subscribers. The subscriber is a component used in SQL Server Replication; it is considered to be obsolete in this Management Pack. |
[Deprecated] SQL Server 2012 Replication Computers |
Non-Hosted, Singleton |
A group containing all Windows computers running Microsoft SQL Server 2012 involved in the replication. Considered to be obsolete in this Management Pack. |
SQL Server 2012 Agent Job |
Hosted |
All Microsoft SQL Server 2012 agent jobs. |
SQL Server Express 2012 DB Engine Group |
Non-Hosted, Singleton |
A group containing all instances of Microsoft SQL Server Express 2012 database engines. |
Database Critical Policy |
Hosted |
Custom User Policy which has Database as Facet and one of the error categories as Policy Category. |
Database Warning Policy |
Hosted |
Custom User Policy which has Database as Facet and one of the warning categories as Policy Category. |
SQL Server 2012 WOW64 DB Engine Group |
Non-Hosted, Singleton |
A group containing all instances of Microsoft SQL Server 2012 WOW64 database engines |
SQL 2012 Mirrored DB |
Hosted |
Microsoft SQL Server 2012 Mirrored Database |
SQL 2012 Mirroring Witness Role |
Hosted |
Microsoft SQL Server 2012 Database Mirroring Witness Role. |
SQL 2012 Mirrored DB Witness |
Hosted |
Microsoft SQL Server 2012 Mirrored Database Witness |
SQL 2012 Mirroring Group |
Non-Hosted |
Microsoft SQL Server 2012 Mirroring Group |
SQL 2012 Mirroring Service |
Non-Hosted, Singleton |
Microsoft SQL Server 2012 Mirroring Service |
SQL Server Always On Availability Group |
Non-Hosted, Singleton |
This group contains Microsoft SQL Server Always On Availability components |
SQL Server Always On Availability Replicas Group |
Non-Hosted, Singleton |
This group contains Microsoft SQL Server Always On Availability Replica components |
SQL Server Always On Database Replicas Group |
Non-Hosted, Singleton |
This group contains Microsoft SQL Server Always On Database Replicas components |
SQL Server Always On High Availability Group |
Non-Hosted, Singleton |
This group contains Microsoft SQL Server Always On Availability components |
SSAS Instance Group |
Non-Hosted, Singleton |
This object discovery populates the SQL Server Analysis Services Group with all components that relate to Analysis Services. |
Azure SQL Cloud Services |
Non-Hosted, Singleton |
A group containing Azure SQL Cloud Services |
Azure SQL Database Cloud Services |
Non-Hosted, Singleton |
A group containing Azure SQL Database Cloud Services |
SQL Server Computers |
Non-Hosted, Singleton |
This group contains all Windows computers that are running a component of Microsoft SQL Server |
SQL Server Mirroring Components |
Non-Hosted, Singleton |
This group contains Microsoft SQL Server Mirroring components |
SQL Server Mirroring Groups |
Non-Hosted, Singleton |
This group contains Microsoft SQL Server Mirroring groups |
Replication Database Health Group |
Non-Hosted, Singleton |
Replication Database Health Group is group of Replication Database Health objects |
Server Roles Group |
Non-Hosted, Singleton |
Server Roles Group contains all SQL Server root objects such as Database Engine, Analysis Services instance or Reporting Service instance. |
SQL Server Alerts Scope Group |
Non-Hosted, Singleton |
SQL Server Alerts Scope Group contains SQL Server objects which can throw alerts. |
SQL Server DB Engine Group |
Non-Hosted, Singleton |
This group containing all instances of Microsoft SQL Server database engines |
SQL Server Integration Services Group |
Non-Hosted, Singleton |
This group containing all instances of Microsoft SQL Server Integration Services |
SQL Server Analysis Services Alerts Scope Group |
Non-Hosted, Singleton |
SQL Server Analysis Services Alerts Scope Group contains SQL Server Analysis Services objects which can throw alerts. |
Analysis Services Database Group |
Non-Hosted, Singleton |
Analysis Services Database Group contains all SQL Server root objects such as Analysis Services instance. |
Analysis Services Server Roles Group |
Non-Hosted, Singleton |
Analysis Services Server Roles Group contains all SQL Server root objects such as Analysis Services instance. |
SSRS: Deployment Group |
Non-Hosted, Singleton |
This object discovery populates the Local Deployment group to contain all SQL Server Reporting Services Roles. |
SSRS: Instance Group |
Non-Hosted, Singleton |
This object discovery populates the Local Instance group to contain all SQL Server Reporting Services Roles. |
SQL Server Alerts Scope Group L3 |
Non-Hosted, Singleton |
This object is used to collect alerts. |
Group of Always On High Availability Groups |
Non-Hosted, Singleton |
A group containing all Always On High Availability groups of Microsoft SQL Server 2012 |
Group of Availability Groups |
Non-Hosted, Singleton |
A group containing all Availability Groups of Microsoft SQL Server 2012 |
Group of Availability Replicas |
Non-Hosted, Singleton |
A group containing all Availability Replicas of Microsoft SQL Server 2012 |
Group of Database Replicas |
Non-Hosted, Singleton |
A group containing all Database Replicas of Microsoft SQL Server 2012 |
SQL Server Event Log Collection Target |
Hosted |
This object is used to collect errors from event log of computers that have SQL Server components. |
SQL Server 2008 Instance Group |
Non-Hosted, Singleton |
A group containing all SQL Server 2008 DB Engine Instances |
SQL Server 2008 Databases Group |
Non-Hosted, Singleton |
A group containing all SQL Server 2008 databases |
SQL Server 2008 Agents Group |
Non-Hosted, Singleton |
A group containing all SQL Server 2008 agents |
SQL Server 2008 Mirroring Groups Group |
Non-Hosted, Singleton |
A group containing all SQL Server 2008 Mirroring groups |
SQL Server 2008 Integration Services Group |
Non-Hosted, Singleton |
A group containing all SQL Server 2008 Integration Services |
SQL Server 2012 Instance Group |
Non-Hosted, Singleton |
A group containing all SQL Server 2012 DB Engine Instances |
SQL Server 2012 Databases Group |
Non-Hosted, Singleton |
A group containing all SQL Server 2012 databases |
SQL Server 2012 Agents Group |
Non-Hosted, Singleton |
A group containing all SQL Server 2012 agents |
SQL Server 2012 Mirroring Groups Group |
Non-Hosted, Singleton |
A group containing all SQL Server 2012 Mirroring groups |
SQL Server 2012 Integration Services Group |
Non-Hosted, Singleton |
A group containing all SQL Server 2012 Integration Services |
SQL DB Engine |
Hosted |
An installation of Microsoft SQL Server 2008, 2008 R2 or 2012 Database Engine. |
SQL Database |
Hosted |
All Microsoft SQL Server 2008, 2008 R2, and 2012 databases. |
SQL Computers |
Non-Hosted, Singleton |
A group containing all Windows computers that are running a component of Microsoft SQL Server 2008, 2008 R2 or 2012. |
SQL Instances |
Non-Hosted, Singleton |
A group containing all instances of Microsoft SQL Server 2008, 2008 R2 or 2012. |
SQL Components |
Non-Hosted, Singleton |
A group containing all components related to Microsoft SQL Server 2008, 2008 R2 or 2012. |
SQL Server Databases |
Non-Hosted, Singleton |
SQL Server Databases. |
SQL Server Agents |
Non-Hosted, Singleton |
SQL Server Agents. |