Paul, You are right. All of my data is in primary storage pools so I no longer worry about copy pools. Back when I had copy pools, my storage pool names would indicate whether it was primary or copy pool. Can you mask on pool name to distinguish between primary and copy pool?
If so, select node_name,sum(reporting_mb) as "TOTAL_OCCUPANCY" from occupancy group by node_name where stgpool_name like '%NAME MASK%'c Alternatively, select node_name,sum(reporting_mb) as "TOTAL_OCCUPANCY" from occupancy where stgpool_name in (select stgpool_name from stgpools where POOLTYPE='PRIMARY' ) group by node_name David -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul_Dudley Sent: Wednesday, July 27, 2016 8:11 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] 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. https://urldefense.proofpoint.com/v2/url?u=http-3A__www.mailguard.com.au&d=AwIFAg&c=SgMrq23dbjbGX6e0ZsSHgEZX6A4IAf1SO3AJ2bNrHlk&r=dOGCMY197NTNH1k_wcsrWS3_fxedKW4rpKJ8cHCD2L8&m=cU1nSXe9zeJeTXfHCck544vQ4tE90eevPhlpXBxSpRM&s=GAitD2h-npPX-E1RY9gr082WxH3H0K633k3kCMja6lM&e= Click here to report this message as spam: https://urldefense.proofpoint.com/v2/url?u=https-3A__console.mailguard.com.au_ras_1OVoBqtOtJ_3vhxB9XK9tUP8GWQIH6joI_0.022&d=AwIFAg&c=SgMrq23dbjbGX6e0ZsSHgEZX6A4IAf1SO3AJ2bNrHlk&r=dOGCMY197NTNH1k_wcsrWS3_fxedKW4rpKJ8cHCD2L8&m=cU1nSXe9zeJeTXfHCck544vQ4tE90eevPhlpXBxSpRM&s=S_a4rP7L9CwRlVTgwQvwpZYsMSjKtQXVSKY59I4w4eQ&e= 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.
