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

Display Enterprise Dashboard on a webpage?

MattRR

So, my boss asked me to figure something out. We have an internal page that provides various useful things (times at different offices, shortcuts to resources, etc), and he would like for me to find a way to export the Sophos Dashboard to this site, so we can have an easy-to-access overview of the state of our systems. Has anyone done this, or know of a way to do this?

:38679


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

    HI,

    There isn't a way within the product but it's not too difficult and there are a few ways to do it .  What you have to work with dictates the best/easiest way.

    Firstly the data for the dashboard query is on a per-subestate level but I guess you just want the data from the entire estate.

    The raw data can be obtained by calling the stored procedure ComputerDashboardDataGet and it takes 3 parameters:

    1. SubestateID
    2. ServerGMT (UTC)
    3. OutOfDateThreashold

    For example:

    exec ComputerDashboardDataGet 1, '2012-03-21 00:00:00', '2012-03-21 02:00:00'

    I don't have a install to hand whilst writing this but if you have SQL Profiler you could see this query being called to give you an idea of the parameters you would need to pass, the ServerGMT is essentially the current date time and the OutOfDateThreashold is the current time with a offset. 

    So if you have SRS, you could make use this stored procedure to construct a report page you could integrate?

    Or you could write a small piece of VBS to execute the query, return the data to say a .html file with some basic formatting and link to that from your system?  Maybe the vbs would run every 10 mins and generate a report so the data was current but not hammering the database.

    How does your current system work?  What is it, a series of web pages for example?

    Regards,

    Jak

    :38681
Reply
  • 0

    HI,

    There isn't a way within the product but it's not too difficult and there are a few ways to do it .  What you have to work with dictates the best/easiest way.

    Firstly the data for the dashboard query is on a per-subestate level but I guess you just want the data from the entire estate.

    The raw data can be obtained by calling the stored procedure ComputerDashboardDataGet and it takes 3 parameters:

    1. SubestateID
    2. ServerGMT (UTC)
    3. OutOfDateThreashold

    For example:

    exec ComputerDashboardDataGet 1, '2012-03-21 00:00:00', '2012-03-21 02:00:00'

    I don't have a install to hand whilst writing this but if you have SQL Profiler you could see this query being called to give you an idea of the parameters you would need to pass, the ServerGMT is essentially the current date time and the OutOfDateThreashold is the current time with a offset. 

    So if you have SRS, you could make use this stored procedure to construct a report page you could integrate?

    Or you could write a small piece of VBS to execute the query, return the data to say a .html file with some basic formatting and link to that from your system?  Maybe the vbs would run every 10 mins and generate a report so the data was current but not hammering the database.

    How does your current system work?  What is it, a series of web pages for example?

    Regards,

    Jak

    :38681
Children
No Data