Verify Database Table for CA Workload Automation IDASH
Article ID: 134084
Updated On:
Products
Issue/Introduction
Needs to verify the database table columns for CA Workload Automation IDASH
Environment
Release : 12.0 +
Component : CA WORKLOAD AUTOMATION iDASH FOR CA 7
Database: Oracle
Resolution
Run the following sql query
SQL> SELECT table_name FROM user_tables;
TABLE_NAME
--------------------------------------------------------------------------------
IDASH_CONFIG
IDASH_EVENT
IDASH_JOB_ID
IDASH_RUN
IDASH_AUTOTRACK
IDASH_ARCHIVE_EVENTS
IDASH_AVERAGE_RUNTIME
IDASH_JOB_RUN_CA7
IDASH_HIST_JOB_RUN_CA7
IDASH_JFM_CONSOLE_MESSAGE
IDASH_HIST_JFM_CONSOLE_MESSAGE
TABLE_NAME
--------------------------------------------------------------------------------
IDASH_BLOB
IDASH_DOC
IDASH_SLA_RUN
IDASH_SLA_PROBLEMATIC_JOBS
15 rows selected.
or refer to IDASH_HOME/install/oracle directory where you can review the alltables_manual.sql file against the iDash database.
Feedback
