Tsm server 7.1.7.100

I have a request to count the number of files in each directory on the e: drive 
for a node.
For output, path name, and file count.

Any pointers on where to start?

I can do it given a specific path,

Select count(*) from backups where node_name=bla and hl_name=bla and type='FILE'

How to extend this to all dirs. In a filespace?

Thanks for the help.