Finding Out of Date Filespaces

[n9kws]

At our corp, it has come to light that out TSM server is keeping/managing filespaces which no longer corespond to real filesystems. We would like to clean them up, and Ihave bee asked to create a report whch lists filespaces which have NOT been backed up in the last 90 days.



My preliminary reseach shows that filespaces are tracked in the "filespaces" table, but doing the SQL query for the filespaces not backed up in the last 90 days has me stuped. Specifically, how do I convert the date/time fields to date fields for comparision?



Andy.

 

[heada]

/* ------------------------------------------------*/

/* Script Name: fsnobackup */

/* Description: Display file spaces that have not */

/* completed backup in X days. */

/* Parameter: days */

/* Example: run fsnobackup 10 */

/* ------------------------------------------------*/

select node_name,filespace_name,backup_end from -

filespaces where $1 < -

days(current_timestamp) - days(backup_end) or -

backup_end is null