Link to home
Start Free TrialLog in
Avatar of janhoedt
janhoedt

asked on

Wql explained ... (sccm 2012)

Hi,

I m trying to get a grip on the wmi query language used in sccm 2012: understand syntax (just basics).
Please advise.

J.
ASKER CERTIFIED SOLUTION
Avatar of Rich Weissler
Rich Weissler

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of janhoedt
janhoedt

ASKER

Thanks, I m actually looking gor just basic understanding of wql in order to understand what a wql means. Mainly for the sccm exam.


Example of question:
Your network contains a System Center 2012 Configuration Manager environment.

You need to create a collection that contains all of the virtual machines.

Which query should you use?
      
A. select * from SMS_R_System
where SMS_R_System.ResourceID not in
  (select ResourceID from SMS_R_System
  where SMS_R_System.IsVirtualMachine != 1)
      
B. select * from SMS_R_System
where SMS_R_System.IsVirtualMachine != 1
      
C. select * from SMS_R_System
where SMS_R_System.IsVirtualMachine = 1
      
D. select * from SMS_R_System
where SMS_R_System.ResourceID not in
  (select ResourceID from SMS_R_System
  where SMS_R_System.IsVirtualMachine = 1)
Answer: C
Your choice: C


http://mustafakasikci.com/2012/06/sisteminizdeki-sanal-makineleri-gatewayine-gore-gruplandirin/

SQL uses both != and <> for not equal.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Just basic wql for the rxam: operators (f.e. ! = not) and understanding a wql when shown (as in example).
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial