Jump to content

Microsoft report builder


Recommended Posts

Hi,

 

We are using Microsoft Report Builder to generate summary reports for different customers

Is it possible to integrate the data from the Era Remote Administrator 6 database?

 

And are there SQL views or queries available so I can integrate the data in our summary reports

We want to know for each customer (group) the total threats last month and if scanner is up to date and top 10 system  with threats etc.

I hope that somebody can help

Link to comment
Share on other sites

  • 3 months later...

I create for each customer a groupname

And to get the groupname in your reports I use this query.

 

 

SELECT        dbo.tbl_computers.computer_name, dbo.tbl_log_threat_event.ThreatName, dbo.tbl_log_threat_event.UserName, dbo.tbl_log_threat_event.Occurred, dbo.tbl_static_groups.group_name
FROM            dbo.tbl_computers INNER JOIN
                         dbo.tbl_log_threat_event ON dbo.tbl_computers.computer_id = dbo.tbl_log_threat_event.SourceUuid_id INNER JOIN
                         dbo.tbl_static_groups ON dbo.tbl_computers.parent_id = dbo.tbl_static_groups.group_id

Link to comment
Share on other sites

  • ESET Moderators

Hello, we do not support direct access to the database. ERA has its own reporting tool which can view numerous data about the clients and export the outputs.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...