BOXI Rel2 Audit?

[informer30]

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

 

[Turkbear]

Hi,
You do not need the Audit facility to do that, you can use the Query Builder from the Admin page of the CMC...Part of the info it returns about reports is the folder containing the report.
The Audit data is used to track user actions...See :

http://help.sap.com/businessobject/product_guides/boexir2/en/xir2_bip_auditor_en.pdf

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[hilfy]

In fact, the audit reports can show you which reports are actively being used, but it won't show any information about reports that haven't been used.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[informer30]

Thanks for the information all, I am new to query builder and I have a parent folder which has a child folder which has all the reports I need. But how do I construct a query to pull all those report names back.

Many Thanks for your help...

 

[hilfy]

You'll have to do this in a couple of steps.

1. If the subfolder has a unique name, query for it's the SI_ID : Select SI_ID from CI_INFOOBJECTS where SI_NAME = 'foldername'

2. Take that value and query for the objects in the folder:
Select SI_Name from CI_INFOOBJECTS where SI_PARENTID = <the id from step 1> and SI_INSTANCE = 0 (This last part makes sure you get the report templates instead of any instances that the reports may have.)

If the subfolder name is not unique, you can start with the parent folders and work your way down using the SI_ID of the

You can also do this the other way around by starting at the report level:

1. Select SI_NAME, SI_PARENTID from CI_INFOOBJECTS where SI_KIND = 'CrystalReport'

2. Then take the various parent ID's and query for the folder names.

If you want to write some code to do this, I have a C# example of how to traverse the folder list and get all of the reports that are in them.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.