Oracle Communities

Oracle Analytics and AI

Child Item

List of Agents

Summary: How can we get the list of Agent/iBots? In OBIEE we have BI Database Schema tables S_NQ_JOB and S_NQ_JOB_PARAM tables, from there we get the list including path and owner. Is there any way we have in OAC to get the list of all Agents?

Content (required): Agents/ iBots

Version (include the version you are using, if applicable): OAC July2022 update

Code Snippet (add any code snippets that support your topic, if applicable):

Find more posts tagged with

Reporting

Accepted answers

All comments

Alan Lee - Oracle-Oracle

Listing of Agent details are available in the Monitor Deliveries area of the OAC Console:

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/send-email-reports-and-track-deliveries.html#GUID-5193544C-5839-42E7-9D81-F1B231A53814

Subhakara Netala-Oracle

Thanks @Alan Lee - Oracle-Oracle. I have checked that before, but I am looking for the download or copy of the list options. The whole list I can get while searching on Catalog, like in below screenshot,

I am looking for download/export/copy option.

Gianni Ceresa

A real full list of agents can't be obtained from the database tables you mention: an agent can exist in your catalog without being in those tables.

The real reference for the agents is the catalog because that's where an agent is defined and stored.

Sadly OAC doesn't allow any offline access to the whole catalog because it hasn't been considered as something useful (a very questionable choice!).

For a 100% full list of all agents, Catalog Manager in offline mode (because that's the only way to bypass the security and also be able to list agents stored in personal folders) is the way to go.

Because of the lack of official way to get an offline copy of the catalog, an unsupported, undocumented workaround is to export a BAR, open it and extract the catalog folder somewhere (it's the good old filesystem based catalog format). Point your Catalog Manager in offline mode to that location and you can generate a report with what you need.

Subhakara Netala-Oracle

Thanks @Gianni Ceresa . We thought about that, but it is very tedious task. Hope in future we will get an option for offline catalog.

Gianni Ceresa

I did ask about the official way to get offline catalog access in OAS/OAC, not receiving a reply from PMs sounded like they did confirm to not see reasons for doing it (anyone having to administer and maintain this tool would disagree)...

Alan Lee - Oracle-Oracle

@Subhakara Netala-Oracle Can you add an Idea Lab entry for your requirements? Thanks,

Subhakara Netala-Oracle

Sure @Alan Lee - Oracle-Oracle. Thanks for the suggestion.