What Table associates the Manual Activities to Service Requests?

Michael Hernandez 116 Reputation points
2021-10-28T16:01:34.413+00:00

I am trying to build a custom report, but i cannot seem to find a way to tie the dbo.ActivityDimvw to the dbo.ServiceRequestDimvw. I tried a join on the column EntityDimKey and that did not work. I tried looking BaseManagedEntityId and that did not match. I have been trying for 2 days now. All I need is the Contactmethod column to be brought over into the servicerequestdimvw. This is needed because the Contactmethod for the MA in the ActivityDimvw is different than the Contactmethod on the ServiceRequestDimvw even though the information is there on the SR.

Service Manager
Service Manager
A family of System Center products for managing incidents and problems.
210 questions
0 comments
Accepted answer
  1. Andreas Baumgarten 97,731 Reputation points MVP
    2021-10-28T20:14:34.823+00:00

    Hi @Michael Hernandez ,

    on this webpage you can download the `SM_job_aids.zip``: https://techcommunity.microsoft.com/t5/system-center-blog/updated-sizing-tool-for-scsm-2012-now-available/ba-p/345611

    The zip file contains the DWDataMart.vsd , the schema of the SCSM data warehouse. It's an older version but maybe it helps to find the information you are looking for.

    ----------

    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

    Regards
    Andreas Baumgarten

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest