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?
Hi,
Try generating Agent report from OBIEE catalog manager with columns Name & Email.
Thanks
Ebin
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.
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.
Hahaha right my bad ;-)
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?
Can you give me a little more guidance on how to access the xml of the agent? Thanks
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 ....
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.
Build on the foundational concepts from Part 1 with a deeper look at implementation patterns for extending the FDI semantic model. This session covers common use cases such as modifying subject areas, creating custom subject areas, combining external application models, and supporting custom security requirements. It also…
Hi, While using OAS or OAC latest version can we generate a report to view complete defition of semantic model/subject area. It helps to document and troubleshoot. thanks
I want to export all OAC RPD joins and conditions, is there a way to export or extract joins information. please suggest. Repository documentation doesn't gives joins, if any other way pls suggest.
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
