Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 10 replies
  • Subscribers 1 subscriber
  • Views 8370 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Old computers in my EC

FGamer

Hello All -

I would like to know if is possible to get a report of the total computers that didn't connect on the last > 90 days. Also is possible to remove these computers?

I would like to keep my console clean.

Thank you.

:8319


This thread was automatically locked due to age.
Parents
  • 0

    The list shows only computers which didn't connect in the last 90 days. Deleted=0 are the ones not deleted, i.e. visible in SEC. Othre flags are

    Managed: Managed=0 are the "grey" computers (the ones which have been found by some means but have not yet been protected).

    Connected: When Connected=0 there's the red cross on the computer icon. Note that this is not always correct (old computers might still show as connected).

    How can I list only the 0?

    WHERE COALESCE(LastMessageTime,0) < DATEADD(day,-90,GETDATE()) AND Deleted=0

    You can expand the expression as desired. Use () to group expressions.

    Christian

    :8341
Reply
  • 0

    The list shows only computers which didn't connect in the last 90 days. Deleted=0 are the ones not deleted, i.e. visible in SEC. Othre flags are

    Managed: Managed=0 are the "grey" computers (the ones which have been found by some means but have not yet been protected).

    Connected: When Connected=0 there's the red cross on the computer icon. Note that this is not always correct (old computers might still show as connected).

    How can I list only the 0?

    WHERE COALESCE(LastMessageTime,0) < DATEADD(day,-90,GETDATE()) AND Deleted=0

    You can expand the expression as desired. Use () to group expressions.

    Christian

    :8341
Children
No Data