> 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