Idash report backup

Products

• iDash Workload Automation

Issue/Introduction

 How can I take the backup of all idash reports?

Environment

Release : 11.3

Component : IDASH WORKLOAD AUTOMATION AE

Resolution

You can run a sql query to get all the reports to back them up.

The following sql below will get all the reports plus the ones that are deleted.

select * from idash_config where type like '%report%';

    to cut those deletes out, you can do 

select * from idash_config where type like '%report%' and deleted = 0

 

The DBA should have a tool like SQL Developer from Oracle or something similar, which can easily export the select results into some other format, including as insert statements or CSV files is what we would recommend.