Sccm 2007 query using query wizard

Posted on 2011-10-14
Last Modified: 2013-11-21
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.
Question by:Gjdalton
    LVL 11

    Assisted Solution

    About which hotfix you are talking about? Can you confirm it's presence with some registry key? Or some directory in Windows folder?
    LVL 31

    Expert Comment

    sql query like this:
    select * from v_Add_Remove_Programs where ProdID0 like '%KBXYZ%'

    Author Comment

    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.
    LVL 31

    Assisted Solution

    Is it listed here:
    wmic qfe list full /format:htable >C:\WindowsPatches.htm
    LVL 29

    Accepted Solution

    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.

    LVL 11

    Expert Comment

    What about directory in Windows folder? Is there directory (Hidden) maybe? Like KBxyz?

    Author Closing Comment

    none of these completely solved the problem

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Problem Description: Actually I found the below issue with some customers after migration from SMS 2003 to SCCM 2007 and epically if they change site code, some clients may appear in the console with old site code, plus old sites still appearing …
    Some time ago I faced the need to use a uniform folder structure that spanned across numerous sites of an enterprise to be used as a common repository for the Software packages of the Configuration Manager 2007 infrastructure. Because the procedu…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now