Wasn't sure if this fits in the DRM sub-forum or not, so my apologies if its in the wrong place.
Using the Operations Center, I have been sending our NOC a report of tapes daily to be handled for off-siting. However, I've discovered a bug and I am not sure how to correct it and have been unable to find a similar thread here or help online. All guides point me to the same SQL query, the one below:
This query will tell me DRM tapes that are also Storage Pool volumes. However, it ignores database backup volumes. I've attempted to modify it but I end up with a list containing many duplicate entries for each tape.
Has anyone here modified this script or created a secondary script that the database volumes?
Using the Operations Center, I have been sending our NOC a report of tapes daily to be handled for off-siting. However, I've discovered a bug and I am not sure how to correct it and have been unable to find a similar thread here or help online. All guides point me to the same SQL query, the one below:
Code:
SELECT drmedia.volume_name as "Volume", drmedia.state as "State" FROM drmedia, volumes WHERE drmedia.volume_name=volumes.volume_name AND drmedia.state='COURIER' ORDER BY drmedia.state
This query will tell me DRM tapes that are also Storage Pool volumes. However, it ignores database backup volumes. I've attempted to modify it but I end up with a list containing many duplicate entries for each tape.
Has anyone here modified this script or created a secondary script that the database volumes?