Automated report generation

Support topics for the enterprise version of ThreatGuard's SCAP products.
owensjp
Contributor
Posts: 12
Joined: Tue Apr 08, 2008 7:42 am

Automated report generation

Postby owensjp » Wed Apr 09, 2008 12:24 pm

Are there provisions for automatically generating reports, in addition to automated scanning? Also, is it possible to query the SQL Server 2005 Express database directly, to extract data in a different form?

gunnar
Site Admin
Posts: 81
Joined: Fri Feb 23, 2007 8:08 pm
Contact:

Re: Automated report generation

Postby gunnar » Wed Apr 09, 2008 7:03 pm

Response, part one:

owensjp wrote:Are there provisions for automatically generating reports, in addition to automated scanning?


The Magnus system is very SOAP-centric and supports a few summary and detailed support types, which are returned from the server as XML documents. When triggered via the Magnus Navigator client these reports can optionally be rendered via XSL transform into a more human-readable web page.

This is probably not quite what you are asking for, but it's unclear what you have in mind. Give me a bit more detail and I'll see if I can give you a better response.

gunnar
Site Admin
Posts: 81
Joined: Fri Feb 23, 2007 8:08 pm
Contact:

Re: Automated report generation

Postby gunnar » Wed Apr 09, 2008 7:11 pm

Response, part two:


owensjp wrote:Also, is it possible to query the SQL Server 2005 Express database directly, to extract data in a different form?


The default database used by Magnus is the redistributable SQL Server Express. The DDL used to create the tables and subsequent updates are saved to the Database directory under the Magnus Server install. Or you might find it easier to use a tool such as DBVis to map out the database.

You can then to do your own database queries, or use another product such as Crystal Reports to do your own custom reports. We are under no delusion that we could possibly cover everybody's needs for reports and data extraction, so licensed Magnus users are free to play with their database as best meets their needs.

owensjp
Contributor
Posts: 12
Joined: Tue Apr 08, 2008 7:42 am

A bit more background

Postby owensjp » Thu Apr 10, 2008 3:24 am

Thank you for your timely response! After our automated scans run each day, we would like to be able to extract a summary of the results and communicate that data to another host on our network. Based on Part 2 of your reply, it appears that pulling that data directly from the database may be the way to go. We'll explore that possibility and see where it takes us. Thanks again.


Return to “Secutor Magnus Support”

Who is online

Users browsing this forum: No registered users and 1 guest