Hello Robert, As your storage pools are configured for deduplication, you have to choose the reporting_mb column (and not logical_mb) in order to have the same statistics with Q OCC ans SELECT FROM OCCUPANCY.
-- Best regards / Cordialement / مع تحياتي Erwann SIMON ----- Mail original ----- De: "Robert Ouzen" <[email protected]> À: [email protected] Envoyé: Mercredi 19 Août 2015 11:19:19 Objet: [ADSM-L] mismatch capacity H I to all I wanted to know for a specific nodename the amount of data backup on a specific stgpool Here the script: tsm: ADSM2>select sum(logical_mb) / 1024 as "Capacity of Data" from occupancy where node_name='MNHL2_CLUSTER' and stgpool_name='V7000_2' Capacity of Data ---------------------------------- 745.50 But when done the query: q occ mnhl2_cluster I got a different summary ! As you see much more data on storage V7000_2 ? I run too before a audit license tsm: ADSM2>q occ mnhl2_cluster Node Name Type Filespace FSID Storage Number of Physical Logical Name Pool Name Files Space Space Occupied Occupied (MB) (MB) ---------- ---- ---------- ---- ---------- ----------- ----------- ----------- MNHL2_CLU- Bkup /media/ns- 1 DEDUPTSM 49 - 2.04 STER s/APPS MNHL2_CLU- Bkup /media/ns- 3 DEDUPTSM 367,258 - 540,014.69 STER s/CSMS1 MNHL2_CLU- Bkup /media/ns- 3 V7000_2 44 - 74,920.13 STER s/CSMS1 MNHL2_CLU- Bkup /media/ns- 4 DEDUPTSM 221,781 - 1,224,645.8 STER s/CSMS2 8 MNHL2_CLU- Bkup /media/ns- 5 DEDUPTSM 135,968 - 1,324,964.7 STER s/CSMS3 5 MNHL2_CLU- Bkup /media/ns- 5 V7000_2 10 - 3,060.52 STER s/CSMS3 MNHL2_CLU- Bkup /media/ns- 2 DEDUPTSM 19,294 - 471,033.91 STER s/CSMS4 MNHL2_CLU- Bkup /media/ns- 2 V7000_2 1 - 137.14 STER s/CSMS4 MNHL2_CLU- Bkup /media/ns- 6 DEDUPTSM 1,758,166 - 799,055.63 STER s/DATA MNHL2_CLU- Bkup /media/ns- 6 V7000_2 176 - 441,244.84 STER s/DATA MNHL2_CLU- Bkup /media/ns- 7 DEDUPTSM 366,650 - 901,211.44 STER s/DATA2 MNHL2_CLU- Bkup /media/ns- 7 V7000_2 332 - 733,649.63 STER s/DATA2 MNHL2_CLU- Bkup /media/ns- 9 DEDUPTSM 1,286,727 - 2,253,114.2 STER s/NSCI 5 MNHL2_CLU- Bkup /media/ns- 9 V7000_2 46 - 14,892.99 STER s/NSCI Best Regrards Robert
