|
Posted by maximillianx on July 11, 2005, 6:37 pm
If you were Registered and logged in, you could reply and use other advanced thread options
I would like to run a query against SMS that searches for any PC that has
any of the listed exe's installed on the system.
Can someone point me in a good direction for some updated info?
I have found this query, which is very useful, but it was current as of
2003:
--------------
SELECT DISTINCT
v_R_System.Name0 as 'PC Name',
vSMS_G_System_SoftwareProduct.CompanyName as 'Software Company',
vSMS_G_System_SoftwareProduct.ProductName as 'Product',
vSMS_G_System_SoftwareProduct.ProductVersion as 'Version',
vSMS_G_System_SoftwareFile.FileName as 'File Name',
vSMS_G_System_SoftwareFile.FileDescription as 'File Description',
LSS.LastScanDate as 'Last Software Scan'
FROM v_R_SYSTEM
INNER JOIN
v_GS_LastSoftwareScan as LSS ON
LSS.ResourceID = v_R_System.ResourceID
INNER JOIN
vSMS_G_System_SoftwareFile ON
vSMS_G_System_SoftwareFile.ClientId = v_R_System.ResourceID
LEFT JOIN
vSMS_G_System_SoftwareProduct ON
vSMS_G_System_SoftwareProduct.ProductId =
vSMS_G_System_SoftwareFile.ProductId
WHERE LOWER(vSMS_G_System_SoftwareFile.FileName) IN (
'aimster.exe'
,'ares.exe'
,'audio galaxy.exe'
, 'audiognome.exe'
,'bearshare.exe'
, 'blubster.exe'
,'cutemx.exe'
,'direct connect.exe'
,'edonkey.exe'
,'emule.exe'
,'filefreedom.exe'
,'filetopia.exe'
,'gnotella.exe'
,'gnucleus.exe'
,'gnutella.exe'
,'gnutellaLite.exe'
,'grokster.exe'
,'imesh.exe'
,'kazaa.exe'
,'limewire.exe'
,'morpheus.exe'
,'napigator.exe'
,'napster.exe'
,'overnet.exe'
,'piolet.exe'
,'songspy.exe'
,'swapnutinstall.exe'
,'WinMX.exe'
,'wrapster.exe'
,'xolox.exe'
) OR
(vSMS_G_System_SoftwareFile.FileName LIKE '%napamp%') OR
(vSMS_G_System_SoftwareFile.FileName LIKE '%shareaza%') OR
(vSMS_G_System_SoftwareFile.FileName LIKE '%urlblaze%')
ORDER BY v_R_System.Name0
-----------------
Regards,
Rob
|
|
Posted by Gordon Freeman on August 6, 2005, 7:14 am
If you were Registered and logged in, you could reply and use other advanced thread options
maximillianx 写道:
> I would like to run a query against SMS that searches for any PC that has
> any of the listed exe's installed on the system.
>
> Can someone point me in a good direction for some updated info?
>
> I have found this query, which is very useful, but it was current as of
> 2003:
Blubster is virus, don't use!
--
锘縄T Consulting
http://www.rent-a-pro.com/
|
| Similar Threads | Posted | | top ten list of viruses ever!!! | June 30, 2005, 3:18 pm |
| short list update | September 17, 2007, 2:15 pm |
| Where is the list of things Windows Defender Addresses? | August 16, 2007, 8:56 pm |
| Software showing on software list but not there | July 13, 2006, 5:57 pm |
| New Malware.j | August 29, 2005, 6:02 am |
| malware | September 5, 2005, 11:16 am |
| Malware | March 5, 2006, 7:39 am |
| VBS: Malware (GEN) | March 14, 2006, 3:11 pm |
| How to get rid of this malware? | December 22, 2008, 10:06 am |
| Spyware/malware | July 20, 2005, 6:09 am |
|
XML site map