Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

EV8 reporting

Created: 10 Jan 2013 • Updated: 11 Jan 2013 | 5 comments
This issue has been solved. See solution.

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

 

Comments 5 CommentsJump to latest comment

JesusWept3's picture

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

John Santana's picture

What'sthe SQL Script to do the reporting ?

Kind regards,

John Santana
IT Professional

--------------------------------------------------

Please be nice to me as I'm newbie in this forum.

JesusWept3's picture

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's picture

Many thanks for the explanation Jesus !

I really appreciate your help.

Kind regards,

John Santana
IT Professional

--------------------------------------------------

Please be nice to me as I'm newbie in this forum.

JesusWept3's picture

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/DOC5645/en_US/Reporting.pdf

SOLUTION