<<If I know what volumes the node/filespace resides on, I can get the file size with>>
How about this select to get the volume(s).. warning.. looks like a long query.. select volume_name from contents where node_name='xxx' AND file_name='xxxx.xxx' Sung Y. Lee "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 11/25/2005 12:05:22 PM: > I know that this question has been addressed before, but I just want to > check that the situation remains the same with the current releases, > or if anybody has come up with a cheeky workaround/better solution. > > I am looking for a relatively efficient way of finding out how much data > in size is stored by TSM for certain files or file types (ie. .mp3 .wav > .avi ) > > I can get a list of the files with > > select ll_name,hl_name from backups where node_name='XXX' and > filespace_id=x and ll_name like'%.MP3%' > > If I know what volumes the node/filespace resides on, I can get the file > size with > > select node_name,filespace_name,file_name,file_size from contents where > volume_name='XXX' > > Is the file size accurate or is it the size of the aggregate that the > file is contained within ? (They all seem a little too rounded for my > liking) > > Also, this is not particularly easy in a non-colocated environment. > > So,............ is listing the volumes that the node/filespace is stored > on and then selecting from the contents of this list of volumes the only > way. > And, even if this is scripted, is it accurate or is it just the size of > the aggregates. > > Knowing that the GUI will list the filesize but it doesn't seem readily > available from SQL queries is truly a Friday afternoon annoyance. > > Leigh
