Check how many records have passed their delete date

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Need SQL query to Check how many records have passed their delete date.

Environment

CA Automic Applications Manager

Resolution

This SQL query can be used to check the so_print_log table for records that have passed their deletion date.

It is recommended to backup your tables first before you run any kind of update or delete statement.

To find out how many files are affected:
log into SQL*Plus as the Applications Manager Oracle user:
select count(*) from so_print_log where so_delete_date < sysdate;

To get the file info:
log into SQL*Plus as the Applications Manager Oracle user:
select so_operator, so_full_pathname from so_print_log where so_delete_date < sysdate;

Please contact Automic Support for the delete statements to delete the entries.