I checked and our audit license process runs at night every second day. It ran about 10 hours prior to the command below being run.
Thanks & Regards Paul -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul Zarnowski Sent: Wednesday, 27 July 2016 2:33 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] query auditocc question Paul, The metrics displayed by Q AUDITOCC are updated by AUDIT LICENSE; not in real time. ..Paul (sent from my iPhone) On Jul 26, 2016, at 9:37 PM, Paul_Dudley <pdud...@anl.com.au<mailto:pdud...@anl.com.au>> wrote: To keep track of our primary storage usage, on a weekly basis I run the following command: query auditocc pooltype=primary For one of the nodes - an SQL server - it is reporting that the backup storage used is 7Tb. However knowing the size of the databases on that server and the number of copies of each backup we keep, I believe that to be incorrect. I started the DP for SQL client on that server, clicked on Restore Data, and then selected all backups (both active and inactive). I then added up the size of each backup (both active and inactive) and it added up to 2.2Tb. How could there be such a huge difference between each total? Thanks & Regards Paul Dudley IT Operations ANL Container Line pdud...@anl.com.au<mailto:pdud...@anl.com.au> ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named add ressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your s ystem. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person. -- Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering. http://www.mailguard.com.au Click here to report this message as spam: https://console.mailguard.com.au/ras/1OVfnIigZp/43RuRtkrn8UcyaDwDNdZy5/0.222 ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named add ressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your s ystem. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
