How to export WCC Monitoring Views to a file

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent

Issue/Introduction

I am looking for a way to export the WCC Monitoring Views to a file

Environment

Release: All Supported Version
Component: WCC

Resolution

The utility to export the WCC Monitoring Views is wcc_monitor.sh on Unix/Linux or wcc_monitor.bat on Windows

The location of this utility is  $CA_WCC_INSTALL_LOCATION/bin for Unix or Linux or %CA_WCC_INSTALL_LOCATION%\bin on Windows

 

For example to export the WCC Monitoring Views on Linux to a file called views.save in your current directory, run

 cd $CA_WCC_INSTALL_LOCATION/bin

 ./wcc_monitor.sh -u ejmcommander -p <password of ejmcommander> -x views.save

 

 This output file can be used later to import these Views  in a new WCC database when moving from Derby to Oracle for example

 

If WCC is connected to an external directory, substitute ejmcommander with an external account which has administrative rights in EEM to access the Monitoring Views

 

Additional Information

Expected result when the user is ejmcommander and password ejmcommander  on Linux is:

cd /opt/CA/WorkloadCC/bin

./wcc_monitor.sh -u ejmcommander -p ejmcommander -x ./views.save

Workload Control Center Monitoring Batch Interface

Initialization.....................................

Authenticating with EEM....................................................................................

Exporting.................

........Export finished