One of the challenges that I have been tasked with is providing a summary of the storage used by each NFS/SMB share at a node pool level.

i.e. how much X400 and NL400 space does /ifs/data/Library use?

This is possible by walking the entire directory tree for each directory under /ifs/data but that's also time consuming.

Looking at what resources InsightIQ uses, it appears that file /ifs/.ifsvar/modules/fsa/pub/latest/results.db has a lot of useful information in a nice and small SQLite3 database file except for one thing...

In all of the "stats_disk_pool" tables there is one piece of information missing: the LIN.

Is there any way to add the LIN to any of those tables or otherwise associate the information in those tables with the "disk_usage" table?

an example of a query that I can run now is:

select name from disk_usage where parent in (select lin from disk_usage where name = 'data' and parent = 2);

which is a long way of doing "ls /ifs/data".

Now where it gets interesting is being able to join the output of

select name,value from system_properties where name like 'disk_pool:name%';

select disk_pool,sum(log_size) from stats_disk_pool_atime_log_size group by disk_pool;

... but that takes some manual effort (to get the pool number out of "name") and only gives names to the disk pools.

The "squash" tables present the LIN but not the disk_pool.

Is there any way to join the squash tables to the disk_pool tables that I'm missing?