Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 1 subscriber
  • Views 2573 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

Access to Enterprise Console data

MaxSoukhomlinov

Hi,

Does anyone know where we could find the database schema that's used for Enterprise console data?

We are trying to script sync of # of managed devices with another system and ideally would like not to rely on a Sophos scheduled report to email it out as a csv.

Cheers,

Max

:14021


This thread was automatically locked due to age.
  • 0

    Hi,

    Your best bet is to connect to the database with SQL Server Management Studio and have a look through the tables and views. ThreatInstancesAll and ComputerListData2 views will get you quite a bit of information about the machine records and any threats they  might have.  Maybe create a Database Diagram in SQL Server Management Studio to see how the tables fit together.

    Also of note and the more supported apporach would be to use the reporting interace if it covers the data you are after:
    /search?q= 8285

    Regards,

    Jak 

    :14029