>Hi *SM-ers!
>I'm trying to create an SQL query to see which filespace is responsible for
>generating a lot of backup data for a specific node.
>I have tried the following query:
>
>SELECT OCCUPANCY.PHYSICAL_MB, OCCUPANCY.FILESPACE_NAME FROM OCCUPANCY
>OCCUPANCY WHERE (OCCUPANCY.NODE_NAME='OD0')
>
>When I execute this query it returns all filespaces at least twice, some of
>them even multiple times. I'm not an SQL expert, so I don't even know if
the
>query is correct for what I'm trying to accomplish.
>Can somebody please help me with creating the correct query?
>Thank you very much in advance!!
>Kindest regards,
>Eric van Loon
>