Microsoft SQL Server 2012 (Discovery)

Microsoft.SQLServer.2012.Discovery :: 7.0.7.0 (Management Pack)

Microsoft SQL Server 2012 Management Pack. This Management Pack will discover Microsoft SQL Server 2012. The management pack only contains the discovery logic, and requires a separate monitoring management pack to be imported to monitor the discovered objects.

• Show Management Pack XML
• Get Management Pack data in Excel format
• Download: Microsoft.SQLServer.2012.Discovery.mp

Management Pack Elements

Classes (27)

	DisplayName	ID	Base Class	Abstract	Hosted	Singleton	Group	Extension	Accessibility
	SQL Server 2012 Agent	Microsoft.SQLServer.2012.Agent	Microsoft.SQLServer.Agent	False	True	False	False	False	Public
	SQL Server 2012 Agent Job	Microsoft.SQLServer.2012.AgentJob	Microsoft.SQLServer.AgentJob	False	True	False	False	False	Public
	SQL Server 2012 Analysis Services	Microsoft.SQLServer.2012.AnalysisServices	Microsoft.SQLServer.AnalysisServices	False	True	False	False	False	Public
	SQL Server 2012 Computers	Microsoft.SQLServer.2012.ComputerGroup	Microsoft.SystemCenter.ComputerGroup	False	False	True	True	False	Public
	SQL Server 2012 DB	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.Database	False	True	False	False	False	Public
	Database Critical Policy	Microsoft.SQLServer.2012.DatabaseErrorUserPolicy	Microsoft.SQLServer.2012.Policy	False	True	False	False	False	Public
	Database Warning Policy	Microsoft.SQLServer.2012.DatabaseWarningUserPolicy	Microsoft.SQLServer.2012.Policy	False	True	False	False	False	Public
	SQL Server 2012 DB Engine	Microsoft.SQLServer.2012.DBEngine	Microsoft.SQLServer.DBEngine	False	True	False	False	False	Public
	SQL Server 2012 DB Engines With Many DBs Group	Microsoft.SQLServer.2012.DBEnginesWithManyDBsGroup	System.Group	False	False	True	True	False	Public
	SQL Server 2012 DB File	Microsoft.SQLServer.2012.DBFile	Microsoft.SQLServer.DBFile	False	True	False	False	False	Public
	SQL Server 2012 DB Filegroup	Microsoft.SQLServer.2012.DBFileGroup	Microsoft.SQLServer.DBFileGroup	False	True	False	False	False	Public
	SQL Server 2012 DB FILESTREAM Filegroup	Microsoft.SQLServer.2012.DBFileGroupFd	Microsoft.SQLServer.DBFileGroupFd	False	True	False	False	False	Public
	SQL Server 2012 Local Database Group	Microsoft.SQLServer.2012.DBFilesPartitionSeed	System.Entity	False	True	False	False	False	Public
	SQL Server 2012 DB Log File	Microsoft.SQLServer.2012.DBLogFile	Microsoft.SQLServer.DBFile	False	True	False	False	False	Public
	[Deprecated] SQL Server 2012 Distributor	Microsoft.SQLServer.2012.Distributor	Microsoft.SQLServer.Distributor	False	True	False	False	False	Public
	SQL Server Express 2012 DB Engine Group	Microsoft.SQLServer.2012.ExpressInstancesGroup	System.Group	False	False	True	True	False	Public
	SQL Server 2012 DB Engine Group	Microsoft.SQLServer.2012.InstanceGroup	System.Group	False	False	True	True	False	Public
	SQL Server 2012 Integration Services	Microsoft.SQLServer.2012.IntegrationServices	Microsoft.SQLServer.IntegrationServices	False	True	False	False	False	Public
	SQL Server 2012 Custom User Policy	Microsoft.SQLServer.2012.Policy	Microsoft.SQLServer.Component	True	False	False	False	False	Public
	[Deprecated] SQL Server 2012 Publication	Microsoft.SQLServer.2012.Publication	Microsoft.SQLServer.Publication	False	True	False	False	False	Public
	[Deprecated] SQL Server 2012 Publisher	Microsoft.SQLServer.2012.Publisher	Microsoft.SQLServer.Publisher	False	True	False	False	False	Public
	[Deprecated] SQL Server 2012 Replication Computers	Microsoft.SQLServer.2012.ReplicationComputerGroup	Microsoft.SystemCenter.ComputerGroup	False	False	True	True	False	Public
	SQL Server 2012 Reporting Services	Microsoft.SQLServer.2012.ReportingServices	Microsoft.SQLServer.ReportingServices	False	True	False	False	False	Public
	SQL Server 2012 Installation Seed	Microsoft.SQLServer.2012.Seed	Microsoft.Windows.ApplicationComponent	False	True	False	False	False	Public
	[Deprecated] SQL Server 2012 Subscriber	Microsoft.SQLServer.2012.Subscriber	Microsoft.SQLServer.Subscriber	False	True	False	False	False	Public
	[Deprecated] SQL Server 2012 Subscription	Microsoft.SQLServer.2012.Subscription	Microsoft.SQLServer.Subscription	False	True	False	False	False	Public
	SQL Server 2012 WOW64 DB Engine Group	Microsoft.SQLServer.2012.Wow64InstanceGroup	System.Group	False	False	True	True	False	Public

