Get a list of agents and recipients

938767

I am trying to get a list of all of the agents setup in our OBIEE isntance.

I've found the agents in the table s_nq_job

However, I need the report that the agent is using, and a list of the recipients of that agent. Is that possible?

Ebin

Hi,

Try generating Agent report from OBIEE catalog manager with columns Name & Email.

Thanks

Ebin

[Deleted User]

If you're looking in the database then the table you're looking for is S_NQ_JOB_PARAM.

Recipients is a bit more complex though because it really depends on how you get those recipients. If they're registered by named user or manually entered email addresses then you'll find them in the same table. If they're derived from a conditional analysis then obviously you will never know who the recipients are unless you actually run the conditional analysis.

Gianni Ceresa

Recipients, named users or manually entered emails, aren't in S_NQ_JOB_PARAM at least on 11.1.1.7, and the OP don't really say which version he is talking about. But they are coded in the XML of the agent itself, so not really the best place where to get them, but still better than, like Christian says, if based on a conditional analysis and there ... well ... they aren't stored nowhere as it depends on the result of the analysis.

[Deleted User]

Hahaha right my bad ;-)

938767

In the PARAM table, I see the path of the agen itself, but not the delivery content (aka the analysis that is sent out).

Do you know where that information would be stored?

938767

Can you give me a little more guidance on how to access the xml of the agent? Thanks

Gianni Ceresa

Use the Catalog Manager to find the agent (the file defining it) and there you can see the source of the file, the XML code.

There is also probably a webservice to get it, but can't remember right now ....

[Deleted User]

Alternatively you can get the XML from the actual files in the filesystem but that you should only do if you know what you're doing and you don't modify the files. Can be a bit touchy. But if you know grep more than the catalog manager you may prefer this route.