Need to create a collection which will automatically add 5% of active workstations of All system collection

Question

Hi Experts ,

I got a requirement that we need to create a collection which will automatically add 5% of active workstations of All system collection – Limiting collection to that newly created colllection

Collection name- 5% workstations = Need a query which will calculate active workstations from Limiting collection All system

in progress 1
Ketan Kamble 2021-04-09T19:15:23+05:30 2 Answers 23 views Beginner
0

Answers ( 2 )

  2. Ankit Shukla
    1
    2021-04-14T00:15:26+05:30
    Reply

    Not sure about 5% result, but you can count machines in your environment and then select top rows for that according to 5%.
    Take active clients=1, Check for latest hardware inventory like less than 15 days and select top row count like 1000 ( this is 5% of 20000 devices).

  4. Anoop C Nair
    0
    2021-04-09T21:13:20+05:30
    Reply

    Oops, I don’t have anything like that. I think you need to be very careful about all this kind of stuff or logic building with collection queries.

    I think this is going to impact the performance of the server itself when you have very complex WQL queries ….

    You can find an active workstation with this SMS_R_System.Active = 1?

Leave an answer

Sorry, you do not have permission to answer to this question .