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?
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.