Microsoft.SystemCenter.OperationsManager.Reports.2007.Script.ReportObjectDisplayNamesListDataGet (DataWarehouseScript)

Element properties:

Source Code:

<DataWarehouseScript ID="Microsoft.SystemCenter.OperationsManager.Reports.2007.Script.ReportObjectDisplayNamesListDataGet" Accessibility="Internal">

  <Install> 

                 

IF NOT EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectDisplayNamesList')

	BEGIN

		EXECUTE ('CREATE PROCEDURE dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectDisplayNamesList] AS RETURN 1')

	END

GO



ALTER PROCEDURE dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectDisplayNamesList] 

	@ObjectList xml

AS

BEGIN

  SET NOCOUNT ON



  SELECT vManagedEntity.ManagedEntityDefaultName 

  FROM   @ObjectList.nodes('/Data/Objects/Object') AS ObjectList(ManagedEntity) 

  INNER JOIN vManagedEntity 

  ON vManagedEntity.ManagedEntityRowId = ObjectList.ManagedEntity.value('.', 'int') 





END

GO



GRANT EXECUTE ON dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectDisplayNamesList] TO OpsMgrReader

GO



                </Install>

  <Uninstall>

                  IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectDisplayNamesList')

	BEGIN

        DROP PROCEDURE dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectDisplayNamesList]

	END

GO



                </Uninstall>

  <Upgrade> 

                 

IF NOT EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectDisplayNamesList')

	BEGIN

		EXECUTE ('CREATE PROCEDURE dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectDisplayNamesList] AS RETURN 1')

	END

GO



ALTER PROCEDURE dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectDisplayNamesList] 

	@ObjectList xml

AS

BEGIN

  SET NOCOUNT ON



  SELECT vManagedEntity.ManagedEntityDefaultName 

  FROM   @ObjectList.nodes('/Data/Objects/Object') AS ObjectList(ManagedEntity) 

  INNER JOIN vManagedEntity 

  ON vManagedEntity.ManagedEntityRowId = ObjectList.ManagedEntity.value('.', 'int') 





END

GO



GRANT EXECUTE ON dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectDisplayNamesList] TO OpsMgrReader

GO



                </Upgrade>

</DataWarehouseScript>