Oracle Communities

Oracle Analytics and AI

Child Item

Catalog Manager Query - OAC Report List - Login through Security Portal

We need a full list of Catalog contents from our OAC environment. All the documentation I've found states this needs to be done through the Catalog Manager CLI. I believe I have the query correct, however there's a hiccup with the credentials.

Our OAC login is via our company's security portal, not direct login. Therefore, attempting to query with my credentials doesn't work and locks my account.

How can I get this report with the login having to go through the extra step? If it can't be done, does anyone know a different way to pull this report (including BI Publisher items on the list)?

The query I'm working with: runcat.cmd -cmd report -online "https://OURCONNECTION/analytics-ws/saw.dll" -credentials "C:\myaccount\Desktop\mycredentials.txt" -outputFile "C:\my account\Desktop\Object.xls" -excelFormat -folder "/shared" -type "All" -fields "Path:Name:Signature:Content State:Owner:Creator:Created:ACL"

Find more posts tagged with

Reporting

OAC

Catalog Manager

Accepted answers

Chere-Oracle

Hello JPorisVU,

Are you able to run and download snapshots? If so, I recommend following these steps:

Run a Custom snapshot with all optional content deselected
Download the snapshot
Open the snapshot's local download in 7-Zip or other archive extractor
Open the content folder
Select the catalog folder and choose the Extract command
Choose where to place the extracted "catalog" folder in your local directory.

Use the resulting "catalog" directory folder in your command line with the -offline switch, instead of the -online switch. For example:

runcat.cmd/runcat.sh -cmd report -type "Action" -offline "C:\my account\Documents\catalog" -outputFile "C:\my account\Desktop\Object.xls" -excelFormat -folder "/shared" -type "All" -fields "Path:Name:Signature:Content State:Owner:Creator:Created:ACL"

All comments

Chere-Oracle

Hello JPorisVU,

Are you able to run and download snapshots? If so, I recommend following these steps:

Run a Custom snapshot with all optional content deselected
Download the snapshot
Open the snapshot's local download in 7-Zip or other archive extractor
Open the content folder
Select the catalog folder and choose the Extract command
Choose where to place the extracted "catalog" folder in your local directory.

Use the resulting "catalog" directory folder in your command line with the -offline switch, instead of the -online switch. For example:

JPorisVU

Thank you, @Chere-Oracle! I will try this and update this post when done.

JPorisVU

@Chere-Oracle That worked! Thank you so much.