Re: [ADSM-L] query auditocc question

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:pdudley AT anl.com DOT 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 AT VM.MARIST DOT EDU] On Behalf Of 
David Ehresman
Sent: Wednesday, 27 July 2016 11:13 PM
To: ADSM-L AT VM.MARIST DOT 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 AT VM.MARIST DOT EDU] On Behalf Of 
Paul_Dudley
Sent: Tuesday, July 26, 2016 9:35 PM
To: ADSM-L AT VM.MARIST DOT 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

pdudley AT anl.com DOT 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.