Gjdalton
asked on
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.
The hotfix is not listed in Add/Remove programs. I can confirm it's presence using Get-Hotfix in Powershell.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
merowinger: As I said, the hotfix is not listed in Add/Remove programs.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What about directory in Windows folder? Is there directory (Hidden) maybe? Like KBxyz?
ASKER
none of these completely solved the problem
select * from v_Add_Remove_Programs where ProdID0 like '%KBXYZ%'