Configuration Manager Report Query for Systems with Torrent Software Installed

If you need to check whether any managed machines have torrent client software installed — useful for enforcing an acceptable-use policy on corporate devices — this SQL query scans SCCM’s software file inventory for common torrent client executables and filenames.

The Query

SELECT
SD.Name0, SYS.User_Name0, SWF.FileName
FROM v_R_System SYS
JOIN v_GS_SoftwareFile SWF on SWF.ResourceID = SYS.ResourceID
LEFT JOIN v_R_User USR on USR.User_Name0 = SYS.User_Name0
LEFT JOIN v_R_System SD on SD.ResourceId = SWF.ResourceId
WHERE SWF.FileName LIKE '%Azureus%'
Or SWF.FileName LIKE '%BitComet%'
Or SWF.FileName LIKE '%BitLord%'
Or SWF.FileName LIKE '%BitTornado%'
Or SWF.FileName LIKE '%BitTorrent%'
Or SWF.FileName LIKE '%Shareaza%'
Or SWF.FileName LIKE '%Utorrent%'
Or SWF.FileName LIKE '%eDonkey%'
Or SWF.FileName LIKE '%Emule%'
Or SWF.FileName LIKE '%Kazaa%'
Or SWF.FileName LIKE '%LimeWire%'
Or SWF.FileName LIKE '%Flashget%'
Or SWF.FileName LIKE '%torrent%'

Requirement: this relies on Software Inventory being enabled and configured to scan for executable files (*.exe at minimum) in your Client Settings — if Software Inventory isn’t collecting file-level data, v_GS_SoftwareFile will be empty and this query will return nothing regardless of what’s actually installed. Add or remove filename patterns in the WHERE clause to match whatever client software list is relevant to your organisation’s policy.

Still Current on Configuration Manager 2603 (Updated for 2026)

The underlying v_GS_SoftwareFile software-file-inventory mechanism this query relies on is unchanged on current Configuration Manager (2603) — the same Software Inventory requirement applies: file-level scanning has to be explicitly enabled and configured to catch .exe files in Client Settings, or the view stays empty regardless of what’s actually installed. Worth treating the filename list as a living document rather than a one-time setup — torrent clients come and go, and new entrants won’t show up in a query written against a filename list from several years ago. Revisit the WHERE clause periodically against whatever’s current if this is being used for ongoing acceptable-use enforcement rather than a one-off audit.

Resources

• query
• How to create a Configuration Manager Report using SSRS
• WQL
• our SQL & WQL query library