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

dnl24 101 Reputation points
2021-01-11T16:59:24.013+00:00

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

Microsoft Configuration Manager
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Garth Jones 2,076 Reputation points
    2021-01-11T20:40:26.33+00:00

    Ok, I will bite, why? why not use reporting for this? WQL will be almost impossible to do this.

    0 comments No comments

  2. dnl24 101 Reputation points
    2021-01-11T21:07:01.103+00:00

    And how can I do this using Reporting?

    0 comments No comments

  3. SunnyNiu-MSFT 1,696 Reputation points
    2021-01-12T10:18:01.557+00:00

    @dnl24

    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.