This post is more than 5 years old
1 Rookie
•
51 Posts
0
604
Custom report for time period, and excluding expired jobs
I'm trying to create a filter for a report so I can sure our RMAN admin any jobs he ran for a period from 6 months to 2 months ago that haven't yet expired. (He ran several jobs with no end date and space is getting low).
I ran a job for completed status with this date range, thinking this would only show me existing backup data, but it showed me all the jobs that were expired (most were by far).
When defining a report filter, for "Status", you can select "30930 - Expiration in past " but I want is any job that is simply NOT expired yet, without showing me data for jobs that have expired. I see no such option. I have no interest in data that is already expired and not eating up disk space. I must be overlooking something!
Avamar Exorcist
462 Posts
0
February 20th, 2017 06:00
If you just want to create a list of backups for a client which exist on the system you could run an MCCLI query via the utility node command line
mccli backup show --name=/client-domain/client-full-name --verbose=true
This will show you all backups for that client including when they were created and when they will expire.
You could even append a time scope to the query
mccli backup show --name=/client-domain/client-full-name --verbose=true --after="6 months ago" --before="2 months ago"
Example below...
0,23000,CLI command completed successfully.
Created LabelNum Size Retention Hostname Location Label Plugin Expires Server
----------------------- -------- ------ --------- ------------------- -------- ---------------------------------- -------------------- ----------------------- ------
2017-02-20 09:08:28 GMT 69 1.1 GB N avamar-utility-node.domain.com Local Exchange 2016-1487581003120#0 Windows Exchange VSS 2017-04-21 08:56:43 IST Avamar
2017-02-20 07:39:41 GMT 66 1.1 GB DW avamar-utility-node.domain.com Local 6 pm-Exchange 2016-1487527200009#0 Windows Exchange VSS 2017-04-20 18:00:00 IST Avamar
2017-02-10 18:08:33 GMT 63 1.1 GB D avamar-utility-node.domain.com Local 6 pm-Exchange 2016-1486749600008#0 Windows Exchange VSS 2017-04-11 18:00:00 IST Avamar
2017-02-09 18:05:31 GMT 60 1.0 GB D avamar-utility-node.domain.com Local 6 pm-Exchange 2016-1486663200009#0 Windows Exchange VSS 2017-04-10 18:00:00 IST Avamar
2017-02-08 18:04:38 GMT 57 1.0 GB D avamar-utility-node.domain.com Local 6 pm-Exchange 2016-1486576800009#0 Windows Exchange VSS 2017-04-09 18:00:00 IST Avamar