SQL Server 2008 (Discovery)

Microsoft.SQLServer.2008.Discovery :: 6.0.6648.0 (Management Pack)

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

Summary

The SQL 2008 (Discovery) Management Pack provides the SQL 2008 specific object definitions and discovery rules. It requires the SQL 2008 Core Library Management Pack and is used by the SQL 2008 (Monitoring) Management Pack. It does not provide monitoring functionality, which is only contained in the SQL 2008 (Monitoring) Management Pack.

Management Pack Elements

Show Management Pack References

TypeDefinitions

EntityTypes

ClassType (17)
RelationshipType (12)

ModuleTypes

DataSourceModuleType (9)

Monitoring

Discovery (14)

Classes (17)

System.Entity

System.LogicalEntity

System.ApplicationComponent

Microsoft.Windows.ApplicationComponent

Microsoft.SQLServer.Component

Microsoft.SQLServer.Agent

Microsoft.SQLServer.2008.Agent

Microsoft.SQLServer.AgentJob

Microsoft.SQLServer.2008.AgentJob

Microsoft.SQLServer.DBFile

Microsoft.SQLServer.2008.DBFile

Microsoft.SQLServer.DBFileGroup

Microsoft.SQLServer.2008.DBFileGroup

Microsoft.SQLServer.Distributor

Microsoft.SQLServer.2008.Distributor

Microsoft.SQLServer.Publication

Microsoft.SQLServer.2008.Publication

Microsoft.SQLServer.Publisher

Microsoft.SQLServer.2008.Publisher

Microsoft.SQLServer.Subscriber

Microsoft.SQLServer.2008.Subscriber

Microsoft.SQLServer.Subscription

Microsoft.SQLServer.2008.Subscription

System.Database

Microsoft.SQLServer.Database

Microsoft.SQLServer.2008.Database

System.ComputerRole

Microsoft.Windows.ComputerRole

Microsoft.SQLServer.ServerRole

Microsoft.SQLServer.AnalysisServices

Microsoft.SQLServer.2008.AnalysisServices

Microsoft.SQLServer.DBEngine

Microsoft.SQLServer.2008.DBEngine

Microsoft.SQLServer.IntegrationServices

Microsoft.SQLServer.2008.IntegrationServices

Microsoft.SQLServer.ReportingServices

Microsoft.SQLServer.2008.ReportingServices

System.Group

Microsoft.SystemCenter.ComputerGroup

Microsoft.SQLServer.2008.InstanceGroup

DisplayName	ID	Base Class	Abstract	Hosted	Singleton	Group	Extension	Accessibility
SQL 2008 Agent	Microsoft.SQLServer.2008.Agent	Microsoft.SQLServer.Agent	False	True	False	False	False	Public
SQL 2008 Agent Job	Microsoft.SQLServer.2008.AgentJob	Microsoft.SQLServer.AgentJob	False	True	False	False	False	Public
SQL 2008 Analysis Services	Microsoft.SQLServer.2008.AnalysisServices	Microsoft.SQLServer.AnalysisServices	False	True	False	False	False	Public
SQL 2008 Computers	Microsoft.SQLServer.2008.ComputerGroup	Microsoft.SystemCenter.ComputerGroup	False	False	True	True	False	Public
SQL 2008 DB	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.Database	False	True	False	False	False	Public
SQL 2008 DB Engine	Microsoft.SQLServer.2008.DBEngine	Microsoft.SQLServer.DBEngine	False	True	False	False	False	Public
SQL 2008 DB File	Microsoft.SQLServer.2008.DBFile	Microsoft.SQLServer.DBFile	False	True	False	False	False	Public
SQL 2008 DB File Group	Microsoft.SQLServer.2008.DBFileGroup	Microsoft.SQLServer.DBFileGroup	False	True	False	False	False	Public
SQL 2008 Distributor	Microsoft.SQLServer.2008.Distributor	Microsoft.SQLServer.Distributor	False	True	False	False	False	Public
SQL 2008 DB Engine Group	Microsoft.SQLServer.2008.InstanceGroup	System.Group	False	False	True	True	False	Public
SQL 2008 Integration Services	Microsoft.SQLServer.2008.IntegrationServices	Microsoft.SQLServer.IntegrationServices	False	True	False	False	False	Public
SQL 2008 Publication	Microsoft.SQLServer.2008.Publication	Microsoft.SQLServer.Publication	False	True	False	False	False	Public
SQL 2008 Publisher	Microsoft.SQLServer.2008.Publisher	Microsoft.SQLServer.Publisher	False	True	False	False	False	Public
SQL 2008 Replication Computers	Microsoft.SQLServer.2008.ReplicationComputerGroup	Microsoft.SystemCenter.ComputerGroup	False	False	True	True	False	Public
SQL 2008 Reporting Services	Microsoft.SQLServer.2008.ReportingServices	Microsoft.SQLServer.ReportingServices	False	True	False	False	False	Public
SQL 2008 Subscriber	Microsoft.SQLServer.2008.Subscriber	Microsoft.SQLServer.Subscriber	False	True	False	False	False	Public
SQL 2008 Subscription	Microsoft.SQLServer.2008.Subscription	Microsoft.SQLServer.Subscription	False	True	False	False	False	Public

