<DataWarehouseScript ID="Microsoft.Windows.Server.AD.Library.Report.Script.EventListParse" Accessibility="Public"> <Install>
IF NOT EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Microsoft_ActiveDirectory_Report_Library_ReportEventListParse')
BEGIN
EXECUTE ('CREATE PROCEDURE dbo.[Microsoft_ActiveDirectory_Report_Library_ReportEventListParse] AS RETURN 1')
END
GO
ALTER PROCEDURE dbo.[Microsoft_ActiveDirectory_Report_Library_ReportEventListParse]
@EventList xml
AS
BEGIN
SET NOCOUNT ON
DECLARE @Error int
DECLARE @ExecError int
DECLARE @RowCount int
CREATE TABLE #EventList (EventId int)
SET @Error = @@ERROR
IF @Error <> 0 GOTO QuitError
INSERT INTO #EventList (EventId)
SELECT EventList.EventId.value('.', 'int')
FROM @EventList.nodes('/Data/Events/Event') AS EventList(EventId)
SELECT EventId
FROM #EventList
SET @Error = @@ERROR
QuitError:
DROP TABLE #EventList
RETURN @Error
END
GO
GRANT EXECUTE ON dbo.[Microsoft_ActiveDirectory_Report_Library_ReportEventListParse] TO OpsMgrReader
GO
</Install> <Uninstall>
IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Microsoft_ActiveDirectory_Report_Library_ReportEventListParse')
BEGIN
DROP PROCEDURE dbo.[Microsoft_ActiveDirectory_Report_Library_ReportEventListParse]
END
GO
</Uninstall> <Upgrade>
IF NOT EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Microsoft_ActiveDirectory_Report_Library_ReportEventListParse')
BEGIN
EXECUTE ('CREATE PROCEDURE dbo.[Microsoft_ActiveDirectory_Report_Library_ReportEventListParse] AS RETURN 1')
END
GO
ALTER PROCEDURE dbo.[Microsoft_ActiveDirectory_Report_Library_ReportEventListParse]
@EventList xml
AS
BEGIN
SET NOCOUNT ON
DECLARE @Error int
DECLARE @ExecError int
DECLARE @RowCount int
CREATE TABLE #EventList (EventId int)
SET @Error = @@ERROR
IF @Error <> 0 GOTO QuitError
INSERT INTO #EventList (EventId)
SELECT EventList.EventId.value('.', 'int')
FROM @EventList.nodes('/Data/Events/Event') AS EventList(EventId)
SELECT EventId
FROM #EventList
SET @Error = @@ERROR
QuitError:
DROP TABLE #EventList
RETURN @Error
END
GO
GRANT EXECUTE ON dbo.[Microsoft_ActiveDirectory_Report_Library_ReportEventListParse] TO OpsMgrReader
GO