This SQL returns the relationship between ReportView and their source.
Run on content store database.
This is for SQLServer.
SELECT
N.Name AS ReportViewName
,P.BASE AS ReportSource
FROM
CMOBJECTS O
INNER JOIN CMOBJPROPS6 P
ON
O.CMID = P.CMID
INNER JOIN CMOBJNAMES N
ON
O.CMID = N.CMID
WHERE
O.CLASSID = 19
AND N.LOCALEID = 122
No comments:
Post a Comment