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

Read More