Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 1 subscriber
  • Views 9145 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.
Parents
  • 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
Reply
  • 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
Children
No Data