Can someone direct me on this script, I need to add the FIleName into the output as well, need this asap.
select Sys.Name0, Sys.User_Name0, SF.FilePath,
Count(SF.FileName) as FileCount,
Sum(SF.FileSize/1024/1024) as 'Used Space'
from v_R_System Sys INNER JOIN v_GS_SoftwareFile SF on
Sys.ResourceID = SF.ResourceID
where SF.FilePath like '%'+'Users'+'%' +'%documents%' and SF.FileSize > 0 Group by Sys.Name0, Sys.User_Name0, SF.FilePath
having Count(SF.FileName) > 0 order by Sys.Name0 Desc