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

Sophos Reporting

jsfrenette

Hello,

I've been requested to make periodic reporting of Sophos health. Each month, I must extract from Sophos:

- Number of managed and unmanaged computers

- Number of computer with errors

- Number of outdated computers

- Number of computers with virus alerts and adware alerts

My strategy is to extract this data from the DB and dump it into another DB, which contain all other data I have for other reports in my environnement. This way, I have the historical data I need out of sophos just for the reporting job.

Does anyone can help me pin point the data from the sophos DB so I can do that?

Thank you

:54961


This thread was automatically locked due to age.
  • 0
    Hello jsfrenette,

    please look up the Reporting Interface in the Support->Documentation section (sorry, no link - I'm on a mobile device).
    This sounds more like you need kinda snapshot from the Dashboard though - can't (nyah, don't want to do it from home) look it up before Monday.

    Christian
    :54964
  • 0

    Thanks for the reporting guide, didn't knew about that. Just that it refuse my connection though I can connect by sql management studio, weird... That's another story.

    Yes, in short, it's kind of the dashboard view my boss want, in a customized report for each month so we can have a view of how things are going by each months.

    :54968
  • 0

    Hello jsfrenette,

    as far as I can see - in case of the Reporting Interface you'd have to massage the raw data yourself to get meaningful statistics. There's a DataPoints table which seems to hold the Dashboard data but I haven't looked into the details (especially when which datapoints are written). Anyway the most challenging part is likely the number of outdated computers. The Dashboard considers only connected computers. SEC's Status/Update Details display Not since ...  but don't take the Last message time into account. Thus you'd probably have to come up with your own criteria and logic.

    Christian

    :54984
  • 0

    Thank you, I'll have a look at that table.

    :54988