Find a specific file

[ahemphill]

I need to find all systems with this file
Windows\system32\jushod.exe

[cmoore]

I found the answer in the Knowldge Base concerning Conflicker and could adapt the query for the KB Patch I needed:
SELECT TOP 100 PERCENT dbo.tblComputers.Computername, dbo.tblComputers.Domain, dbo.tblOperatingsystem.Description,
dbo.TsysLastscan.Lasttime AS Lastscanned
FROM dbo.tblComputers INNER JOIN
dbo.TsysLastscan ON dbo.tblComputers.Computername = dbo.TsysLastscan.Computername LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE (dbo.tblComputers.Computername NOT IN
(SELECT computername FROM tblquickfixengineering WHERE hotfixid = 'KB958644')) AND (dbo.TsysLastscan.CFGname = 'QUICKFIX')
ORDER BY dbo.tblComputers.Domain, dbo.tblComputers.Computername


thanks...

[cmoore]

How would I querry for a specific hotfix? teh specific hotfix I need to find in this case is: WindowsXP-KB967715-x86-ENU.exe. Trying to run with this script returns no rows:

SELECT [Computername],
[FilePathfull]


FROM [lansweeperdb].[dbo].[tblFileVersions]
WHERE
tblFileVersions.FilePathfull LIKE '%WindowsXP-KB967715-x86-ENU.exe%'

or even just KB967715.exe.

thanks...

[Hemoco]

How is it sorted in the webpage, your query looks ok

[ueteam]

I used this code to determine the the Internet Explorer versions and made a report. However, I'm looking to sort the output automatically. In report builder, the output is sorted correctly, however when you click on the report from the webpage, it is not.

Here is the code I used:
Select Top 100 Percent tblFileVersions.Computername,
tblFileVersions.FilePathfull, tblFileVersions.FileVersion
From tblFileVersions
Where tblFileVersions.FilePathfull Like '%iexplore.exe%' And
tblFileVersions.FileVersion Like '%6.00%'
Order By tblFileVersions.Computername

Any assistance would be much appreciated.
I am a SQL noobie by the way... 🐵

[Cobra7]

First you need to add it to your scanned files in the LS GUI.

Then make the report looking in tblfileversions.

This is an example of the SQL code to make the report.

SELECT 
  tblFileVersions.Computername,
  tblFileVersions.FilePathfull
FROM
  tblFileVersions
WHERE
  tblFileVersions.FilePathfull LIKE '%jushod.exe%'