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