Infrastructure.ChangeRequest

Purpose

Designed to display the output from the SharePoint List Change Request

The myHistory version of the request is designed to evaluate the effectiveness of the change management process.

Use Case

Owner: Simon Willmore
Typical Use Case: Change Management Dashboard presents key metrics such as the number of open and closed change requests
Style: Fact

Dashboards

Utilising this structured visual representation ensures effective change management and successful performance. This strategy significantly contributes to a streamlined change management process.

Change Request Dashboard (Global)

Change Request Dashboard (Wireframe)

Source

SharePoint List Change Request

Key Parameters

Company
Details

Sample Exec

EXEC get.myView @dataMart = 'Infrastructure', @viewName = 'ChangeRequest', @token = '<myToken>', @version = '<202404>'

Response

      ,src.[Title]
      ,src.[Overview]
      ,src.[Business_Justification]
      ,src.[Date_Raised]
      ,src.[Status]
      ,src.[Raised_By]
      ,src.[Change_Request_Type]
      ,src.[Impact_Assessment]
      ,src.[Change_Recommendation]
      ,src.[Change_Manager]
      ,src.[Actions_Required]
      ,src.[Team_Impacts]
      ,src.[Impact_Score]
      ,src.[Business_Area]
      ,src.[More_Info_Date]
      ,src.[On_Hold_Start]
      ,src.[Change_Request_Closed_Date]
      ,src.[PreviousStatus]

SQL

BMT-DWH-DEV/Infrastructure_ChangeRequest.sql

Leave a Comment