Video Screencast Help

Find a Specific File Type and the Amount of Space It Is Using

Created: 02 Feb 2011 | 1 comment
JP330ci's picture
0 0 Votes
Login to vote

This uses the NS7 Inventory Solutions tables.

We recently needed to scan our environment for media files that weren't necessarily allowed, at the same time we decided to determine how much data they were using. So I wrote this SQL query to populate this information, I will build it into a flexible report soon to follow this article. This will take the table which is read in KB and move it to MB for easier relation, it also filters based on primary user / month. This way we can make sure that the data is as close to up to date as possible..

Select t0.[Name] as 'Computer Name',
t1.[User] as 'Primary User',
t2.[File Type] as 'File Type',
t2.[Total Files Reported] as 'File Count',
t2.[Total File Sizes (Kilobytes)]/1024 as 'Space Used'
from vComputer t0
INNER JOIN Inv_AeX_AC_Primary_User t1 ON t0.[GUID]=t1.[_ResourceGuid]
INNER JOIN Inv_SW_Disk_Usage_By_File_Type t2 ON t1.[_ResourceGuid]=t2.[_ResourceGuid]
WHERE t1.[Month] = 'January'
AND t2.[File Type] = 'mp3'
I'll attach the report soon enough.... hope you guys enjoy it.

Comments 1 CommentJump to latest comment

Cesar_echeverria's picture

I have this report created, the difference is that group by equipment and is filtered by extension.
must create the view, attached the two files (Report and view)
I hope to serve you

Report Disk Usage by File 3.64 KB

Cesar Echeverria Castillo

Consultant Engineer

InterLAN Ltda, Medellin, Colombia

P.S.: If this works please let the community knows about it.

Login to vote