Configuration Manager Report Query for Systems with Torrent Software Installed
If you want to check if any of the client machines within your Configuration Manager network have torrent software installed, you can run this query directly on your SQL database or you can use it to create a report within SSRS.

How to create a Configuration Manager Report using SSRS

The query is below and can be altered to fit your own needs by adding columns and tables if or where required.

 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%'

COMMENTS

If you have any questions, query requests for Configuration Manager or general comments, please leave them below using our Disqus system.

Labels: , , ,