SCOM DW Query to retrieve Web Application Transaction requests

Question

Management is requesting monthly inventory reports of things we have monitored in our infrastructure. I have no problem retrieving all I need from the data warehouse, but I am stuck retrieving Web application transaction requests.

Some of our applications are "grouped" into web application transaction monitors. This produces one object of type 'Web Application Perspective' with a bunch of monitors underneath is (the requests):

Anybody knows a SQL query I can use to retrieve these request monitors?

The closes I have been to retrieve this has been joining vManagementPack and vMonitor:

*SELECT TOP (1000) *
FROM vManagementPack as MP
join vMonitor as MON on MP.ManagementPackRowId = MON.ManagementPackRowId
where MP.ManagementPackDefaultName like '%MPName%'*

This gets me the Monitor system & default names, but they do not contain the URLs:

Any help is appreciated!

Answer 1

Well I finally figured it out, but I had to do a request to the Operational Database. I could not gather this information form the warehouse.