Relationship Types (26)

	DisplayName	ID	Source	Target	Accessibility	Abstract
	SQL Server 2012 Agent Hosts Agent Job	Microsoft.SQLServer.2012.AgentHostsAgentJob	Microsoft.SQLServer.2012.Agent	Microsoft.SQLServer.2012.AgentJob	Public	False
	SQL Server 2012 Agents Group Contains Agent	Microsoft.SQLServer.2012.AgentsGroupContainsAgent	Microsoft.SQLServer.2012.AgentsGroup	Microsoft.SQLServer.2012.Agent	Public	False
	SQL Server 2012 Database hosts Critical User Policy	Microsoft.SQLServer.2012.DatabaseHostsDBErrorUserPolicy	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.DatabaseErrorUserPolicy	Public	False
	SQL Server 2012 Database hosts Warning User Policy	Microsoft.SQLServer.2012.DatabaseHostsDBWarningUserPolicy	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.DatabaseWarningUserPolicy	Public	False
	SQL Server 2012 Database Hosts Publication	Microsoft.SQLServer.2012.DatabaseHostsPublication	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.Publication	Public	False
	SQL Server 2012 Database Hosts Subscription	Microsoft.SQLServer.2012.DatabaseHostsSubscription	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.Subscription	Public	False
	SQL Server 2012 Databases Group Contains Database	Microsoft.SQLServer.2012.DatabasesGroupContainsDatabase	Microsoft.SQLServer.2012.DatabasesGroup	Microsoft.SQLServer.2012.Database	Public	False
	MSSQL 2012: SQL Server 2012 Database Engine Hosts SQL Database Local Group	Microsoft.SQLServer.2012.DBEngineHostsDBFilesPartitionSeed	Microsoft.SQLServer.2012.DBEngine	Microsoft.SQLServer.2012.DBFilesPartitionSeed	Public	False
	SQL Server 2012 Database Engine Hosts Distributor	Microsoft.SQLServer.2012.DBEngineHostsDistributor	Microsoft.SQLServer.2012.DBEngine	Microsoft.SQLServer.2012.Distributor	Public	False
	SQL Server 2012 Database Engine Hosts Publisher	Microsoft.SQLServer.2012.DBEngineHostsPublisher	Microsoft.SQLServer.2012.DBEngine	Microsoft.SQLServer.2012.Publisher	Public	False
	SQL Server 2012 Database Engine Hosts SQL Server 2012 Agent	Microsoft.SQLServer.2012.DBEngineHostsSQLAgent	Microsoft.SQLServer.2012.DBEngine	Microsoft.SQLServer.2012.Agent	Public	False
	SQL Server 2012 Database Engine Hosts Subscriber	Microsoft.SQLServer.2012.DBEngineHostsSubscriber	Microsoft.SQLServer.2012.DBEngine	Microsoft.SQLServer.2012.Subscriber	Public	False
	MSSQL 2012: SQL Server 2012 DB Engines With Many DBs Group Contains DB Engines	Microsoft.SQLServer.2012.DBEnginesWithManyDBsGroupContainsDBEngine	Microsoft.SQLServer.2012.DBEnginesWithManyDBsGroup	Microsoft.SQLServer.2012.DBEngine	Public	False
	SQL Server 2012 Filegroup Hosts File	Microsoft.SQLServer.2012.DBFileGroupHostsDBFile	Microsoft.SQLServer.2012.DBFileGroup	Microsoft.SQLServer.2012.DBFile	Public	False
	SQL Server 2012 Database File Runs on Logical Disk	Microsoft.SQLServer.2012.DBFileToLogicalDisk	Microsoft.SQLServer.2012.DBFile	Microsoft.Windows.LogicalDisk	Public	False
	SQL Server 2012 Database Hosts Filegroup	Microsoft.SQLServer.2012.DBHostsFileGroup	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.DBFileGroup	Public	False
	SQL Server 2012 Database Hosts Log File	Microsoft.SQLServer.2012.DBHostsLogFile	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.DBLogFile	Public	False
	SQL Server 2012 Distributer Contains SQL Server 2012 Database	Microsoft.SQLServer.2012.DistributorContainsDatabase	Microsoft.SQLServer.2012.Distributor	Microsoft.SQLServer.2012.Database	Public	False
	SQL Server Express 2012 Instances Group Contains DB Engine	Microsoft.SQLServer.2012.ExpressInstancesGroupContainsDBEngine	Microsoft.SQLServer.2012.ExpressInstancesGroup	Microsoft.SQLServer.2012.DBEngine	Public	False
	SQL Server 2012 Instance Group Contains Instances	Microsoft.SQLServer.2012.InstanceGroupContainsDBEngine	Microsoft.SQLServer.2012.InstanceGroup	Microsoft.SQLServer.2012.DBEngine	Public	False
	SQL Server 2012 Instances Group Contains DB Engine	Microsoft.SQLServer.2012.InstancesGroupContainsDBEngine	Microsoft.SQLServer.2012.InstancesGroup	Microsoft.SQLServer.2012.DBEngine	Public	False
	SQL Server 2012 Integration Services Group Contains Integration Services	Microsoft.SQLServer.2012.IntegrationServicesGroupContainsIntegrationServices	Microsoft.SQLServer.2012.IntegrationServicesGroup	Microsoft.SQLServer.2012.IntegrationServices	Public	False
	Alerts Scope Group Contains 2012 Seed Relationship	Microsoft.SQLServer.2012.Relationships.AlertsScopeGroupContainsSeed	Microsoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroup	Microsoft.SQLServer.2012.Seed	Internal	False
	SQL Server 2012 Database Hosts FILESTREAM Filegroup	Microsoft.SQLServer.2012.RelationshipType.DBHostsDBFileGroupFd	Microsoft.SQLServer.2012.Database	Microsoft.SQLServer.2012.DBFileGroupFd	Public	False
	Server Computer Hosts SQL Server 2012 Installation Seed	Microsoft.SQLServer.2012.ServerComputerHostsSeed	Microsoft.Windows.Server.Computer	Microsoft.SQLServer.2012.Seed	Public	False
	MSSQL 2012: SQL Server 2012 WOW64 Instance Group Contains Instances	Microsoft.SQLServer.2012.Wow64InstanceGroupContainsDBEngine	Microsoft.SQLServer.2012.Wow64InstanceGroup	Microsoft.SQLServer.2012.DBEngine	Public	False

