cancel
Showing results for 
Search instead for 
Did you mean: 

Report for Storage Usage / Image Size

Stefan_Schuelle
Level 2

Hi,

i need a Report that shows me the size used by a client divided by storage unit.

We have 2 appliances as puredisk, 4 mediaserver with 3tb advanced disk pool each, 2 tape libraries, 2 disk storage systems (HP Store once)

i need the size of all images (uncompressed, not deduplicated etc, raw size) for my clients on each of the systems.

it would be used for billing. 

and this for every client as a table view (export as csv) so we can match this with the clients list for the customers.

i hve a report but dont know if it is the correct way for my intention.

select LOWER(SUBSTRING(domain_imagecopy.imageid, 1, 8)) as 'Clientname', sum(domain_imagecopy.sizeinbytes)/1024/1000/1000 as "Image in GB", lookup_storageunittype.name

from domain_imagecopy, lookup_storageunittype

where 
domain_imagecopy.expirationTime>NomTimeToUTCBigInt(current_timestamp)
and domain_imagecopy.storageunittype = lookup_storageunittype.id


group by LOWER(SUBSTRING(domain_imagecopy.imageid, 1, 8)) , lookup_storageunittype.name order by LOWER(SUBSTRING(domain_imagecopy.imageid, 1, 8))

 

Thanks in advance

1 REPLY 1

DPeaco
Moderator
Moderator
   VIP   

I would like the same info!!!!!

I have 4 shared master servers, 11 media servers at 250 TB each, 2700 clients, and 150 PB of data per year. I'd like to know what clients are on the storage, size of the backup and when it actually expires.

Thanks,
Dennis