question

MichaelHernandez-7772 avatar image
0 Votes"
MichaelHernandez-7772 asked MichaelHernandez-7772 commented

What Table associates the Manual Activities to Service Requests?

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.

msc-service-manager
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AndreasBaumgarten avatar image
0 Votes"
AndreasBaumgarten answered MichaelHernandez-7772 commented

Hi @MichaelHernandez-7772 ,

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LOL, it might be old and I might have some homework to do, but it will give me the mappings in the database I need to match the tables relationships. Thanks a bunch.

0 Votes 0 ·