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
Answers ( 2 )
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).
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?