Data Insight MSU table vs DFS
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 tab...
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
