Microsoft SQL Server 2008 (Discovery)

Microsoft.SQLServer.2008.Discovery :: 6.7.20.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 a separate monitoring management pack to be imported to monitor the discovered objects.

Summary

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

Management Pack Elements

Classes (22)

 DisplayNameIDBase ClassAbstractHostedSingletonGroupExtensionAccessibility
Microsoft.SQLServer.2008.AgentSQL Server 2008 AgentMicrosoft.SQLServer.2008.AgentMicrosoft.SQLServer.AgentFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2008.AgentJobSQL Server 2008 Agent JobMicrosoft.SQLServer.2008.AgentJobMicrosoft.SQLServer.AgentJobFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2008.AnalysisServicesSQL Server 2008 Analysis ServicesMicrosoft.SQLServer.2008.AnalysisServicesMicrosoft.SQLServer.AnalysisServicesFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2008.ComputerGroupSQL Server 2008 ComputersMicrosoft.SQLServer.2008.ComputerGroupMicrosoft.SystemCenter.ComputerGroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2008.DatabaseSQL Server 2008 DBMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.DatabaseFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2008.DBEngineSQL Server 2008 DB EngineMicrosoft.SQLServer.2008.DBEngineMicrosoft.SQLServer.DBEngineFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2008.DBFileSQL Server 2008 DB FileMicrosoft.SQLServer.2008.DBFileMicrosoft.SQLServer.DBFileFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2008.DBFileGroupSQL Server 2008 DB FilegroupMicrosoft.SQLServer.2008.DBFileGroupMicrosoft.SQLServer.DBFileGroupFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2008.DBLogFileSQL Server 2008 DB Log FileMicrosoft.SQLServer.2008.DBLogFileMicrosoft.SQLServer.DBFileFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2008.Distributor[Deprecated] SQL Server 2008 DistributorMicrosoft.SQLServer.2008.DistributorMicrosoft.SQLServer.DistributorFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2008.ExpressInstancesGroupSQL Server Express 2008 DB Engine GroupMicrosoft.SQLServer.2008.ExpressInstancesGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2008.InstanceGroupSQL Server 2008 DB Engine GroupMicrosoft.SQLServer.2008.InstanceGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2008.IntegrationServicesSQL Server 2008 Integration ServicesMicrosoft.SQLServer.2008.IntegrationServicesMicrosoft.SQLServer.IntegrationServicesFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2008.Publication[Deprecated] SQL Server 2008 PublicationMicrosoft.SQLServer.2008.PublicationMicrosoft.SQLServer.PublicationFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2008.Publisher[Deprecated] SQL Server 2008 PublisherMicrosoft.SQLServer.2008.PublisherMicrosoft.SQLServer.PublisherFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2008.ReplicationComputerGroup[Deprecated] SQL Server 2008 Replication ComputersMicrosoft.SQLServer.2008.ReplicationComputerGroupMicrosoft.SystemCenter.ComputerGroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2008.ReportingServicesSQL Server 2008 Reporting ServicesMicrosoft.SQLServer.2008.ReportingServicesMicrosoft.SQLServer.ReportingServicesFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2008.SeedSQL Server 2008 Installation SeedMicrosoft.SQLServer.2008.SeedMicrosoft.Windows.ApplicationComponentFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2008.Subscriber[Deprecated] SQL Server 2008 SubscriberMicrosoft.SQLServer.2008.SubscriberMicrosoft.SQLServer.SubscriberFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2008.Subscription[Deprecated] SQL Server 2008 SubscriptionMicrosoft.SQLServer.2008.SubscriptionMicrosoft.SQLServer.SubscriptionFalseTrueFalseFalseFalsePublic
Microsoft.SQLServer.2008.Wow64InstanceGroupSQL Server 2008 WOW64 DB Engine GroupMicrosoft.SQLServer.2008.Wow64InstanceGroupSystem.GroupFalseFalseTrueTrueFalsePublic
Microsoft.SQLServer.2008R2.InstanceGroupSQL Server 2008 R2 DB Engine GroupMicrosoft.SQLServer.2008R2.InstanceGroupSystem.GroupFalseFalseTrueTrueFalsePublic

Relationship Types (22)

 DisplayNameIDSourceTargetAccessibilityAbstract
