To trace Cognos queries

[Cognoster]

Suppose a  report was created by getting data items from a content store which is by writing a user defined query.Can I check the query and the user information from back-end without accessing the report studio

[blom0344]

Sure, but you would need to start a database trace to capture the SQL involved. What are you after? The actual SQL executed against the content store would yield no information on the 'real' data to be fetched. You will need to run the trace against the source DB.
Unfortunately , traces generate A LOT of entries to be checked and you need to have the proper rights to start them..

[Cognoster]

many thanks blom, I am a beginner at using cognos, hope you will bear with me.
where should we start the trace on the Cognos side or DB side like checking DB sessions will that help...just guessing

Peace
Cognoster

[blom0344]

Hard to fathom were you are after. Are you interested in how and when Cognos is used? Then look for the audit database Cognos provides. If you want to catch 'loose' reports that include straight SQL (with potential performance issues) , then you will perhaps need to work with DB traces. The actual approach would also depend on the RDBMS you are working with. This would usually mean finding a friendly and cooperative DBA (unless you have sysadm rights)