To all, It appears that I have solved this problem. The issue was that the "expire inventory" command was not running to completion. It was being run with a duration parameter which did not allow it to complete the expire inventory of all nodes.
Thanks & Regards Paul -----Original Message----- From: Paul_Dudley [mailto:pdud...@anl.com.au] Sent: Thursday, 28 July 2016 10:11 AM To: 'ADSM: Dist Stor Manager' Subject: RE: query auditocc question Thanks. I ran this command and it ran successfully and provided me with a list of totals. However they are a lot higher than what is reported by my query auditocc command. Does it total just the primary storage or all storage pools? I am just interested in primary storage to keep track of storage used as we have the unified terabyte licensing for TSM. Thanks & Regards Paul -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of David Ehresman Sent: Wednesday, 27 July 2016 11:13 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] query auditocc question Perhaps the following query would give you better data: select node_name,sum(reporting_mb) as "TOTAL_OCCUPANCY" from occupancy group by node_name -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul_Dudley Sent: Tuesday, July 26, 2016 9:35 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] query auditocc question 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 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/1OVoBqtOtJ/3vhxB9XK9tUP8GWQIH6joI/0.022 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.
