CA Workload Automation iDash report ownership change

Products

• iDash Workload Automation

Issue/Introduction

We have a requirement to change the reports owner name to the service account, to be able to execute the reports through CA WA iDash CLI utilities.

Unfortunately the service accounts being used in the organization only has the CA Workload Automation iDash CLI access. 

Is it possible to change the report owner name for iDash report definition? If so, How can it be achieved?

Environment

All CA Workload Automation iDash client environments

Resolution

A new report can be created through iDash CLIs, using the existing report definition.

Below is an example with the procedure: 

1) Export the definition: 

 C:\Program Files\CA\idash\bin>idlist.bat -t autotrack.report -n jobs_autotrack_report -u owner_name

idash.report.autotrack.fromTime=00:00

idash.report.autotrack.fromdate=

idash.report.autotrack.instance=<ALL>

idash.report.autotrack.job=<ALL>

idash.report.autotrack.level=2

idash.report.autotrack.name=jobs_autotrack_report

idash.report.autotrack.owner=owner_name

idash.report.autotrack.past.days=7

idash.report.autotrack.past.hours=-1

idash.report.autotrack.selected.columns=Instance,Type,User,Time,ID,Field,Value

idash.report.autotrack.sort=Instance:D,Type:D,User:D

idash.report.autotrack.time.format=<default>

idash.report.autotrack.timezone=UTC

idash.report.autotrack.toTime=23:59

idash.report.autotrack.todate=

idash.report.autotrack.type=<ALL>

idash.report.autotrack.users=<ALL>

 C:\Program Files\CA\idash\bin>idlist.bat -t autotrack.report -n jobs_autotrack_report -u resrd0142 > jobs_autotrack_report_def.out

 

2) Open the resultant file (jobs_autotrack_report_def.out) in a text editor and update the value for "idash.report.autotrack.owner" to the new owner.

 Execute the following, which creates a new report with updated owner name:

C:\Program Files\CA\idash\bin>idupdate -t autotrack.report -n jobs_autotrack_report -f jobs_autotrack_report_def.out [-r]

C:\Program Files\CA\idash\bin>

The original report owner may take necessary action [delete] the existing report after creating the new one through the CLI user as needed.

Note: The replace option (-r) is ignored as it's the owner name change.