Querying CMS tables for users' security, history & favorites

[former_member248227]

Hello,

We are running BOBJ over a BW environment, and we've been asked to help design a Webdynpro interface that reads a user's security credentials in both BW and BOBJ servers and pulls in all reports, Bex or BOBJ, that they have access to.

To do this, we would need to query the CMS tables for:

• All reports a user is authorized to view
• Groups a user is associated with
• User's History
• User's Favorites

Does anyone have suggestions?  I've researched Query Builder, but I'm not sure if it can help us, as it accesses three virtual tables instead of the physical tables in the CMS.  The option I am guessing we will need to use is SDK. 

I'm fairly new to both BW and BOBJ, so any advice is appreciated.

Thanks

Scott

[nikhil_joy2]

Hello Scott,

Did you check the possibility of using Audit universe and reports? Please check below link for some useful sample files.

http://scn.sap.com/docs/DOC-53904

Regards,

Nikhil Joy

[former_member248227]

Nikhil,

Thanks for your reply.  Although a lot of information seems to be avialable via Audit queries, the information we need is not based on event tracking.  We are 85% to where we need to be now via Query Builder/ SDK.  I have been able to get to most questions we had to answer via Query Builder, and these queries can be replicated in SDK to have usable results.