Ok, I will bite, why? why not use reporting for this? WQL will be almost impossible to do this.
A collection only has to include the clients (computers) that in the last e.g. 10 days were only for a maximum of one hour online
Hi,
I am looking for the solution:
A collection only has to include the clients (computers) that in the last e.g. 10 days were only for a maximum of one hour online.
Thanks in advance
3 answers
Sort by: Most helpful
-
-
dnl24 101 Reputation points
2021-01-11T21:07:01.103+00:00 And how can I do this using Reporting?
-
SunnyNiu-MSFT 1,696 Reputation points
2021-01-12T10:18:01.557+00:00 We could use this following script to query the last onlinetime of these clients (computers) that in the last e.g. 10 days. Unfortunately, it seems that we could not be able to query the record of these clients (computers) that in the last e.g. 10 days were only for a maximum of one hour online.
SELECT
distinct
v_GS_COMPUTER_SYSTEM.Name0 as name,
v_CollectionMemberClientBaselineStatus.CNLastOnlineTime as LastOnlineTime
FROM
v_GS_COMPUTER_SYSTEM
INNER JOIN v_CollectionMemberClientBaselineStatus ON v_GS_COMPUTER_SYSTEM.ResourceID = v_CollectionMemberClientBaselineStatus.MachineID
where CURRENT_TIMESTAMP-CNLastOnlineTime < 10
If the response is helpful, please click "Accept Answer"and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.