System Management

Want to know if your users store mp3 files on Desktop and My Documents folder?

1. Add .mp3 file type to Software Inventory Client Agent properties
   1. Navigate to Site Database – Site Management – Site Name – Site Settings – Client Agents and double click Software Inventory Client Agent
   2. Select Inventory Collection tab
   3. Click the new button and type *.mp3 as a file name.
   4. Set the location: All client hard disks or Variable or path name
      
   5. Click OK to close all open windows
2. (Optional) Wait for Software Inventory to run on all clients
3. Create a report using the following query:SELECT TOP (100) PERCENT SYS.Netbios_Name0, SF.FileName, SF.FileSize / 1024 AS [Size, KB], SF.FilePath FROM dbo.v_GS_SoftwareFile AS SF INNER JOIN dbo.v_R_System AS SYS ON SYS.ResourceID = SF.ResourceID WHERE (SF.FileName LIKE '%mp3') AND (SF.FilePath LIKE '%My Documents%') OR (SF.FileName LIKE '%mp3') AND (SF.FilePath LIKE '%Desktop%') ORDER BY SYS.Netbios_Name0