Based on the post by KSchroeder (https://www-secure.symantec.com/connect/forums/infuriating-report-problem) I have amended the report to work on NS7.1.
I've also added to the original File Extention lists using the following
Pictures
'JPG','JPEG','PNG','GIF','BMP','TIF','TIFF','PSD'
Video
'AVI','FLV','M1V','M2V','M4V','MKV','MPG','MPEG','MP2','MP4','MOV','DIVX','XVID','WMV','OGG','WLMP'
Audio
'AAC','M4A','MP1','MP2','MP3','MP4','M4P','OGG','SWA','WMA'
ALL
'JPG','JPEG','PNG','GIF','BMP','TIF','TIFF','PSD','AVI','FLV','M1V','M2V','M4V','MKV','MPG','MPEG','MP2','MP4','MOV','DIVX','XVID','WMV','OGG','WLMP','AAC','M4A','MP1','MP3','M4P','SWA','WMA'
The Updated SQL Report is:
SELECT vc.name, vc.[User] AS [Primary User]
, SUM(du.[Total Files Reported]) as [Total Files]
, SUM(du.[Total File Sizes (Kilobytes)])/1024 as [Total Size(MB)]
, SUM(case when [File Type] in ('AVI','MPG','MOV','M4A','MP3','AAC','MP4','OGG','DIVX','M1V','M2V','MP2','MP4','MPE','MPEG','MPA','AA','WMA','WMV','JPG')
then du.[Total Files Reported] else 0 end) as [Total Media Files]
, SUM(case when [File Type] in ('AVI','MPG','MOV','M4A','MP3','AAC','MP4','OGG','DIVX','M1V','M2V','MP2','MP4','MPE','MPEG','MPA','AA','WMA','WMV','JPG')
then du.[Total File Sizes (Kilobytes)] else 0 end)/1024 as [Total Media Size(MB)]
,SUM(du.[Total File Sizes (Kilobytes)])/1024 -SUM(case when [File Type] in ('AVI','MPG','MOV','M4A','MP3','AAC','MP4','OGG','DIVX','M1V','M2V','MP2','MP4','MPE','MPEG','MPA','AA','WMA','WMV','JPG')
then du.[Total File Sizes (Kilobytes)] else 0 end)/1024 as [Business Files(MB)]
FROM vComputer vc
JOIN Inv_AeX_AC_Identification acid ON vc.Guid = acid._ResourceGuid
JOIN dbo.Inv_SW_Disk_Usage_By_File_Type du ON vc.Guid = du._ResourceGuid
WHERE vc.IsManaged = 1
AND DATEDIFF(dd, acid.[Client Date], GETDATE()) < 14
AND (acid.[OS Type] = 'Professional' OR vc.[OS Name] LIKE '%XP%' )
GROUP BY vc.Name, vc.[User], ACID._ResourceGuid
ORDER BY [Total Media Files] DESC