You can of course use any reporting tool you like. The audit trail data is stored in the database. Crystal Reports, Oracle Forms and many other tools can be used for this job. It just it might be a lot easier to use the Alert Center that comes with DB Audit then reinvent the wheels. With the Alert Center you can easily design new report queries or use pre-built reports and schedule them as needed. The Alert Center based reports can be designed to include server name as one of the columns displayed on the report. Moreover, you can use the Alert Center to setup a central repository to store audit trails from all servers and have each report cover all audited servers at once. This way you can avoid sending multiple reports and also get a big picture of what is going on.

Sat Jan 27, 2007 10:59 pm

jrunt

Joined: 27 Jan 2007Posts: 6Country: USA

I am still trying to set up the central repository and alert center. I am having issues connecting from my desktop gui. Havn't had enough time to review and get working yet.

Mon Jan 29, 2007 3:32 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6739

If you get any errors or messages, please let us know what you get so we can start helping you.

Mon Jan 29, 2007 10:57 pm

jrunt

Joined: 27 Jan 2007Posts: 6Country: USA

I did get the central repository up and functioning for the most part. I am just working on how to best organize and store it in our environment. At this point I don't have a SQL Server that I can dedicate to it and am running it on a DBA server. We typically used shared DB servers (SQL also) in our environment and do not let other apps run there. So, I need to work on setting up an environment outside our normal shared environement so I can run the alert center and DB on the same server. I currently don't have licensing to do that.

From what I can tell, the Repository DB can not be set up unless alert center is available on the same machine. Or, am I missing something?

Tue Jan 30, 2007 4:24 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6739

The alert center and the repository db can be on different machines. It only needs a regular connection to the database. Nothing is really special. The repository database can be virtually any Oracle, SQL Server or DB2 UDB database. It is just with SQL Server you have more choices for how the data can be replicated to the repository. So if you don't have a spare SQL Server or space you can pick some other database. The repository database can be of course hosted on one of the audited servers, but then people who have access to the server will have access to the repository, which you likely don't want to happen.