SRSS configuration question post EV 8.0.5 to 9.0.4 ugprade

[Sym-City]

Hello,

I have upgraded the environment I inherited but in the process our nightly subscription to the item archival rate report has broken.

Prior to the reporting upgrade it would auto increment the dates in the subscription and provide us with a daily report of yesterday's ingestion activity.

My question is how can I (and where would I) configure the subscription to once again use query based parameters for the start and end dates? (so I don't have to manually increment the date in the report every single day)

Further to that, what queries would I use?

Any help would be greatly appreciated

[Arjun_Shelke]

Have look at this thread....last 2 comments

https://www-secure.symantec.com/connect/forums/help-installing-enterprise-vault-90-reporting

[Arjun_Shelke]

For queries check post below

https://www-secure.symantec.com/connect/forums/ev-8-9-report-changed#comment-6245721

[Sym-City]

Thanks for the link

Unfortunately knowing nothing about SQL I'm still confused about how and where to implement the queries within SSRS.

I've tried looking for a step by step guide but can't find anything from Symantec or the community