Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

Where does the job output store in Admiral DB (i.e in which table)

            i have been working to setup Tivoli alerts for some of our High prio jobs and trying to figure out if the job output which is shown in output tab is stored in DB

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: Where does the job output store in Admiral DB (i.e in which

Hi Anilkumar,

There is a data model document which lists all the tables, I've attached a copy to this response for future reference.

The job output is stored in the JobOutput table and the jobrun_output field has the actual output.

Thanks,

Prakash

7 REPLIES
Cisco Employee

Re: Where does the job output store in Admiral DB (i.e in which

Hi Anilkumar,

There is a data model document which lists all the tables, I've attached a copy to this response for future reference.

The job output is stored in the JobOutput table and the jobrun_output field has the actual output.

Thanks,

Prakash

New Member

Re: Where does the job output store in Admiral DB (i.e in which

Thanks Prakash for the document, it is very helpful.

New Member

Re: Where does the job output store in Admiral DB (i.e in which

The job output stored in the JobOutput table shows below message, Any suggestions

Job output data is in XML format. To view job output upgrade your Client to latest version.

Cisco Employee

Where does the job output store in Admiral DB (i.e in which tabl

Sounds like a message coming from your Oracle Client.  If that's the case then it's asking you to upgrade the Oracle Client to view the xml output.  Otherwise, you might extract the data via sqlplus then view it in another application.

New Member

Where does the job output store in Admiral DB (i.e in which tabl

Hi there, I have MS SQL 2012 backend and recently upgraded from TES5.3.1 to 6.1. I would believe my client and db is up todate. The XML data is encrypted (not human readable). Any idea how to extract or search for it as it will not be possible to search via the Tidal Web thin client. Thanks.

New Member

Re: Where does the job output store in Admiral DB (i.e in which

Connie, did you ever get the answer to your question about displaying the XML output data? I'm trying use find the answer as well.

Cisco Employee

Re: Where does the job output store in Admiral DB (i.e in which

You can get at the output using the command line interface


Sent from Cisco Technical Support iPad App

820
Views
0
Helpful
7
Replies
CreatePlease to create content