Microsoft.SQLServer.2008.AgentHostsAgentJobSQL Server 2008 Agent Hosts Agent JobMicrosoft.SQLServer.2008.AgentHostsAgentJobMicrosoft.SQLServer.2008.AgentMicrosoft.SQLServer.2008.AgentJobPublicFalse
Microsoft.SQLServer.2008.AgentsGroupContainsAgentSQL Server 2008 Agents Group Contains AgentMicrosoft.SQLServer.2008.AgentsGroupContainsAgentMicrosoft.SQLServer.2008.AgentsGroupMicrosoft.SQLServer.2008.AgentPublicFalse
Microsoft.SQLServer.2008.DatabaseHostsPublicationSQL Server 2008 Database Hosts PublicationMicrosoft.SQLServer.2008.DatabaseHostsPublicationMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.PublicationPublicFalse
Microsoft.SQLServer.2008.DatabaseHostsSubscriptionSQL Server 2008 Database Hosts SubscriptionMicrosoft.SQLServer.2008.DatabaseHostsSubscriptionMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.SubscriptionPublicFalse
Microsoft.SQLServer.2008.DatabasesGroupContainsDatabaseSQL Server 2008 Databases Group Contains DatabaseMicrosoft.SQLServer.2008.DatabasesGroupContainsDatabaseMicrosoft.SQLServer.2008.DatabasesGroupMicrosoft.SQLServer.2008.DatabasePublicFalse
Microsoft.SQLServer.2008.DBEngineHostsDistributorSQL Server 2008 Database Engine Hosts DistributorMicrosoft.SQLServer.2008.DBEngineHostsDistributorMicrosoft.SQLServer.2008.DBEngineMicrosoft.SQLServer.2008.DistributorPublicFalse
Microsoft.SQLServer.2008.DBEngineHostsPublisherSQL Server 2008 Database Engine Hosts PublisherMicrosoft.SQLServer.2008.DBEngineHostsPublisherMicrosoft.SQLServer.2008.DBEngineMicrosoft.SQLServer.2008.PublisherPublicFalse
Microsoft.SQLServer.2008.DBEngineHostsSQLAgentSQL Server 2008 Database Engine Hosts SQL Server 2008 AgentMicrosoft.SQLServer.2008.DBEngineHostsSQLAgentMicrosoft.SQLServer.2008.DBEngineMicrosoft.SQLServer.2008.AgentPublicFalse
Microsoft.SQLServer.2008.DBEngineHostsSubscriberSQL Server 2008 Database Engine Hosts SubscriberMicrosoft.SQLServer.2008.DBEngineHostsSubscriberMicrosoft.SQLServer.2008.DBEngineMicrosoft.SQLServer.2008.SubscriberPublicFalse
Microsoft.SQLServer.2008.DBFileGroupHostsDBFileSQL Server 2008 Filegroup Hosts FileMicrosoft.SQLServer.2008.DBFileGroupHostsDBFileMicrosoft.SQLServer.2008.DBFileGroupMicrosoft.SQLServer.2008.DBFilePublicFalse
Microsoft.SQLServer.2008.DBFileToLogicalDiskSQL Server 2008 Database File Runs on Logical DiskMicrosoft.SQLServer.2008.DBFileToLogicalDiskMicrosoft.SQLServer.2008.DBFileMicrosoft.Windows.LogicalDiskPublicFalse
Microsoft.SQLServer.2008.DBHostsFileGroupSQL Server 2008 Database Hosts FilegroupMicrosoft.SQLServer.2008.DBHostsFileGroupMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.DBFileGroupPublicFalse
Microsoft.SQLServer.2008.DBHostsLogFileSQL Server 2008 Database Hosts Log FileMicrosoft.SQLServer.2008.DBHostsLogFileMicrosoft.SQLServer.2008.DatabaseMicrosoft.SQLServer.2008.DBLogFilePublicFalse
Microsoft.SQLServer.2008.DistributorContainsDatabaseSQL Server 2008 Distributer Contains SQL Server 2008 DatabaseMicrosoft.SQLServer.2008.DistributorContainsDatabaseMicrosoft.SQLServer.2008.DistributorMicrosoft.SQLServer.2008.DatabasePublicFalse
Microsoft.SQLServer.2008.ExpressInstancesGroupContainsDBEngineSQL Server Express 2008 Instances Group Contains DB Engine.Microsoft.SQLServer.2008.ExpressInstancesGroupContainsDBEngineMicrosoft.SQLServer.2008.ExpressInstancesGroupMicrosoft.SQLServer.2008.DBEnginePublicFalse
Microsoft.SQLServer.2008.InstanceGroupContainsDBEngineSQL Server 2008 Instance Group Contains InstancesMicrosoft.SQLServer.2008.InstanceGroupContainsDBEngineMicrosoft.SQLServer.2008.InstanceGroupMicrosoft.SQLServer.2008.DBEnginePublicFalse
Microsoft.SQLServer.2008.InstancesGroupContainsDBEngineSQL Server 2008 Instances Group Contains DB EngineMicrosoft.SQLServer.2008.InstancesGroupContainsDBEngineMicrosoft.SQLServer.2008.InstancesGroupMicrosoft.SQLServer.2008.DBEnginePublicFalse
Microsoft.SQLServer.2008.IntegrationServicesGroupContainsIntegrationServicesSQL Server 2008 Integration Services Group Contains Integration ServicesMicrosoft.SQLServer.2008.IntegrationServicesGroupContainsIntegrationServicesMicrosoft.SQLServer.2008.IntegrationServicesGroupMicrosoft.SQLServer.2008.IntegrationServicesPublicFalse
Microsoft.SQLServer.2008.Relationships.AlertsScopeGroupContainsSeedAlerts Scope Group Contains 2008 Seed RelationshipMicrosoft.SQLServer.2008.Relationships.AlertsScopeGroupContainsSeedMicrosoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroupMicrosoft.SQLServer.2008.SeedInternalFalse
Microsoft.SQLServer.2008.ServerComputerHostsSeedServer Computer Hosts SQL Server 2008 Installation SeedMicrosoft.SQLServer.2008.ServerComputerHostsSeedMicrosoft.Windows.Server.ComputerMicrosoft.SQLServer.2008.SeedPublicFalse
Microsoft.SQLServer.2008.Wow64InstanceGroupContainsDBEngineSQL Server 2008 WOW64 Instance Group Contains InstancesMicrosoft.SQLServer.2008.Wow64InstanceGroupContainsDBEngineMicrosoft.SQLServer.2008.Wow64InstanceGroupMicrosoft.SQLServer.2008.DBEnginePublicFalse
Microsoft.SQLServer.2008R2.InstanceGroupContainsDBEngineSQL Server 2008 R2 Instance Group Contains InstancesMicrosoft.SQLServer.2008R2.InstanceGroupContainsDBEngineMicrosoft.SQLServer.2008R2.InstanceGroupMicrosoft.SQLServer.2008.DBEnginePublicFalse

