Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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):
Answers
-
Listing of Agent details are available in the Monitor Deliveries area of the OAC Console:
0 -
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.
0 -
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.
0 -
Thanks @Gianni Ceresa . We thought about that, but it is very tedious task. Hope in future we will get an option for offline catalog.
0 -
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)...
0 -
@Subhakara Netala-Oracle Can you add an Idea Lab entry for your requirements? Thanks,
0 -
Sure @Alan Lee - Oracle-Oracle. Thanks for the suggestion.
0
