SCSM query to veiw Service Requests Details

 As if you have followed my last post regarding SCSM incident analysis. So thought of sharing a new post on which i will try to show case some details on Service Request tables and views.

Ok, to start work on the SCSM data warehouse database database and the tables and views its features for Service Request information details. As earlier I will follow the same old tactics. Putting a filter on the table as well as on the views with services. 

       Here again the most important table is ServiceRequestDim and from the name again it can be understood that its a dimensional table and will have multiple other related tables and also related facts tables on which we will discuss. So lets see what inside the table ServiceRequestDim  and the view on top of that table is ServiceRequestDimVw. 

select sd.Id ,sd.Status ,sd.CreatedDate ,sd.Description ,sd.DisplayName,sd.Title,sd.Status,sd.SupportGroup

,sd.SupportGroup_ServiceRequestSupportGroupId,sd.ClosedDate,sd.CompletedDate,sd.EntityDimKey,sd.FirstAssignedDate,sd.FirstResponseDate,

sd.ImplementationResults,sd.Priority

 from ServiceRequestDim sd

Above is the first basic query from which we get basic details of all informatons related to Service Request.As again we can put and filter on create date to see list of SR got created after a certain date or certain time.