Relationship Types (12)

DisplayName	ID	Source	Target	Accessibility	Abstract
SQL 2008 Agent Hosts Agent Job	Microsoft.SQLServer.2008.AgentHostsAgentJob	Microsoft.SQLServer.2008.Agent	Microsoft.SQLServer.2008.AgentJob	Public	False
SQL 2008 Database Hosts Publication	Microsoft.SQLServer.2008.DatabaseHostsPublication	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.2008.Publication	Public	False
SQL 2008 Database Hosts Subscription	Microsoft.SQLServer.2008.DatabaseHostsSubscription	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.2008.Subscription	Public	False
SQL 2008 Database Engine Hosts Distributor	Microsoft.SQLServer.2008.DBEngineHostsDistributor	Microsoft.SQLServer.2008.DBEngine	Microsoft.SQLServer.2008.Distributor	Public	False
SQL 2008 Database Engine Hosts Publisher	Microsoft.SQLServer.2008.DBEngineHostsPublisher	Microsoft.SQLServer.2008.DBEngine	Microsoft.SQLServer.2008.Publisher	Public	False
SQL 2008 Database Engine Hosts SQL 2008 Agent	Microsoft.SQLServer.2008.DBEngineHostsSQLAgent	Microsoft.SQLServer.2008.DBEngine	Microsoft.SQLServer.2008.Agent	Public	False
SQL 2008 Database Engine Hosts Subscriber	Microsoft.SQLServer.2008.DBEngineHostsSubscriber	Microsoft.SQLServer.2008.DBEngine	Microsoft.SQLServer.2008.Subscriber	Public	False
SQL Server 2008 File Group Hosts File	Microsoft.SQLServer.2008.DBFileGroupHostsDBFile	Microsoft.SQLServer.2008.DBFileGroup	Microsoft.SQLServer.2008.DBFile	Public	False
SQL 2008 Database File Runs on Logical Disk	Microsoft.SQLServer.2008.DBFileToLogicalDisk	Microsoft.SQLServer.2008.DBFile	Microsoft.Windows.LogicalDisk	Public	False
SQL Server 2008 Database Hosts File Group	Microsoft.SQLServer.2008.DBHostsFileGroup	Microsoft.SQLServer.2008.Database	Microsoft.SQLServer.2008.DBFileGroup	Public	False
SQL 2008 Distributer Contains SQL 2008 Database	Microsoft.SQLServer.2008.DistributorContainsDatabase	Microsoft.SQLServer.2008.Distributor	Microsoft.SQLServer.2008.Database	Public	False
SQL Server 2008 Instance Group Contains Instances	Microsoft.SQLServer.2008.InstanceGroupContainsDBEngine	Microsoft.SQLServer.2008.InstanceGroup	Microsoft.SQLServer.2008.DBEngine	Public	False

