Archived Items Access report gets data from two EV Audit database

[patriot3w]

Hi Guys,

In our production setup, there are two sites, each site has one audit database on different sql server, now the problem is the Archived items access/trends reports are actually getting data from the audit database which on the same instance as EV directory database. That means I only can get the report for one site, another site is totally empty.

Is there any vaule I can change from SQL server or from the SQL server reporting database?

Thank you.

[patriot3w]

Another issue: how to change the audit database to different SQl server instance if I need to run the Archived items access/trends reports ?

Thank you.

[Prone2Typos · Accepted solution]

I do not think it is possible to get information from both audit databases with teh default EV provided content. You may be able to author a seperate report to do so. That is something you can call us about if you need help.

THe following Technote shows how to move all the databases. . .including the audit.

http://www.symantec.com/business/support/index?page=content&id=TECH35744

I hope this helps.

J