ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Check how many records have passed their delete date

book

Article ID: 88686

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Check how many records have passed their delete date

Environment

Release: AAMORS99000-9.0-Automic Applications Manager-Oracle - RMS
Component:

Resolution

Applicable to Applications Manager Versions:  v7.1, v8.0, v9.0
 
Detailed Description and Symptoms
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.
 

Investigation
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;

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