
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-09-2009 12:35 AM
5 REPLIES 5

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-30-2009 05:53 PM
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...
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...

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-30-2009 03:24 PM
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...
SELECT [Computername],
[FilePathfull]
FROM [lansweeperdb].[dbo].[tblFileVersions]
WHERE
tblFileVersions.FilePathfull LIKE '%WindowsXP-KB967715-x86-ENU.exe%'
or even just KB967715.exe.
thanks...

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-29-2009 05:18 PM
How is it sorted in the webpage, your query looks ok

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-29-2009 12:46 PM
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... 🐵
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... 🐵

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-09-2009 12:50 AM
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.
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%'
