Eldo issac
asked on
SQL Query Help
Hello Guys,
I am using the following SQL script to get the execution stats for the reports created by querying the SSRS ReportServer:
One of the output columns is this:
My requirement is just to get the rdl names:
Can I modify the above given SQL code in anyway to get this type requirement attained. Currently I'm using excel for this purpose. Please look into this and suggest an edit in the query.
I am using the following SQL script to get the execution stats for the reports created by querying the SSRS ReportServer:
select username as [User Name], Itempath as [Report Name], parameters as [Variables], timestart as [Execution Start Time], timeend as [Execution End Time], TimeProcessing as [Total Time(ms)], status as [Outcome] from ExecutionLog3
order by TimeStart descOne of the output columns is this:
/{a42a9aba-ced8-4949-9721-8478f92528 7a}/biv/ae x/aex_repo rts/proces s_montitor ing_pa_sb_ details_pf _vol.rdl
/{3e2d7701-fbda-4c45-b5bd-ef666925e0 1e}/KPB/RP M_Phase2/T eam4_PR05_ Reports/Pr ocess_Moni toring_FOL D_Quantiti es_and_Yie lds_Yield_ Ph2A_GMDM. rdl
/{3e2d7701-fbda-4c45-b5bd-ef666925e0 1e}/KPB/RP M_Phase2/T eam7_PR05_ Reports/Pr ocess_Moni toring_CHR G_Quantiti es_and_Yie lds_Yield_ Ph2A_GMDM. rdl
/{3e2d7701-fbda-4c45-b5bd-ef666925e0 1e}/KPB/RP M_Phase2/T eam4_PR05_ Reports/Pr ocess_Moni toring_TFF 2_Quantiti es_and_Yie lds_Yield_ Ph2A_GMDM. rdl
/{d42a1aa2-3237-46f9-8ee3-fd3055f95f 65}/sites/ pr05_bi/KP B/SolubSul f/SolubSul f PR05 Reports/Process_Monitoring _Quantitie s_and_Yiel ds_Yield_P h2A.rdl
/{a42a9aba-ced8-4949-9721-8478f92528 7a}/biv/fo ld/fold_re ports/proc ess_monito ring_quant ities_and_ yields_gra ms_out.rdl
My requirement is just to get the rdl names:
process_montitoring_pa_sb_details_pf _vol.rdl
Process_Monitoring_FOLD_Quantities_a nd_Yields_ Yield_Ph2A _GMDM.rdl
Process_Monitoring_CHRG_Quantities_a nd_Yields_ Yield_Ph2A _GMDM.rdl
Process_Monitoring_TFF2_Quantities_a nd_Yields_ Yield_Ph2A _GMDM.rdl
Process_Monitoring_Quantities_and_Yi elds_Yield _Ph2A.rdl
process_monitoring_quantities_and_yi elds_grams _out.rdl
Can I modify the above given SQL code in anyway to get this type requirement attained. Currently I'm using excel for this purpose. Please look into this and suggest an edit in the query.
Nathan Riley
So you want to strip anything before process_monitoring? Is this always the case?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello Guys,
@Nathan: I want to strip everything before the .rdl name.
@Jim: Apologies for my mistake. I'll surely keep this in mind from next time on.
@Lokesh B R: Thanks for your reply. It's working perfect.
@Nathan: I want to strip everything before the .rdl name.
@Jim: Apologies for my mistake. I'll surely keep this in mind from next time on.
@Lokesh B R: Thanks for your reply. It's working perfect.