EV8 reporting

[jpergola329]

hello,

can anyone recommend any way of getting automated reports from ev8?

is there a 3rd party tool out there or any scripts to get the info. ie. nightly archiving, etc....

thanks

[JesusWept3]

Use SQL Reporting Services and then set up a subscription
And when you get to 10 SP2+ there are far more detailed reports that can be accessed

Rob wilcox posted a youtube video detailing the new reports here:
http://www.youtube.com/watch?v=F4VMc6mHUs4

[JesusWept3 · Accepted solution]

Check out this white paper, goes through installation, configuration and example reports
http://www.symantec.com/business/support/resources/sites/BUSINESS/content/live/DOCUMENTATION/5000/DO...

[John_Santana]

What'sthe SQL Script to do the reporting ?

[JesusWept3]

So first of all, you install SQL Reporting Services.
Typically this gets installed on the SQL Server, but can be installed on the EV Server if you wanted, it has a relatively small footprint  and doesn't impact performance.

Then once you have installed and configured SSRS, you then run the EV Install binaries which has the Reporting Services option.

After the install, you then run the Reporting Deployment tool, and you specify where the EV Directory database is, it then goes and sets up a DataSource connection for SQL Reporting and uses a custom DLL.

It then deploys the RDL's which are the different operational reports (such as archived items per hour, billing etc)

Some Reports such as Items Accessed require Auditing to be enabled, reports such as Server Health require monitoring to be enabled, and any Data Analysis reports need FSA to be deployed and FSA Reporting to be enabled

[John_Santana]

Many thanks for the explanation Jesus !

I really appreciate your help.