Data Insight MSU table vs DFS

[Phil_Rosier]

I need to create a high-level report which amongst other things needs to give the number of files and folders for each physical and DFS share, which in theory I should be able to get from the MSU table (msu.file_count) however this particular field only seems to be populated for physical shares and not DFS shares.

Is there any reason why this field isn't populated for DFS shares, and any way around it other than to write a report to trawl through the dfspath table to count the paths?

As always, any advice is appreciated.

Thanks

Phil.

[Rishi_Thaper · Accepted solution]

Hi Phil,

The Folder count and File count is based of information available in the dashboard and is populated for physical shares only under MSU table. You can utilize following query to get file count for DFS shares.

From dfspath get absname, physicalname, file_count, msu.name where type = "DIR" and depth = "" and isdeleted=0

For getting Folder count for DFS shares, you can utilize following query:

From dfspath get msu.name, count(absname) where type = "DIR" and depth != "" and isdeleted=0 groupby msu.name

Thanks,

Rishi