Report ID Query

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)