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

SCCM query statement

I am trying to create a query rule for a collection that will find machine that match these criteria:
System Resource
IP Address
192.168.%

I am able to do this using the 'direct membership rule wizard' but that wizard does not give me the query language so that my collection will be dynamic.

Can someone give me the text needed in order to paste into the \Query Rule Properties\Edit Query Statement\Query Language window


Thanks
0
taartero
Asked:
taartero
  • 2
1 Solution
 
ExemplarCommented:
Hello taatero,

I think I'm understanding what you're looking for.  Have you tried a query like this:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where IPSubnets in ( "192.168.0.0" )

Let me know.

Thanks,
Exemplar
0
 
ExemplarCommented:
Hey taatero!

Did the query I gave you do the trick?  Please let me know.

Thank you,
Exemplar
0
 
taarteroAuthor Commented:
I was able to get this to work
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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