DataSource Modules (14)

	DisplayName	ID	Isolation	Accessibility
	SQL Server Agent Job Discovery	Microsoft.SQLServer.2012.AgentJobDiscovery	Any	Internal
	SQL Server 2012 DB Analysis Services Discovery Source	Microsoft.SQLServer.2012.AnalysisServicesDiscovery	Any	Internal
	Data Source Event Log Collection Target	Microsoft.SQLServer.2012.DataSource.EventLogCollectionTarget	Any	Internal
	SQL Server 2012 Database Discovery	Microsoft.SQLServer.2012.DBDiscovery	Any	Internal
	SQL Server 2012 DB Engine Discovery Source	Microsoft.SQLServer.2012.DBEngineDiscovery	Any	Internal
	SQL Server 2012 Database Filegroup Discovery	Microsoft.SQLServer.2012.DBFileGroupDiscovery	Any	Internal
	SQL Server 2012 Database File Discovery	Microsoft.SQLServer.2012.DBFilesDiscovery	Any	Internal
	SQL Server 2012 Database File Discovery	Microsoft.SQLServer.2012.DBFilesPartitionSeedDiscovery	Any	Internal
	User Policy Discovery Data Source	Microsoft.SQLServer.2012.DBUserPolicyDiscovery	Any	Internal
	SQL Server 2012 Integration Services Discovery Data Source	Microsoft.SQLServer.2012.IntegrationServicesDiscoveryDataSource	Any	Internal
	SQL Server 2012 OLE DB Discovery Provider	Microsoft.SQLServer.2012.OleDBDiscoveryProvider	Any	Internal
	[Deprecated] SQL Server 2012 Replication Component Discovery Provider	Microsoft.SQLServer.2012.ReplicationComponentDiscovery	Any	Internal
	[Deprecated] SQL Server 2012 Replication Publications and Subscriptions Discovery Provider	Microsoft.SQLServer.2012.ReplicationPublicationsSubscriptionsDiscovery	Any	Internal
	SQL Server 2012 DB Reporting Services Discovery Source	Microsoft.SQLServer.2012.ReportingServicesDiscovery	Any	Internal

