Microsoft.SystemCenter.DataWarehouse.Report.Script.ObjectList (DataWarehouseScript)

Element properties:

Source Code:

<DataWarehouseScript ID="Microsoft.SystemCenter.DataWarehouse.Report.Script.ObjectList" Accessibility="Public">

  <Install> 

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

	BEGIN

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

	END

GO



ALTER PROCEDURE dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectList]

	@ObjectList xml,

	@LanguageCode varchar(3) = 'ENU'

AS

BEGIN

  SET NOCOUNT ON



  SELECT vManagedEntity.ManagedEntityDefaultName, vManagedEntity.Path, ISNULL(vDisplayString.Name,vManagedEntityType.ManagedEntityTypeDefaultName)AS DisplayName, 

         vManagedEntity.ManagedEntityRowId, vManagementGroup.ManagementGroupDefaultName,

         ObjectList.ManagedEntity.value('@Use', 'nvarchar(255)') As ManagedEntityUse

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

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

         vManagedEntityType ON vManagedEntity.ManagedEntityTypeRowId = vManagedEntityType.ManagedEntityTypeRowId INNER JOIN

         vManagementGroup ON vManagedEntity.ManagementGroupRowId = vManagementGroup.ManagementGroupRowId LEFT OUTER JOIN

	     vDisplayString ON vManagedEntityType.ManagedEntityTypeGuid = vDisplayString.ElementGuid AND 

	     vDisplayString.LanguageCode = @LanguageCode

END

GO



GRANT EXECUTE ON dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectList] TO OpsMgrReader

GO



                </Install>

  <Uninstall>

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

	BEGIN

        DROP PROCEDURE dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectList]

	END

GO



                </Uninstall>

  <Upgrade> 

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

	BEGIN

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

	END

GO



ALTER PROCEDURE dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectList]

	@ObjectList xml,

	@LanguageCode varchar(3) = 'ENU'

AS

BEGIN

  SET NOCOUNT ON



  SELECT vManagedEntity.ManagedEntityDefaultName, vManagedEntity.Path, ISNULL(vDisplayString.Name,vManagedEntityType.ManagedEntityTypeDefaultName)AS DisplayName, 

         vManagedEntity.ManagedEntityRowId, vManagementGroup.ManagementGroupDefaultName,

         ObjectList.ManagedEntity.value('@Use', 'nvarchar(255)') As ManagedEntityUse

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

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

         vManagedEntityType ON vManagedEntity.ManagedEntityTypeRowId = vManagedEntityType.ManagedEntityTypeRowId INNER JOIN

         vManagementGroup ON vManagedEntity.ManagementGroupRowId = vManagementGroup.ManagementGroupRowId LEFT OUTER JOIN

	     vDisplayString ON vManagedEntityType.ManagedEntityTypeGuid = vDisplayString.ElementGuid AND 

	     vDisplayString.LanguageCode = @LanguageCode

END

GO



GRANT EXECUTE ON dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectList] TO OpsMgrReader

GO



                </Upgrade>

</DataWarehouseScript>