• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 716
  • Last Modified:

Sccm 2007 query using query wizard

I am trying to figure out how to make a query in SCCM 2007 query wizard to find a hotfix on the machine. I want to use the query wizard and not a straight query language because I want to know what resources it uses.
The hotfix is not listed in Add/Remove programs. I can confirm it's presence using Get-Hotfix in Powershell.
0
Gjdalton
Asked:
Gjdalton
  • 2
  • 2
  • 2
  • +1
3 Solutions
 
X_layerCommented:
About which hotfix you are talking about? Can you confirm it's presence with some registry key? Or some directory in Windows folder?
0
 
merowingerCommented:
sql query like this:
select * from v_Add_Remove_Programs where ProdID0 like '%KBXYZ%'
0
 
GjdaltonAuthor Commented:
X_layer: Yes i can confirm the hotfix is there by looking in the registry and by running powershell check. Unfortunately I have been told our SMS server cannot do registry queries and it will not be added.

merowinger: As I said, the hotfix is not listed in Add/Remove programs.
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
merowingerCommented:
Is it listed here:
wmic qfe list full /format:htable >C:\WindowsPatches.htm
0
 
matrixnzCommented:
The best method in my opinion if you wish to find a resource class, is to right click a machine that has the patch installed on it, within SCCM Administrative Console.  Select Start - Resource Explorer

If you look at it like:
Hardware = System Resource Object Type
Sub Branches = Class Types
Column Names = Attributes

So once you find what you're looking for you can then use the Query Wizard based on that information.

Hope that helps.

Cheers
0
 
X_layerCommented:
What about directory in Windows folder? Is there directory (Hidden) maybe? Like KBxyz?
0
 
GjdaltonAuthor Commented:
none of these completely solved the problem
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now