...For them i need their total filesize, count of their files, and their owner name
I was trying this query but it wasnt working.
Select Count(*), Sum(FileSize) as Total, Owner,
completesum=(select Sum(FileSize) from FileScanner.dbo.FileInformation)
from FileScanner.dbo.FileInformation...