→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ahemphill
Engaged Sweeper
I need to find all systems with this file
Windows\system32\jushod.exe
5 REPLIES 5
cmoore
Engaged Sweeper
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
Engaged Sweeper
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
Lansweeper Alumni
How is it sorted in the webpage, your query looks ok
ueteam
Engaged Sweeper
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
Champion Sweeper
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%'