search cancel

Verify Database Table for CA Workload Automation IDASH

book

Article ID: 134084

calendar_today

Updated On:

Products

iDash Workload Automation

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.