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

Element properties:

Source Code:

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

  <Install> 

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

	BEGIN

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

	END

GO



ALTER PROCEDURE dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ConfigurationChangeReportDataGet]

	@StartDate datetime,

	@EndDate datetime,

	@ObjectList xml,

    @LanguageCode varchar(3) = 'ENU'

AS

BEGIN

  SET NOCOUNT ON



  DECLARE @Error int

  DECLARE @ExecError int



  CREATE TABLE #ObjectList (ManagedEntityRowId int)



  SET @Error = @@ERROR

  IF @Error &lt;&gt; 0 GOTO QuitError



  INSERT INTO #ObjectList (ManagedEntityRowId)

  EXECUTE @ExecError = [Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectListParse]

    @ObjectList = @ObjectList,

    @StartDate = @StartDate,

    @EndDate = @EndDate



  SET @Error = @@ERROR

  IF @Error &lt;&gt; 0 OR @ExecError &lt;&gt; 0 GOTO QuitError



/* ------------------------------ */



  SELECT vManagedEntityProperty.FromDateTime, ISNULL(vDisplayStringProperty.Name,vManagedEntityTypeProperty.PropertyDefaultName) AS PropertyDefaultName, 

         vManagedEntityPropertyChange.OldValue, vManagedEntityPropertyChange.NewValue, vManagedEntity.ManagedEntityDefaultName, 

         vManagedEntityType.ManagedEntityTypeGuid, ISNULL(vDisplayString.Name,vManagedEntityType.ManagedEntityTypeDefaultName)AS DisplayName, vManagedEntityTypeImage.Image, 

         vManagedEntity.ManagedEntityRowId, vManagedEntity.Path, vManagementGroup.ManagementGroupGuid, 

         vManagementGroup.ManagementGroupDefaultName

  FROM   vManagedEntityProperty INNER JOIN

         #ObjectList As ObjectList ON vManagedEntityProperty.ManagedEntityRowId = ObjectList.ManagedEntityRowId INNER JOIN

         vManagedEntity ON vManagedEntity.ManagedEntityRowId = vManagedEntityProperty.ManagedEntityRowId INNER JOIN

         vManagedEntityType ON vManagedEntity.ManagedEntityTypeRowId = vManagedEntityType.ManagedEntityTypeRowId INNER JOIN

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

         vManagedEntityTypeImage ON vManagedEntityType.ManagedEntityTypeRowId = vManagedEntityTypeImage.ManagedEntityTypeRowId AND 

         vManagedEntityTypeImage.ImageCategory = N'u16x16Icon' LEFT OUTER JOIN

         vManagedEntityPropertyChange ON 

         vManagedEntityPropertyChange.ManagedEntityPropertyRowId = vManagedEntityProperty.ManagedEntityPropertyRowId LEFT OUTER JOIN

         vManagedEntityTypeProperty ON vManagedEntityTypeProperty.PropertyGuid = vManagedEntityPropertyChange.PropertyGuid LEFT OUTER JOIN

         vDisplayString vDisplayStringProperty ON vDisplayStringProperty.ElementGuid = vManagedEntityPropertyChange.PropertyGuid AND 

         vDisplayStringProperty.LanguageCode = @LanguageCode LEFT OUTER JOIN

         vDisplayString ON vManagedEntityType.ManagedEntityTypeGuid = vDisplayString.ElementGuid AND 

         vDisplayString.LanguageCode = @LanguageCode

  WHERE  (vManagedEntityProperty.FromDateTime &gt;= @StartDate) AND (vManagedEntityProperty.FromDateTime &lt; @EndDate)



  SET @Error = @@ERROR



QuitError:

  DROP TABLE #ObjectList



  RETURN @Error

END

GO



GRANT EXECUTE ON dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ConfigurationChangeReportDataGet] TO OpsMgrReader

GO



                </Install>

  <Uninstall>

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

	BEGIN

        DROP PROCEDURE dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ConfigurationChangeReportDataGet]

	END

