Archive size and files check

[flump]

Hello all !

So, i have a filespace "archivepool", which contains various projects, prj_1, prj_2 and so on.

i have one folder on strage and i'm not sure it reflects whats in the archived folders.

which is the fastest way to know the size & total number of files in that archive so that i can compare it with what i have on disk ?

Thank you

 

[RecoveryOne]

Take a peek here:
http://thobias.org/tsm/sql/#toc70
May get you pointed in the right direction.

 

[flump]

Hey Recovery One !

Thanks for the link i'll check that !

i was wondering why this does not work .. it's on the client gui

 

[flump]

I think that's gonna take a while

 

[flump]

Hi, so i let the suggested query run for a while but it still did not return any result, i actually want to know the size of that particular archive package

I've tried :

1)
SELECT a.node_name, a.class_name, DATE(a.archive_date) as DATE, CAST(FLOAT(SUM(ao.bfsize))/1024/1024/1024 as DEC(14,1)) as size_gb, -
count(ao.bfsize) as number_of_objects -
FROM archives a, archive_objects ao -
WHERE a.object_id=ao.objid and a.node_name='ARCHIVE' -
GROUP BY a.node_name, a.class_name, DATE(a.archive_date)

Where archive is my nodename

and thought that i might switch :

SELECT a.node_name, a.class_name, DATE(a.archive_date) as DATE, CAST(FLOAT(SUM(ao.bfsize))/1024/1024/1024 as DEC(14,1)) as size_gb, -
count(ao.bfsize) as number_of_objects -
FROM archives a, archive_objects ao -
WHERE a.object_id=ao.objid and a.class_name='ROYAL FIRST' -
GROUP BY a.node_name, a.class_name, DATE(a.archive_date)



buth just hang there and do no results nor erros ..

 

[flump]

i found out a super thing over the forum for my problem :

https://adsm.org/forum/index.php?threads/how-to-count-size-of-archive.26643/

dsmc query archive -desc="ARCHIVE_DESC" -subdir=yes "/<path>/*"| grep 'B' | awk '{ print $1 }' | tr -d ',' | awk '{ sum+=$1} END {print sum/1024/1024/1024}'

exactly what i was looking for !!