Microsoft.Windows.Server.AD.Class.Library.Report.Script.EventListParse (DataWarehouseScript)

Element properties:

Source Code:

<DataWarehouseScript ID="Microsoft.Windows.Server.AD.Class.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 &lt;&gt; 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 &lt;&gt; 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



                </Upgrade>

</DataWarehouseScript>