DataSource Modules (9)

DisplayName	ID	Isolation	Accessibility
SQL Agent Job Discovery	Microsoft.SQLServer.2008.AgentJobDiscovery	Any	Internal
SQL 2008 DB Analysis Services Discovery Source	Microsoft.SQLServer.2008.AnalysisServicesDiscovery	Any	Internal
SQL 2008 Database Discovery	Microsoft.SQLServer.2008.DBDiscovery	Any	Internal
SQL 2008 DB Engine Discovery Source	Microsoft.SQLServer.2008.DBEngineDiscovery	Any	Internal
SQL 2008 Database File Group and File Discovery	Microsoft.SQLServer.2008.DBFileGroupAndFileDiscovery	Any	Internal
SQL 2008 OLE DB Discovery Provider	Microsoft.SQLServer.2008.OleDBDiscoveryProvider	Any	Internal
SQL 2008 Replication Component Discovery Provider	Microsoft.SQLServer.2008.ReplicationComponentDiscovery	Any	Internal
SQL 2008 Replication Publications and Subscriptions Discovery Provider	Microsoft.SQLServer.2008.ReplicationPublicationsSubscriptionsDiscovery	Any	Internal
SQL 2008 DB Reporting Services Discovery Source	Microsoft.SQLServer.2008.ReportingServicesDiscovery	Any	Internal

Discoveries (14)

DisplayName	ID	Target	Enabled
Discover SQL Agent for a DB Engine	Microsoft.SQLServer.2008.AgentDiscovery	Microsoft.SQLServer.2008.DBEngine	True
Discover SQL 2008 Agent Jobs	Microsoft.SQLServer.2008.AgentJobDiscoveryRule	Microsoft.SQLServer.2008.Agent	False
Discover SQL 2008 Analysis Services (Windows Server)	Microsoft.SQLServer.2008.AnalysisServicesDiscoveryRule.Server	Microsoft.Windows.Server.Computer	True
Discover Databases for a Database Engine	Microsoft.SQLServer.2008.DatabaseDiscoveryRule	Microsoft.SQLServer.2008.DBEngine	True
Discover SQL 2008 Database Engines (Windows Server)	Microsoft.SQLServer.2008.DBEngineDiscoveryRule.Server	Microsoft.Windows.Server.Computer	True
Discover File Groups and Files	Microsoft.SQLServer.2008.DBFileGroupAndFileDiscoveryRule	Microsoft.SQLServer.2008.DBEngine	False
License Discovery for Microsoft SQL Server	Microsoft.SQLServer.2008.EnterpriseLicenseDiscoveryRule	Microsoft.SQLServer.2008.DBEngine	True
Discover SQL 2008 Integration Services (Windows Server)	Microsoft.SQLServer.2008.IntegrationServicesDiscoveryRule.Server	Microsoft.Windows.Server.Computer	True
Populate Microsoft SQL Server 2008 Computer Group	Microsoft.SQLServer.2008.PopulateSQLServersComputerGroup	Microsoft.SQLServer.2008.ComputerGroup	True
Populate Microsoft SQL Server 2008 Instance Group	Microsoft.SQLServer.2008.PopulateSQLServersInstanceGroup	Microsoft.SQLServer.2008.InstanceGroup	True
Populate Microsoft SQL Server 2008 Replication Computers Group	Microsoft.SQLServer.2008.PopulateSQLServersReplicationGroup	Microsoft.SQLServer.2008.ReplicationComputerGroup	True
Discover Replication Components	Microsoft.SQLServer.2008.ReplicationComponentDiscoveryRule	Microsoft.SQLServer.2008.DBEngine	False
SQL 2008 Replication Publications and Subscriptions Discovery Provider	Microsoft.SQLServer.2008.ReplicationPublicationsSubscriptionsDiscoveryRule	Microsoft.SQLServer.2008.DBEngine	False
Discover SQL 2008 Reporting Services (Windows Server)	Microsoft.SQLServer.2008.ReportingServicesDiscoveryRule.Server	Microsoft.Windows.Server.Computer	True