DataSource Modules (12)

 DisplayNameIDIsolationAccessibility
Microsoft.SQLServer.2008.AgentJobDiscoverySQL Server Agent Job DiscoveryMicrosoft.SQLServer.2008.AgentJobDiscoveryAnyInternal
Microsoft.SQLServer.2008.AnalysisServicesDiscoverySQL Server 2008 DB Analysis Services Discovery SourceMicrosoft.SQLServer.2008.AnalysisServicesDiscoveryAnyInternal
Microsoft.SQLServer.2008.DataSource.EventLogCollectionTargetData Source Event Log Collection TargetMicrosoft.SQLServer.2008.DataSource.EventLogCollectionTargetAnyInternal
Microsoft.SQLServer.2008.DBDiscoverySQL Server 2008 Database DiscoveryMicrosoft.SQLServer.2008.DBDiscoveryAnyInternal
Microsoft.SQLServer.2008.DBEngineDiscoverySQL Server 2008 DB Engine Discovery SourceMicrosoft.SQLServer.2008.DBEngineDiscoveryAnyInternal
Microsoft.SQLServer.2008.DBFileGroupDiscoverySQL Server 2008 Database Filegroup DiscoveryMicrosoft.SQLServer.2008.DBFileGroupDiscoveryAnyInternal
Microsoft.SQLServer.2008.DBFilesDiscoverySQL Server 2008 Database File DiscoveryMicrosoft.SQLServer.2008.DBFilesDiscoveryAnyInternal
Microsoft.SQLServer.2008.IntegrationServicesDiscoveryDataSourceSQL Server 2008 Integration Services Discovery Data SourceMicrosoft.SQLServer.2008.IntegrationServicesDiscoveryDataSourceAnyInternal
Microsoft.SQLServer.2008.OleDBDiscoveryProviderSQL Server 2008 OLE DB Discovery ProviderMicrosoft.SQLServer.2008.OleDBDiscoveryProviderAnyInternal
Microsoft.SQLServer.2008.ReplicationComponentDiscovery[Deprecated] SQL Server 2008 Replication Component Discovery ProviderMicrosoft.SQLServer.2008.ReplicationComponentDiscoveryAnyInternal
Microsoft.SQLServer.2008.ReplicationPublicationsSubscriptionsDiscovery[Deprecated] SQL Server 2008 Replication Publications and Subscriptions Discovery ProviderMicrosoft.SQLServer.2008.ReplicationPublicationsSubscriptionsDiscoveryAnyInternal
Microsoft.SQLServer.2008.ReportingServicesDiscoverySQL Server 2008 DB Reporting Services Discovery SourceMicrosoft.SQLServer.2008.ReportingServicesDiscoveryAnyInternal

