Jump to content


richtonp

WQL Split large amount of clients

Recommended Posts

Hi,

 

We have around 18 000 clients on which we have to deploy a package.

We would like to split them into collections of 300 clients max,

But we'd like to go with dynamic collection.

18000/300 = 60 collections.

Unfortunately, from what i've understood in WQL, you cannot use query such as "SELECT TOP 100 where update XXX not installed "... for each collections.

Do you have a tips that could help me with that ?

One solution would be to use the GUID , that would allow me to create 16 different collection for this update

"Select client where where update XXX not installed and GUID end by 1"

"Select client where update XXX not installed and GUID end by 2"

...

"Select client where update XXX not installed and GUID end by F"

But 18000/16 = 1125

Do you have another idea ?

 

Many thanks for your help

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.