SQL Query : Find Computers with Torrent Software Installed

Query returns all devices with torrent software installed.  Please comment to share others.
Please note this query takes some time to run on a large client estate.

 Select SD.Name0, SF.FileName
 From v_Gs_SoftwareFile SF
 Join v_R_System SD on SD.ResourceId = SF.ResourceId
 Where SF.FileName Like '%Azureus%'
    Or SF.FileName Like '%BitComet%'
    Or SF.FileName Like '%BitLord%'
    Or SF.FileName Like '%BitPump%'
    Or SF.FileName Like '%BitTornado%'
    Or SF.FileName Like '%BitTorrent%'
    Or SF.FileName Like '%Shareaza%'
    Or SF.FileName Like '%Utorrent%'
 Order By SD.Name0, SF.FileName

Sample Output

Related posts

Leave a Comment