This SQL query will find machines with Peer-To-Peer (P2P) Torrent File Sharing downloading Client’s installed.
The script below actually began as a By Request script that I was asked to create for a reader who wanted to know how to find machines with any versions of either UTorrent or BitTorrent installed. Since I know next to nothing about P2P clients I went to the web to find out more information. Then I added some of the more seemingly popular ones to the list. I chose to use “Like” rather than UTorrent.Exe to capture both the actual client applications and install downloads.
Note: I am sure that there are more P2P client applications out there specifically for downloading Torrent files so if you find any please comment on this post for the benefit of others.
Torrent SQL Query:
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
Below is a SQL query to find applications that are not only used to download Torrent files but other files as well using P2P technology.
Other File Sharing Applications SQL Query:
Where SF.FileName Like '%BearShare%'
Or SF.FileName Like '%eDonkey%'
Or SF.FileName Like '%Emule%'
Or SF.FileName Like '%Kazaa%'
Or SF.FileName Like '%LimeWire%'
Or SF.FileName Like '%Morpheus%'
Additional Information
Electronic Theft Using Torrents And P2P Technology
http://myitforum.com/cs2/blogs/dhite/archive/2007/03/04/electronic-theft-using-torrents-and-p2p-technology.aspx
SMS WQL Query To Locate Users With Prohibited Software
http://www.myitforum.com/articles/1/view.asp?id=2268
BitTorrent (protocol)
http://en.wikipedia.org/wiki/.torrent
No Comments