ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Idash report backup

book

Article ID: 240527

calendar_today

Updated On:

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.