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 <
Eric-van.Loon AT klm DOT com> 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
> ********************************************************
>
|
