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

Extracting data for use with an internal dashboard

Nick Earle

Hi Jak,

I'm setting up an internal Dashboard to enable us to display data from various systems on one screen.

I'd like to include the status of our Sophos anti-virus deployment, including the viruses that have been detected and whether clients are up to date.

The Dashboard will be running on a separate sever, so I'd be grateful if you could suggest the best way to get the data. Can I use the Sophos Reporting Interface remotely? or should I be looking at direct table queries?

Any help would be appreciated,

Nick



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

    I'd probably stick to using the SRI (www.sophos.com/.../reporting-interface.aspx) to ensure it's supported. Unless it didn't include all the data I was after and then I might consider going outside of the interface.

    NOTE: A lot of data can be found in the view computerlistdata2 but querying something that may change in future releases could be a little risky.  That said it hasn't changed in the last 10 years other than getting new columns.

    I guess then you have the question on how to dynamically create the report/table.  A simple roll-your-own solution might be to have a scripting language (Powershell/VBS) query the database remotely and create a local HTML file.  The HTML file can have auto-refresh enabled (meta refresh tag/JavaScript) and the script to generate the HTML page could be scheduled from the TaskManager, say every 5 minutes depending on the complexity of the queries and if you have any concerns over the query times/load it places on the database.  This would provide you with a dashboard that you could load in IE Kiosk mode/full screen etc..  Maybe cycle a couple of pages with the refresh to avoid screen burn :).

    Regards,

    Jak

Reply
  • 0

    I'd probably stick to using the SRI (www.sophos.com/.../reporting-interface.aspx) to ensure it's supported. Unless it didn't include all the data I was after and then I might consider going outside of the interface.

    NOTE: A lot of data can be found in the view computerlistdata2 but querying something that may change in future releases could be a little risky.  That said it hasn't changed in the last 10 years other than getting new columns.

    I guess then you have the question on how to dynamically create the report/table.  A simple roll-your-own solution might be to have a scripting language (Powershell/VBS) query the database remotely and create a local HTML file.  The HTML file can have auto-refresh enabled (meta refresh tag/JavaScript) and the script to generate the HTML page could be scheduled from the TaskManager, say every 5 minutes depending on the complexity of the queries and if you have any concerns over the query times/load it places on the database.  This would provide you with a dashboard that you could load in IE Kiosk mode/full screen etc..  Maybe cycle a couple of pages with the refresh to avoid screen burn :).

    Regards,

    Jak

Children
No Data
Unfiltered HTML