Activity universe & Sample reports

[Former Member]

1. For Activity universe , any difference between BOXI R2 and BOXI R3

2. After DB level migration(by CCM) from R2 to R3, whether the R2 's activity universe and sample reports kept, or they have been replaced by the R3's activity universe and sample reports?

3. What is the default activity universe. it seems there are different version corresponding to different DB. After migration, I found the activity universe does not work,, need to import the corresponding one again, auditing_db_db2.biar. is the default one for MySQL DB?

[Former Member · Accepted solution]

It depends on how you installed and migrated the system.

If you specified your Audit database during the installation process, the correct sample reports will have been installed for your Audit database.

If you want to change the database or set it up after the installation is already complete, the packages for each database are stored in audit_bi.cab under package folder on the CD:

For DB2 auditing_db_db2.biar.xxxxxx

For MySql auditing_db_mySql.biar.xxxxxx

For Oracle auditing_db_oracle.biar.xxxxxx

For SqlServer auditing_db_sqlServer.biar.xxxxxx

For Sybase auditing_db_sybase.biar.xxxxxx

(xxxxx is an unconcerned alphabet and number, remove this after extracting the file from the cab archive)

Have you used Import Wizard to move any reports across from the R2 system? Depending on the setting used there the newly installed sample reports might have been overwritten.

I would not use the old sample reports if you dont have to, as audit database fields might have been changed between version and the data might be invalid.

Caroline

[Former Member · Accepted solution]

Hi Caroline,

Thank you very much for you reply.

I had done some tests and found

1. "Update objects" in CCM will import the activity universe, if there is an existing activity universe, it will be overwritten.

2. "Update objects" in CCM will import folder "Auditor" which contains all audit reports. If there is an existing Auditor folder in the repository, it will not import.

3. For the new Auditing Database schema, there is one more column added to audit_event, it is OBJECT_TYPE

4. I did a rough comparison on the activity universe between R2 and R3, they are basically the same.