Page 1 of 1

Automated report generation

Posted: Wed Apr 09, 2008 12:24 pm
by owensjp
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?

Re: Automated report generation

Posted: Wed Apr 09, 2008 7:03 pm
by gunnar
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.

Re: Automated report generation

Posted: Wed Apr 09, 2008 7:11 pm
by gunnar
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.

A bit more background

Posted: Thu Apr 10, 2008 3:24 am
by owensjp
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.