ProbeAction Modules (4)

	DisplayName	ID	Isolation	Accessibility
	DB Filegroup Script Probe Discovery	Microsoft.SQLServer.2012.DBFileGroupScriptProbeDiscovery	Any	Internal
	DB Files Script Probe Discovery	Microsoft.SQLServer.2012.DBFilesPartitionSeedProbeDiscovery	Any	Internal
	DB Files Script Probe Discovery	Microsoft.SQLServer.2012.DBFilesScriptProbeDiscovery	Any	Internal
	User Policy Script Probe Discovery	Microsoft.SQLServer.2012.DBUserPolicyScriptProbeDiscovery	Any	Internal

Discoveries (26)

	DisplayName	ID	Target	Enabled
	Discover SQL Server Agent for a DB Engine	Microsoft.SQLServer.2012.AgentDiscovery	Microsoft.SQLServer.2012.DBEngine	True
	Discover SQL Server 2012 Agent Jobs	Microsoft.SQLServer.2012.AgentJobDiscoveryRule	Microsoft.SQLServer.2012.Agent	False
	MSSQL 2012: Populate SQL Server 2012 Agents Group	Microsoft.SQLServer.2012.AgentsGroup.Discovery	Microsoft.SQLServer.2012.AgentsGroup	True
	MSSQL 2012: Alerts Scope Group Seed Discovery	Microsoft.SQLServer.2012.AlertsScopeGroupSeedDiscovery	Microsoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroup	True
	Discover SQL Server 2012 Analysis Services (Windows Server)	Microsoft.SQLServer.2012.AnalysisServicesDiscoveryRule.Server	Microsoft.SQLServer.2012.Seed	False
	Discover Databases for a Database Engine	Microsoft.SQLServer.2012.DatabaseDiscoveryRule	Microsoft.SQLServer.2012.DBEngine	True
	MSSQL 2012: Populate SQL Server 2012 Databases Group	Microsoft.SQLServer.2012.DatabasesGroup.Discovery	Microsoft.SQLServer.2012.DatabasesGroup	True
	SQL Server 2012 Database Custom User Policy Discovery	Microsoft.SQLServer.2012.DatabaseUserPolicyDiscoveryRule	Microsoft.SQLServer.2012.DBEngine	False
	Discover SQL Server 2012 Database Engines (Windows Server)	Microsoft.SQLServer.2012.DBEngineDiscoveryRule.Server	Microsoft.SQLServer.2012.Seed	True
	MSSQL 2012: Populate SQL Server 2012 DB Engines With Many DBs Group	Microsoft.SQLServer.2012.DBEnginesWithManyDBsGroupDiscovery	Microsoft.SQLServer.2012.DBEnginesWithManyDBsGroup	True
	Discover Filegroups	Microsoft.SQLServer.2012.DBFileGroupDiscoveryRule	Microsoft.SQLServer.2012.DBEngine	True
	Discover Files	Microsoft.SQLServer.2012.DBFilesDiscoveryRule	Microsoft.SQLServer.2012.DBEngine	True
	MSSQL 2012: Discover Data Files	Microsoft.SQLServer.2012.Discovery.DBFile.Partitioned	Microsoft.SQLServer.2012.DBFilesPartitionSeed	True
	MSSQL 2012: Discover DB Group Seed	Microsoft.SQLServer.2012.Discovery.DBFilesPartitionSeed	Microsoft.SQLServer.2012.DBEngine	False
	SQL Server 2012 Event Log Collection Target Discovery	Microsoft.SQLServer.2012.Discovery.EventLogCollectionTarget	Microsoft.SQLServer.2012.Seed	True
	MSSQL 2012: Populate SQL Server Express 2012 Instance Group	Microsoft.SQLServer.2012.ExpressInstancesGroup.Discovery	Microsoft.SQLServer.2012.ExpressInstancesGroup	True
	MSSQL 2012: Populate SQL Server 2012 Instance Group	Microsoft.SQLServer.2012.InstancesGroup.Discovery	Microsoft.SQLServer.2012.InstancesGroup	True
	Discover SQL Server 2012 Integration Services (Windows Server)	Microsoft.SQLServer.2012.IntegrationServicesDiscoveryRule.Server	Microsoft.SQLServer.2012.Seed	True
	MSSQL 2012: Populate SQL Server 2012 Integration Services Group	Microsoft.SQLServer.2012.IntegrationServicesGroup.Discovery	Microsoft.SQLServer.2012.IntegrationServicesGroup	True
	Populate Microsoft SQL Server 2012 Computer Group	Microsoft.SQLServer.2012.PopulateSQLServersComputerGroup	Microsoft.SQLServer.2012.ComputerGroup	True
	Populate Microsoft SQL Server 2012 Instance Group	Microsoft.SQLServer.2012.PopulateSQLServersInstanceGroup	Microsoft.SQLServer.2012.InstanceGroup	True
	[Deprecated] Populate Microsoft SQL Server 2012 Replication Computers Group	Microsoft.SQLServer.2012.PopulateSQLServersReplicationGroup	Microsoft.SQLServer.2012.ReplicationComputerGroup	False
	[Deprecated] Discover Replication Components	Microsoft.SQLServer.2012.ReplicationComponentDiscoveryRule	Microsoft.SQLServer.2012.DBEngine	False
	[Deprecated] SQL Server 2012 Replication Publications and Subscriptions Discovery Provider	Microsoft.SQLServer.2012.ReplicationPublicationsSubscriptionsDiscoveryRule	Microsoft.SQLServer.2012.DBEngine	False
	Discover SQL Server 2012 Reporting Services (Windows Server)	Microsoft.SQLServer.2012.ReportingServicesDiscoveryRule.Server	Microsoft.SQLServer.2012.Seed	False
	SQL Server 2012 DB Installation Discovery Source	Microsoft.SQLServer.2012.SeedDiscovery	Microsoft.Windows.Server.Computer	True

