SQL for auto import timestamp

Products

• iDash Workload Automation for CA 7

Issue/Introduction

SQL to get the auto import timestamp information for the PS2 instance from the idash_archive_events table:

Environment

Release : 12.1

Component : CA WORKLOAD AUTOMATION iDASH FOR CA 7

Resolution

select instance, file_time, file_name, rows_added, archive_type, time
from idash_archive_events
where instance = 'PS2';