GO



                </Uninstall>

  <Upgrade> 

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

	BEGIN

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

	END

GO



ALTER PROCEDURE dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ConfigurationChangeReportDataGet]

	@StartDate datetime,

	@EndDate datetime,

	@ObjectList xml,

    @LanguageCode varchar(3) = 'ENU'

AS

BEGIN

  SET NOCOUNT ON



  DECLARE @Error int

  DECLARE @ExecError int



  CREATE TABLE #ObjectList (ManagedEntityRowId int)



  SET @Error = @@ERROR

  IF @Error &lt;&gt; 0 GOTO QuitError



  INSERT INTO #ObjectList (ManagedEntityRowId)

  EXECUTE @ExecError = [Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectListParse]

    @ObjectList = @ObjectList,

    @StartDate = @StartDate,

    @EndDate = @EndDate



  SET @Error = @@ERROR

  IF @Error &lt;&gt; 0 OR @ExecError &lt;&gt; 0 GOTO QuitError



/* ------------------------------ */



  SELECT vManagedEntityProperty.FromDateTime, ISNULL(vDisplayStringProperty.Name,vManagedEntityTypeProperty.PropertyDefaultName) AS PropertyDefaultName, 

         vManagedEntityPropertyChange.OldValue, vManagedEntityPropertyChange.NewValue, vManagedEntity.ManagedEntityDefaultName, 

         vManagedEntityType.ManagedEntityTypeGuid, ISNULL(vDisplayString.Name,vManagedEntityType.ManagedEntityTypeDefaultName)AS DisplayName, vManagedEntityTypeImage.Image, 

         vManagedEntity.ManagedEntityRowId, vManagedEntity.Path, vManagementGroup.ManagementGroupGuid, 

         vManagementGroup.ManagementGroupDefaultName

  FROM   vManagedEntityProperty INNER JOIN

         #ObjectList As ObjectList ON vManagedEntityProperty.ManagedEntityRowId = ObjectList.ManagedEntityRowId INNER JOIN

         vManagedEntity ON vManagedEntity.ManagedEntityRowId = vManagedEntityProperty.ManagedEntityRowId INNER JOIN

         vManagedEntityType ON vManagedEntity.ManagedEntityTypeRowId = vManagedEntityType.ManagedEntityTypeRowId INNER JOIN

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

         vManagedEntityTypeImage ON vManagedEntityType.ManagedEntityTypeRowId = vManagedEntityTypeImage.ManagedEntityTypeRowId AND 

         vManagedEntityTypeImage.ImageCategory = N'u16x16Icon' LEFT OUTER JOIN

         vManagedEntityPropertyChange ON 

         vManagedEntityPropertyChange.ManagedEntityPropertyRowId = vManagedEntityProperty.ManagedEntityPropertyRowId LEFT OUTER JOIN

         vManagedEntityTypeProperty ON vManagedEntityTypeProperty.PropertyGuid = vManagedEntityPropertyChange.PropertyGuid LEFT OUTER JOIN

         vDisplayString vDisplayStringProperty ON vDisplayStringProperty.ElementGuid = vManagedEntityPropertyChange.PropertyGuid AND 

         vDisplayStringProperty.LanguageCode = @LanguageCode LEFT OUTER JOIN

         vDisplayString ON vManagedEntityType.ManagedEntityTypeGuid = vDisplayString.ElementGuid AND 

         vDisplayString.LanguageCode = @LanguageCode

  WHERE  (vManagedEntityProperty.FromDateTime &gt;= @StartDate) AND (vManagedEntityProperty.FromDateTime &lt; @EndDate)



  SET @Error = @@ERROR



QuitError:

  DROP TABLE #ObjectList



  RETURN @Error

END

GO



GRANT EXECUTE ON dbo.[Microsoft_SystemCenter_DataWarehouse_Report_Library_ConfigurationChangeReportDataGet] TO OpsMgrReader

GO



                </Upgrade>

</DataWarehouseScript>