Query to get security information from BEXI

[mynameant]

Hi All, We are using BEXI Release 2 and are in need of finding what report is being access by what group or users.
Is there any way to build a query and fetch from BEXI Database? If so, does any one has a query available. I am incharge of generating this report and definitley do not want to manually prepare it as we have 250 reports and tons of groups. Any kind of help is greatly appreciated.

Thanks,

 

[Turkbear]

Hi, Do you mean 'what reports can a user or group access' or 'what reports have been accessed and by whom'





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

 

[PatBITK]

Hi, the answer is Yes.

The only way to query the System Database is using the SDK. You can do that by coding your own script (I wouldn't know where to start) and also the Query Builder:

http://webserver:8080/businessobjects/enterprise115/adminlaunch/query/default.htm

If you can spend a bit of money, have a look at

http://www.gbandsmith.com/

(360 Tool) it will do all that a much more.

Cheers,



Business Objects Consultant and Trainer
BOCP - BOE and CR & Official Migration Specialist

BI Toolkit - Offices in UK and Holland

http://www.bitoolkit.com

 

[mynameant]

To Turkbear:- Yes, that's what I need. Can you provide a script for it? I can build a script if I know what objects I need to look at it. If you know what objects I should query, that'll help too.

To, patBIK:- I think you gave a URL from your server But, my problem lies with Query builder. I am not sure what objects to query. Query Builder is one of the poorest tools I have ever seen [that is just my opinion, though].


Thanks for any help you guys can provide.

 

[PatBITK]

Hi,

Well, replace "webserver" by your servername!? :

http://webserver:8080/businessobjects/enterprise115/adminlaunch/query/default.htm

(my server is not called webserver)

Yeah the query builder is poor and not easy to use that's for sure.

They query you are looking after is not that simple I think, I would suggest posting on SDK forums like BO Diamond for instance.

Try an eval of 360, that will do it for you.

Business Objects Consultant and Trainer
BOCP - BOE and CR & Official Migration Specialist

BI Toolkit - Offices in UK and Holland

http://www.bitoolkit.com

 

[kskid]

I get an error

Error: Plug in does not exist

Any idea what I am missing?

It would be nice to know the DB structure used in BO Enterprise.

 

[PatBITK]

What do you do to get this error?

Business Objects Consultant and Trainer
BOCP - BOE and CR & Official Migration Specialist

BI Toolkit - Offices in UK and Holland

http://www.bitoolkit.com

 

[kskid]

Oh That was a dumb move on my part. Here's what I processed (It's from the sample query listed above the query box)

SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND = 'CrystalReport'

 

[cmmrfrds]

If you have BOXI premium then you should have the Audit database. Who viewed what reports when is information in the Audit database and you don't have to use the SDK for this just simple SQL.

 

[kskid]

Where do I find the table names and field names along with the field datatype?

 

[cmmrfrds]

Talk to your DBA or BOXI administrator. When they setup BOXI they would have setup a database for the Audit data. Any SQL tool can be used to view the meta data on the database.

 

[hilfy]

If you're trying to find which reports a user has access to or who has access to a specific report, it gets complex and can't be done in a single query in the Query Builder. If you're assigning access by user group at the folder level (best practice) instead of by user at the report level, you have to go at it from two directions - get the list of groups a user is assigned to, then get the list of groups that have access to a report.

At the 2007 Insight conference I did a session on User Access Auditing that included a C# .NET application that I wrote. You can access the presentation and the sample code on my website at

http://www.geocities.com/geekgurl7/Intro.html.

(It also connects to the audit database to get the last activity date - our audit db is on Oracle, so it uses the Oracle Data Access components....)

-Dell

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

 

[hilfy]

Also, if you're looking for info about the query language, you can go here:

http://devlibrary.businessobjects.c..._doc/html/QueryLanguageReference.html#2146566

Click on the links to get to information about the specific elements that are available for different types of objects.

-Dell

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