ProbeAction Modules (2)

 DisplayNameIDIsolationAccessibility
Microsoft.SQLServer.2008.DBFileGroupScriptProbeDiscoveryDB Filegroup Script Probe DiscoveryMicrosoft.SQLServer.2008.DBFileGroupScriptProbeDiscoveryAnyInternal
Microsoft.SQLServer.2008.DBFilesScriptProbeDiscoveryDB Files Script Probe DiscoveryMicrosoft.SQLServer.2008.DBFilesScriptProbeDiscoveryAnyInternal

Discoveries (24)

 DisplayNameIDTargetEnabled
Microsoft.SQLServer.2008.AgentDiscoveryDiscover SQL Server Agent for a DB EngineMicrosoft.SQLServer.2008.AgentDiscoveryMicrosoft.SQLServer.2008.DBEngineTrue
Microsoft.SQLServer.2008.AgentJobDiscoveryRuleDiscover SQL Server 2008 Agent JobsMicrosoft.SQLServer.2008.AgentJobDiscoveryRuleMicrosoft.SQLServer.2008.AgentFalse
Microsoft.SQLServer.2008.AgentsGroup.DiscoveryMSSQL 2008: Populate SQL Server 2008 Agents GroupMicrosoft.SQLServer.2008.AgentsGroup.DiscoveryMicrosoft.SQLServer.2008.AgentsGroupTrue
Microsoft.SQLServer.2008.AlertsScopeGroupSeedDiscoveryMSSQL 2008: Alerts Scope Group Seed DiscoveryMicrosoft.SQLServer.2008.AlertsScopeGroupSeedDiscoveryMicrosoft.SQLServer.Generic.Presentation.SQLServerAlertsScopeGroupTrue
Microsoft.SQLServer.2008.AnalysisServicesDiscoveryRule.ServerDiscover SQL Server 2008 Analysis Services (Windows Server)Microsoft.SQLServer.2008.AnalysisServicesDiscoveryRule.ServerMicrosoft.SQLServer.2008.SeedFalse
Microsoft.SQLServer.2008.DatabaseDiscoveryRuleDiscover Databases for a Database EngineMicrosoft.SQLServer.2008.DatabaseDiscoveryRuleMicrosoft.SQLServer.2008.DBEngineTrue
Microsoft.SQLServer.2008.DatabasesGroup.DiscoveryMSSQL 2008: Populate SQL Server 2008 Databases GroupMicrosoft.SQLServer.2008.DatabasesGroup.DiscoveryMicrosoft.SQLServer.2008.DatabasesGroupTrue
Microsoft.SQLServer.2008.DBEngineDiscoveryRule.ServerDiscover SQL Server 2008 Database Engines (Windows Server)Microsoft.SQLServer.2008.DBEngineDiscoveryRule.ServerMicrosoft.SQLServer.2008.SeedTrue
Microsoft.SQLServer.2008.DBFileGroupDiscoveryRuleDiscover FilegroupsMicrosoft.SQLServer.2008.DBFileGroupDiscoveryRuleMicrosoft.SQLServer.2008.DBEngineTrue
Microsoft.SQLServer.2008.DBFilesDiscoveryRuleDiscover FilesMicrosoft.SQLServer.2008.DBFilesDiscoveryRuleMicrosoft.SQLServer.2008.DBEngineTrue
Microsoft.SQLServer.2008.Discovery.EventLogCollectionTargetSQL Server 2008 Event Log Collection Target DiscoveryMicrosoft.SQLServer.2008.Discovery.EventLogCollectionTargetMicrosoft.SQLServer.2008.SeedTrue
Microsoft.SQLServer.2008.EnterpriseLicenseDiscoveryRuleLicense Discovery for Microsoft SQL ServerMicrosoft.SQLServer.2008.EnterpriseLicenseDiscoveryRuleMicrosoft.SQLServer.2008.DBEngineTrue
Microsoft.SQLServer.2008.ExpressInstancesGroup.DiscoveryMSSQL 2008: Populate SQL Server Express 2008 Instance GroupMicrosoft.SQLServer.2008.ExpressInstancesGroup.DiscoveryMicrosoft.SQLServer.2008.ExpressInstancesGroupTrue
Microsoft.SQLServer.2008.InstancesGroup.DiscoveryMSSQL 2008: Populate SQL Server 2008 Instance GroupMicrosoft.SQLServer.2008.InstancesGroup.DiscoveryMicrosoft.SQLServer.2008.InstancesGroupTrue
Microsoft.SQLServer.2008.IntegrationServicesDiscoveryRule.ServerDiscover SQL Server 2008 Integration Services (Windows Server)Microsoft.SQLServer.2008.IntegrationServicesDiscoveryRule.ServerMicrosoft.SQLServer.2008.SeedTrue
Microsoft.SQLServer.2008.IntegrationServicesGroup.DiscoveryMSSQL 2008: Populate SQL Server 2008 Integration Services GroupMicrosoft.SQLServer.2008.IntegrationServicesGroup.DiscoveryMicrosoft.SQLServer.2008.IntegrationServicesGroupTrue
Microsoft.SQLServer.2008.PopulateSQLServersComputerGroupPopulate Microsoft SQL Server 2008 Computer GroupMicrosoft.SQLServer.2008.PopulateSQLServersComputerGroupMicrosoft.SQLServer.2008.ComputerGroupTrue
Microsoft.SQLServer.2008.PopulateSQLServersInstanceGroupPopulate Microsoft SQL Server 2008 Instance GroupMicrosoft.SQLServer.2008.PopulateSQLServersInstanceGroupMicrosoft.SQLServer.2008.InstanceGroupTrue
Microsoft.SQLServer.2008.PopulateSQLServersReplicationGroup[Deprecated] Populate Microsoft SQL Server 2008 Replication Computers GroupMicrosoft.SQLServer.2008.PopulateSQLServersReplicationGroupMicrosoft.SQLServer.2008.ReplicationComputerGroupFalse
Microsoft.SQLServer.2008.ReplicationComponentDiscoveryRule[Deprecated] Discover Replication ComponentsMicrosoft.SQLServer.2008.ReplicationComponentDiscoveryRuleMicrosoft.SQLServer.2008.DBEngineFalse
Microsoft.SQLServer.2008.ReplicationPublicationsSubscriptionsDiscoveryRule[Deprecated] SQL Server 2008 Replication Publications and Subscriptions Discovery ProviderMicrosoft.SQLServer.2008.ReplicationPublicationsSubscriptionsDiscoveryRuleMicrosoft.SQLServer.2008.DBEngineFalse
Microsoft.SQLServer.2008.ReportingServicesDiscoveryRule.ServerDiscover SQL Server 2008 Reporting Services (Windows Server)Microsoft.SQLServer.2008.ReportingServicesDiscoveryRule.ServerMicrosoft.SQLServer.2008.SeedFalse
Microsoft.SQLServer.2008.SeedDiscoverySQL Server 2008 DB Installation Discovery SourceMicrosoft.SQLServer.2008.SeedDiscoveryMicrosoft.Windows.Server.ComputerTrue
Microsoft.SQLServer.2008R2.PopulateSQLServersInstanceGroupPopulate Microsoft SQL Server 2008 R2 Instance GroupMicrosoft.SQLServer.2008R2.PopulateSQLServersInstanceGroupMicrosoft.SQLServer.2008R2.InstanceGroupTrue

Rules (2)

 DisplayNameIDTargetCategoryEnabledAlert Generate
Microsoft.SQLServer.2008.DiscoveryFailed.RuleMSSQL 2008: Discovery failedMicrosoft.SQLServer.2008.DiscoveryFailed.RuleMicrosoft.SQLServer.Library.EventLogCollectionTargetAlertTrueTrue
Microsoft.SQLServer.2008.DiscoveryWarning.RuleMSSQL 2008: Discovery warningMicrosoft.SQLServer.2008.DiscoveryWarning.RuleMicrosoft.SQLServer.Library.EventLogCollectionTargetAlertTrueTrue

Image References (2)

 DisplayNameIDImageID
Microsoft.SQLServer.2008.DBFileSQL Server 2008 DB FileMicrosoft.SQLServer.2008.DBFileMicrosoft.SQLServer.DBFile.Image80
Microsoft.SQLServer.2008.DBLogFileSQL Server 2008 DB Log FileMicrosoft.SQLServer.2008.DBLogFileMicrosoft.SQLServer.DBLogFile.Image64