Can't you combine a node name and a filespace name to a unique combination?
Cheers, Rick On Thu, Mar 13, 2014 at 5:16 PM, Loon, EJ van (SPLXM) - KLM < [email protected]> wrote: > Dear TSM-ers, > > I'm trying to generate a SQL statement to create a list of filespaces > which are not backed up for more than 30 days, sorted on their occupancy > size. This is what I've got so far: > > > > select node_name, filespace_name, physical_mb from occupancy where > filespace_name in (select filespace_name from filespaces where > (days(filespaces.backup_end) < (days(current_date)-30))) order by > physical_mb desc > > > > It doesn't work however, because filespace names are not unique. As soon > as a different node is found with the same filespace_name it's listed > too and that's not what I'm aiming for. I guess nested SQL is not the > way to go, but I don't know the solution. > > Thanks you very much for your help in advance!!! > > Kind regards, > > Eric van Loon > > AF/KLM Storage Engineering > > > > ******************************************************** > For information, services and offers, please visit our web site: > http://www.klm.com. This e-mail and any attachment may contain > confidential and privileged material intended for the addressee only. If > you are not the addressee, you are notified that no part of the e-mail or > any attachment may be disclosed, copied or distributed, and that any other > action related to this e-mail or attachment is strictly prohibited, and may > be unlawful. If you have received this e-mail by error, please notify the > sender immediately by return e-mail, and delete this message. > > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its > employees shall not be liable for the incorrect or incomplete transmission > of this e-mail or any attachments, nor responsible for any delay in receipt. > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch > Airlines) is registered in Amstelveen, The Netherlands, with registered > number 33014286 > ******************************************************** >
