HPC 2008 Database Discovery

Microsoft.HPC.2008.Discovery.DataBase (Discovery)

Element properties:

Target	Microsoft.SQLServer.DBEngine
Enabled	True
Frequency	86400
Remotable	False

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.HPC.2008.HeadNode.Database Version Edition AuthenticationMode ServiceName FullTextSearchServiceName AgentName ConnectionString MasterDatabaseLocation MasterDatabaseLogLocation ErrorLogLocation Language ServicePackVersion AuditLevel InstallPath ToolsPath EnableErrorReporting ReplicationWorkingDirectory ReplicationDistributionDatabase PerformanceCounterObject Cluster Account InstanceName

Discovered Classes and their attribuets:

Microsoft.HPC.2008.HeadNode.Database

Version
Edition
AuthenticationMode
ServiceName
FullTextSearchServiceName
AgentName
ConnectionString
MasterDatabaseLocation
MasterDatabaseLogLocation
ErrorLogLocation
Language
ServicePackVersion
AuditLevel
InstallPath
ToolsPath
EnableErrorReporting
ReplicationWorkingDirectory
ReplicationDistributionDatabase
PerformanceCounterObject
Cluster
Account
InstanceName

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.Windows.TimedScript.DiscoveryProvider	Default

Source Code:

<Discovery ID="Microsoft.HPC.2008.Discovery.DataBase" Enabled="true" Target="SQL!Microsoft.SQLServer.DBEngine" ConfirmDelivery="true" Remotable="true" Priority="Normal">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.HPC.2008.HeadNode.Database">

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="Version"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="Edition"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="AuthenticationMode"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="ServiceName"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="FullTextSearchServiceName"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="AgentName"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="ConnectionString"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="MasterDatabaseLocation"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="MasterDatabaseLogLocation"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="ErrorLogLocation"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="Language"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="ServicePackVersion"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="AuditLevel"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="InstallPath"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="ToolsPath"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="EnableErrorReporting"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="ReplicationWorkingDirectory"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="ReplicationDistributionDatabase"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="PerformanceCounterObject"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="Cluster"/>

      <Property TypeID="SQL!Microsoft.SQLServer.DBEngine" PropertyID="Account"/>

      <Property TypeID="SQL!Microsoft.SQLServer.ServerRole" PropertyID="InstanceName"/>

    </DiscoveryClass>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Windows!Microsoft.Windows.TimedScript.DiscoveryProvider">

    <IntervalSeconds>86400</IntervalSeconds>

    <SyncTime/>

    <ScriptName>GetDBEngine.vbs</ScriptName>

    <Arguments>$MPElement$ $Target/Id$</Arguments>

    <ScriptBody><Script>Option Explicit

SetLocale("en-us")



Main



Sub Main

	Dim args : Set args = WScript.Arguments

	If args.Count &lt; 2 Then

		WScript.Quit -1

	End If



	Dim sourceId, managedEntityId

	sourceId = args(0)

	managedEntityId = args(1)



	Dim momApi : Set momApi = CreateObject("MOM.ScriptAPI")

	Dim data : Set data = momApi.CreateDiscoveryData(0, sourceId, managedEntityId)

	If "$Target/Property[Type='SQL!Microsoft.SQLServer.ServerRole']/InstanceName$" = "COMPUTECLUSTER" Then

		Dim instance : Set instance = data.CreateClassInstance("$MPElement[Name='Microsoft.HPC.2008.HeadNode.Database']$")

		Call instance.AddProperty("$MPElement[Name='Windows!Microsoft.Windows.Computer']/PrincipalName$", "$Target/Host/Property[Type='Windows!Microsoft.Windows.Computer']/PrincipalName$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.ServerRole']/InstanceName$", "$Target/Property[Type='SQL!Microsoft.SQLServer.ServerRole']/InstanceName$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/Version$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/Version$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/Edition$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/Edition$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/AuthenticationMode$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/AuthenticationMode$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/ServiceName$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/ServiceName$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/FullTextSearchServiceName$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/FullTextSearchServiceName$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/AgentName$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/AgentName$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/ConnectionString$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/ConnectionString$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/MasterDatabaseLocation$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/MasterDatabaseLocation$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/MasterDatabaseLogLocation$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/MasterDatabaseLogLocation$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/ErrorLogLocation$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/ErrorLogLocation$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/Language$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/Language$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/ServicePackVersion$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/ServicePackVersion$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/AuditLevel$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/AuditLevel$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/InstallPath$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/InstallPath$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/ToolsPath$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/ToolsPath$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/EnableErrorReporting$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/EnableErrorReporting$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/ReplicationWorkingDirectory$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/ReplicationWorkingDirectory$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/ReplicationDistributionDatabase$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/ReplicationDistributionDatabase$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/PerformanceCounterObject$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/PerformanceCounterObject$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/Cluster$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/Cluster$")

		Call instance.AddProperty("$MPElement[Name='SQL!Microsoft.SQLServer.DBEngine']/Account$", "$Target/Property[Type='SQL!Microsoft.SQLServer.DBEngine']/Account$")

		Call data.AddInstance(instance)

	End If



	Call momApi.Return(data)

End Sub</Script></ScriptBody>

    <TimeoutSeconds>300</TimeoutSeconds>

  </DataSource>

</Discovery>