
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-16-2011 03:53 PM
Hi all! Just starting to play with my company's Lansweeper install and loving it so far. I am trying to wrap my head around how I can go about finding which PCs in my OU have 2 specific IE hotfixes, XP SP3 and Java u24. Would this be possible using a SQL query and if so can someone point me in the direction to go to read up on this or maybe even a sample query construct? I've gone through all 28 pages of the 'share your code' section and seen a couple here'n'there that have a couple of parts to what I need...would this be achievable with one report query? Thanks for any assistance!!!
Labels:
- Labels:
-
Archive
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-17-2011 03:40 PM
Please try the query below. Replace "KB1000000" and "KB2000000" with the specific hotfix IDs you're after.
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain
From tblComputers Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername
Where tblComputers.Computername In (Select tblQuickFixEngineering.Computername
From tblQuickFixEngineering
Where tblQuickFixEngineering.HotFixID = 'KB1000000') And
tblComputers.Computername In (Select tblQuickFixEngineering.Computername
From tblQuickFixEngineering
Where tblQuickFixEngineering.HotFixID = 'KB2000000') And
tblComputers.Computername In (Select tblSoftware.ComputerName From tblSoftware
Where tblSoftware.softwareName Like '%Java u24%') And
tblOperatingsystem.ServicePackMajorVersion = '3'
Order By tblComputers.Computername
