I'm using the following query to get SSRS report execution related information:
select username, parameters, Itempath, timestart, timeend, TimeProcessing, status from ExecutionLog3
where ItemPath like '%reportname'
In here, the output of ItemPath comes like this:
/{a42a9aba-ced8-4949-9721-8478f925287a}/BIV/AEX/AEX_Reports/Batch_Details.rdl
My requirement to trim this column and just output the report name:
Batch_Details.rdl
Is it somehow possible to do this by modifying the above mentioned query? Currently I'm using excel for this purpose.
Please look into this.
Aucun commentaire:
Enregistrer un commentaire