Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 1 reply
  • Subscribers 1 subscriber
  • Views 3570 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

SQL Query to find Endpoint machines with "Up to date"

aburrow

I'd like to run a SQL Query against our Sophos DB to find those machines with "Up to date" set for a specific date and time.

Does anyone have such a query?

Thanks

:32885


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

    HI,

    If I understand what you're looking for, I don't think it's possible to find from the database if a computer was up to date for a specific time in the past.

    In the computersanddeletedcomputers table, the computer record has a PackageID, which links to the current package information in the Packages table.  So although there is previous package informaiton available there is no packageID over time for a computer.

    The query:

    /search?q= 28885

    might help you with out of date though.

    Regards,

    Jak

    :32889
Reply
  • 0

    HI,

    If I understand what you're looking for, I don't think it's possible to find from the database if a computer was up to date for a specific time in the past.

    In the computersanddeletedcomputers table, the computer record has a PackageID, which links to the current package information in the Packages table.  So although there is previous package informaiton available there is no packageID over time for a computer.

    The query:

    /search?q= 28885

    might help you with out of date though.

    Regards,

    Jak

    :32889
Children
No Data