<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 <> 0 GOTO QuitError
SET @Error = @@ERROR
IF @Error <> 0 OR @ExecError <> 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 >= @StartDate) AND (vManagedEntityProperty.FromDateTime < @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 <> 0 GOTO QuitError
SET @Error = @@ERROR
IF @Error <> 0 OR @ExecError <> 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 >= @StartDate) AND (vManagedEntityProperty.FromDateTime < @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