SELECT
ReportId,
ReportFullName,
ReportName,
RunURL,
Cast(Configuration as xml).query('/ReportInfo/User').value('.','varchar(max)') as [user],
Cast(Configuration as xml).query('/ReportInfo/Password').value('.','varchar(max)') as [password],
Cast(Configuration as xml).query('/ReportInfo/Url').value('.','varchar(max)') as rpt_url,
Cast(Configuration as xml).query('/ReportInfo/Domain').value('.','varchar(max)') as domain,
Cast(Configuration as xml).query('/ReportInfo/ReportFolder').value('.','varchar(max)') as report_folder,
Cast(Configuration as xml)
FROM TR_ReportsDef where reportType = 'MSRS' and reportid in (216,
217,
224,
237,
260,
261)
Report ID Query Print
Modified on: Thu, 16 Dec, 2021 at 10:01 AM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.