Rules (2)

	DisplayName	ID	Target	Category	Enabled	Alert Generate
	MSSQL 2012: Discovery failed	Microsoft.SQLServer.2012.DiscoveryFailed.Rule	Microsoft.SQLServer.Library.EventLogCollectionTarget	Alert	True	True
	MSSQL 2012: Discovery warning	Microsoft.SQLServer.2012.DiscoveryWarning.Rule	Microsoft.SQLServer.Library.EventLogCollectionTarget	Alert	True	True

Discovery Property Overrides (1)

	ID	Context	Target
	Microsoft.SQLServer.2012.DiscoveryPropertyOverride.DBEngine.DBFileDiscovery	Microsoft.SQLServer.2012.DBEnginesWithManyDBsGroup	Microsoft.SQLServer.2012.DBFilesDiscoveryRule

Image References (3)

	DisplayName	ID	ImageID
	SQL Server 2012 DB File	Microsoft.SQLServer.2012.DBFile	Microsoft.SQLServer.DBFile.Image80
	SQL Server 2012 DB Log File	Microsoft.SQLServer.2012.DBLogFile	Microsoft.SQLServer.DBLogFile.Image64
	SQL Server 2012 Custom User Policy	Microsoft.SQLServer.2012.Policy	Microsoft.SQLServer.Policy.Image80

Images (2)

	ID	File Name	Accessibility
	Microsoft.SQLServer.2012.Policy.Image16	Microsoft.SQLServer.2012.Policy.Image16.png	Public
	Microsoft.SQLServer.2012.Policy.Image80	Microsoft.SQLServer.2012.Policy.Image80.png	Public