BOXI Rel 2 - Audit

system · August 3, 2009, 8:15am

Hi All,

I am working with BOXI Rel2 and we have the ‘Audit’ facility available in the cmc.

I am trying to get a list of all the crystal reports in the live environment and what
folder(s) they belong to. I am under the assumption this can be done as long as you have the
auditor function.

I have access to the auditor db and have the following tables available.

APPLICATION_TYPE
AUDIT_DETAIL
AUDIT_EVENT
DETAIL_TYPE
EVENT_TYPE
SERVER_PROCESS

Does anyone know what I am trying to retrieve is possible and how?

Many Thanks

shin_11 (BOB member since 2008-01-03)

system · August 3, 2009, 8:46am

The auditing functionality audits user interaction and system events in BOXI not the contents of the CMS.

You can probably get the information you need from a tool called Query Analyser available in the desktop launch menu.

ABILtd (BOB member since 2006-02-08)

system · August 3, 2009, 8:53am

Hi Andy

thanks for the reply, query analyser is this a BO product part of the release?

Please can you tell me more about this…

Many Thanks

shin_11 (BOB member since 2008-01-03)

system · August 3, 2009, 9:58am

Hi

You can use Query Builder for getting this information.This is the link for
http://servername/businessobjects/Enterprise115/WebTools/websamples/query/logonform.aspx

If you want a list of Crystal Reports from your enviornment, you should query the CMS infostore

SELECT SI_NAME,SI_PARENT_FOLDER FROM CI_INFOOBJECTS where si_kind='CrystalReport' group by SI_PARENT_FOLDER

Now we’ll get all crystal report names and folder id to which report belongs. If you want to know the folder name. You should query again like

SELECT SI_NAME FROM CI_INFOOBJECTS where si_id=(id returned from si_parent_folder)

returned from the previous query.

Raul… (BOB member since 2007-07-31)

system · August 3, 2009, 10:07am

Thanks Raul, that has worked…brill…

is there a way to also extract what tables/views/stored procedures are being used in each crystal report?

Many Thanks

shin_11 (BOB member since 2008-01-03)

system · August 3, 2009, 12:12pm

As Far as I know there is no default way to get this information from the CMS.

Any object content requires that you open the object and parse it for the content.

There are pieces of code examples, freeware and commercial solutions which allow you to get the answer to your questions.

You solution will depend on what you need to parse in the files
Budget
other features these solutions may offer

ClaireB (BOB member since 2002-08-09)

system · August 3, 2009, 2:37pm

Thanks for all your replies…very helpful…

I am still abit stuck…as I have two folders
folder 1 = id :634974
folder 2 = id :289993

which hold all the crystal reports I am after…I have tried everything possible but I cannot get a list of crystal reports from these two folders seperately…

these are not the parent folders are subfolders…there is special code? Also how areyou guyz getting this code/schema?

Many Thanks

shin_11 (BOB member since 2008-01-03)