OpenNMS › OpenNMS - discuss

Reporting

11 messages

Jesse White

Reporting

Reply Threaded

Some javascript/style in this post has been disabled (why?)

Hi list,

After spending some time reviewing different open-source monitoring solutions I’ve decided to settle on OpenNMS. To meet my organizations requirements, I will need to generate availability reports on all the devices in specific provisioning groups between any two periods of time. In order to do so, I was thinking I would integrate with JasperServer and would expand on the code-base provided in http://www.opennms.org/wiki/JasperServer_Integration. I would expand the code to allow one to pass variables to the reporting engine through the UI (provisioning group, start date, end date..etc). Do you guys think there would be a better way to do this? Are there any similar efforts in progress?

Thanks,

Jesse

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

douglasstvnsn

Re: Reporting

Reply Threaded

Some javascript/style in this post has been disabled (why?)

I like the thought of mashing up OpenNMS and JasperSoft or even Pentaho.

When you start looking at BSM type problem sets, these capabilities play very well together to give you alot of good capabilities.

Dougie!!!

-----Original Message-----
From: Jesse White <[hidden email]>
To: 'General OpenNMS Discussion' <[hidden email]>
Sent: Thu, Nov 5, 2009 12:29 pm
Subject: [opennms-discuss] Reporting

Hi list,

Thanks,

Jesse

------------------------------------------------------------------------------

Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 

trial. Simplify your report design, integration and deployment - and focus on 

what you do best, core application coding. Discover what's new with

Crystal Reports now.  http://p.sf.net/sfu/bobj-july

_______________________________________________

Please read the OpenNMS Mailing List FAQ:

http://www.opennms.org/index.php/Mailing_List_FAQ



opennms-discuss mailing list



To *unsubscribe* or change your subscription options, see the bottom of this 

page:

https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Lance Vermilion

Re: Reporting

Reply Threaded

It would be nice to see a coupled install packaged as part of ONMS that would include JaspeSoft stuff so people could get more reporting without having to figure it all out. Oh, and it would be nice to have some base reports included in that.

On Thu, Nov 5, 2009 at 12:06 PM, <[hidden email]> wrote:

I like the thought of mashing up OpenNMS and JasperSoft or even Pentaho.

When you start looking at BSM type problem sets, these capabilities play very well together to give you alot of good capabilities.

Dougie!!!

-----Original Message-----
From: Jesse White <[hidden email]>
To: 'General OpenNMS Discussion' <[hidden email]>
Sent: Thu, Nov 5, 2009 12:29 pm
Subject: [opennms-discuss] Reporting

Hi list,

After spending some time reviewing different open-source monitoring solutions I’ve decided to settle on OpenNMS. To meet my organizations requirements, I will need to generate availability reports on all the devices in specific provisioning groups between any two periods of time. In order to do so, I was thinking I would integrate with JasperServer and would expand on the code-base provided in http://www.opennms.org/wiki/JasperServer_Integration. I would expand the code to allow one to pass variables to the reporting engine through the UI (provisioning group, start date, end date..etc). Do you guys think there would be a better way to do this? Are there any similar efforts in progress?

Thanks,

Jesse

------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july

_______________________________________________ Please read the OpenNMS Mailing List FAQ: http://www.opennms.org/index.php/Mailing_List_FAQ opennms-discuss mailing list To *unsubscribe* or change your subscription options, see the bottom of this page: https://lists.sourceforge.net/lists/listinfo/opennms-discuss

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Les Mikesell

Re: Reporting

Reply Threaded

In reply to this post by Jesse White

Jesse White wrote:

> Hi list,
>
>
>
> After spending some time reviewing different open-source monitoring
> solutions I’ve decided to settle on OpenNMS. To meet my organizations
> requirements, I will need to generate availability reports on all the
> devices in specific provisioning groups between any two periods of time.
> In order to do so, I was thinking I would integrate with JasperServer
> and would expand on the code-base provided in
> http://www.opennms.org/wiki/JasperServer_Integration. I would expand the
> code to allow one to pass variables to the reporting engine through the
> UI (provisioning group, start date, end date..etc). Do you guys think
> there would be a better way to do this? Are there any similar efforts in
> progress?

Have you looked at the pentaho tools? And do you need historical data
values from the jrb's or just events from the database? I've been
looking for a nicer way to do things like show trends across somewhat
dynamic groups of values - like the bandwidth across internet-facing
router interfaces or CPU use on a farm of servers which may not be the
same set over time. The pentaho scheme seems to be to extract data
into a different database for reporting and analysis rather than working
directly with the live system but so far I've been using perl scripts
against http://www.opennms.org/wiki/Data_Export to get daily snapshots
of values into a database where I can keep them tied to my grouping keys
even after the live devices change. This might be more elegant if
someone could glue jrobin into pentaho's pdi (their
extract/transform/load tool) or something like that. Once you get
things into a layout that is reasonable for reporting, any of pentaho,
jasper, jfreereport, BIRT, etc., should work if you like their layout tool.

--
Les Mikesell
[hidden email]

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Jesse White

Re: Reporting

Reply Threaded

Thanks for the feedback. I haven't looked at the Pentaho tools, but I'll
take a peek before diving into JasperSoft.
I only need to report on events logged in the database. The KSC performance
reports do a great job for reporting
on the JRBs for the time being.

-Jesse

-----Original Message-----
From: Les Mikesell [mailto:[hidden email]]
Sent: Thursday, November 05, 2009 2:43 PM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Reporting

Jesse White wrote:

> Hi list,
>
>
>
> After spending some time reviewing different open-source monitoring
> solutions I've decided to settle on OpenNMS. To meet my organizations
> requirements, I will need to generate availability reports on all the
> devices in specific provisioning groups between any two periods of time.
> In order to do so, I was thinking I would integrate with JasperServer
> and would expand on the code-base provided in
> http://www.opennms.org/wiki/JasperServer_Integration. I would expand the
> code to allow one to pass variables to the reporting engine through the
> UI (provisioning group, start date, end date..etc). Do you guys think
> there would be a better way to do this? Are there any similar efforts in
> progress?

Have you looked at the pentaho tools? And do you need historical data
values from the jrb's or just events from the database? I've been
looking for a nicer way to do things like show trends across somewhat
dynamic groups of values - like the bandwidth across internet-facing
router interfaces or CPU use on a farm of servers which may not be the
same set over time. The pentaho scheme seems to be to extract data
into a different database for reporting and analysis rather than working
directly with the live system but so far I've been using perl scripts
against http://www.opennms.org/wiki/Data_Export to get daily snapshots
of values into a database where I can keep them tied to my grouping keys
even after the live devices change. This might be more elegant if
someone could glue jrobin into pentaho's pdi (their
extract/transform/load tool) or something like that. Once you get
things into a layout that is reasonable for reporting, any of pentaho,
jasper, jfreereport, BIRT, etc., should work if you like their layout tool.

--
Les Mikesell
[hidden email]

----------------------------------------------------------------------------
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this
page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Lance Vermilion

Re: Reporting

Reply Threaded

A true feature missing from ONMS is clearly reporting. I think if there were more canned reports many more people would be on board. Not to mention a dashboard that was a bit more useful for a NOC. A lot more Red light, green light. Something that will auto-refresh and let the know something has gone wrong. Some server or switch port has too many errors/etc on it. Top traffic talkers. Those types of things need to be readily accessible for a NOC to do their best work. You know the whole proactive thing.

On Thu, Nov 5, 2009 at 1:27 PM, Jesse White <[hidden email]> wrote:

Thanks for the feedback. I haven't looked at the Pentaho tools, but I'll
take a peek before diving into JasperSoft.
I only need to report on events logged in the database. The KSC performance
reports do a great job for reporting
on the JRBs for the time being.

-Jesse

-----Original Message-----
From: Les Mikesell [mailto:[hidden email]]
Sent: Thursday, November 05, 2009 2:43 PM
To: General OpenNMS Discussion
Subject: Re: [opennms-discuss] Reporting

Jesse White wrote:
> Hi list,
>
>
>
> After spending some time reviewing different open-source monitoring
> solutions I've decided to settle on OpenNMS. To meet my organizations
> requirements, I will need to generate availability reports on all the
> devices in specific provisioning groups between any two periods of time.
> In order to do so, I was thinking I would integrate with JasperServer
> and would expand on the code-base provided in
> http://www.opennms.org/wiki/JasperServer_Integration. I would expand the
> code to allow one to pass variables to the reporting engine through the
> UI (provisioning group, start date, end date..etc). Do you guys think
> there would be a better way to do this? Are there any similar efforts in
> progress?

Have you looked at the pentaho tools? And do you need historical data
values from the jrb's or just events from the database? I've been
looking for a nicer way to do things like show trends across somewhat
dynamic groups of values - like the bandwidth across internet-facing
router interfaces or CPU use on a farm of servers which may not be the
same set over time. The pentaho scheme seems to be to extract data
into a different database for reporting and analysis rather than working
directly with the live system but so far I've been using perl scripts
against http://www.opennms.org/wiki/Data_Export to get daily snapshots
of values into a database where I can keep them tied to my grouping keys
even after the live devices change. This might be more elegant if
someone could glue jrobin into pentaho's pdi (their
extract/transform/load tool) or something like that. Once you get
things into a layout that is reasonable for reporting, any of pentaho,
jasper, jfreereport, BIRT, etc., should work if you like their layout tool.

--
Les Mikesell
[hidden email]

----------------------------------------------------------------------------
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this
page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Les Mikesell

Re: Reporting

Reply Threaded

Lance Vermilion wrote:
> A true feature missing from ONMS is clearly reporting. I think if there
> were more canned reports many more people would be on board. Not to
> mention a dashboard that was a bit more useful for a NOC. A lot more Red
> light, green light. Something that will auto-refresh and let the know
> something has gone wrong. Some server or switch port has too many
> errors/etc on it. Top traffic talkers.

Note that there is a nightly report of top traffic interfaces.

Those types of things need to be
> readily accessible for a NOC to do their best work. You know the whole
> proactive thing.

You can do a fairly nice NOC display by building a surveillance view
grid of service/location (add categories to the nodes)and perhaps
sending notifications to a jabber group conference that shows in an IM
window. But, we have a homegrown tool for that with
application-specific probes and a much faster pool frequency. At the
moment I'm more interested in historical data collection and longer term
trends in collected values. I'd like to have a way to create more
things like the nightly bandwidth reports, but over the span of time I
want to track, individual interfaces, routers or even whole colo sites
are likely to change so I don't expect OpenNMS itself to be a good place
to track the aggregated values, so it is more a matter of having a handy
way to export snapshot values for selected items.

--
Les Mikesell
[hidden email]

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Ronny Trommer

Re: Reporting

Reply Threaded

In reply to this post by Jesse White

Some javascript/style in this post has been disabled (why?)

Hi,

i have attached the JasperServer stuff on a OpenNMS database. With the current implementation you can pass parameters like categorynames, nodeid or whatever with simple GET through your JasperServer. You can use every parameter you want, the only thing you have to do is, use it in your where clause in your SQL statements.

I have created a svn diff source patch which can be downloaded at

http://bugzilla.opennms.org/show_bug.cgi?id=2392

which make it easier to apply it on new versions of OpenNMS. I would like implement the real JasperReports API directly in the OpenNMS Webapp to make the JasperServer installation unneccessary. If someone has Java Spring knowledge to mentor me, do not hesitate and drop me a message ;)

Ronny Trommer (Germany)

Web: http://www.open-factory.org

IRC: irc.freenode.org - #opennms

PGP key: 7ED9 1A00 0BD9 EB84 9F63 5808 B1BC E829 E383 98A0

Keyserver: keyserver.pgp.com

On Nov 5, 2009, at 7:29 PM, Jesse White wrote:

Hi list,

After spending some time reviewing different open-source monitoring solutions I’ve decided to settle on OpenNMS. To meet my organizations requirements, I will need to generate availability reports on all the devices in specific provisioning groups between any two periods of time. In order to do so, I was thinking I would integrate with JasperServer and would expand on the code-base provided in http://www.opennms.org/wiki/JasperServer_Integration. I would expand the code to allow one to pass variables to the reporting engine through the UI (provisioning group, start date, end date..etc). Do you guys think there would be a better way to do this? Are there any similar efforts in progress?

Thanks,
Jesse

jonathan sartin

Re: Reporting

Reply Threaded

In reply to this post by Jesse White

Some javascript/style in this post has been disabled (why?)

On 5 Nov 2009, at 18:29, Jesse White wrote:

Hi list,

After spending some time reviewing different open-source monitoring solutions I’ve decided to settle on OpenNMS. To meet my organizations requirements, I will need to generate availability reports on all the devices in specific provisioning groups between any two periods of time. In order to do so, I was thinking I would integrate with JasperServer and would expand on the code-base provided in http://www.opennms.org/wiki/JasperServer_Integration. I would expand the code to allow one to pass variables to the reporting engine through the UI (provisioning group, start date, end date..etc). Do you guys think there would be a better way to do this? Are there any similar efforts in progress?

Hi Chaps,

we've known for quite a long time that integrating a database reporting engine into OpenNMS would be a great feature. I've blogged about it in the past, and have an active development branch to do some of the things you are proposing (feature-reportd). This does not appear on any official roadmap for the project, nor can I provide you with any timescales at the moment. Progress is occasionally reported in TWIO.

Of course, one of the huge number of great things about OpenNMS is that it _does_ have a back end database. I'd commend Ronny's work on the JasperServer integration as a good starting point.

Of course, if you need an integrated capability and you have a budget, there are people around here (other than I, OpenNMS is not my day job) who might be able to help ;-)

Cheers ... Jonathan.

Benjamin Reed

Re: Reporting

Reply Threaded

In reply to this post by Lance Vermilion

Some javascript/style in this post has been disabled (why?)

We do have an incomplete Jasper integration in a branch, but it needs some love to get up to a proper level of integration with the rest of OpenNMS.

On Nov 5, 2009, at 2:34 PM, Lance Vermilion <[hidden email]> wrote:

It would be nice to see a coupled install packaged as part of ONMS that would include JaspeSoft stuff so people could get more reporting without having to figure it all out. Oh, and it would be nice to have some base reports included in that.
On Thu, Nov 5, 2009 at 12:06 PM, <[hidden email]> wrote:
I like the thought of mashing up OpenNMS and JasperSoft or even Pentaho.

When you start looking at BSM type problem sets, these capabilities play very well together to give you alot of good capabilities.

Dougie!!!

-----Original Message-----
From: Jesse White <[hidden email]>
To: 'General OpenNMS Discussion' <[hidden email]>
Sent: Thu, Nov 5, 2009 12:29 pm
Subject: [opennms-discuss] Reporting

Hi list,

After spending some time reviewing different open-source monitoring solutions I’ve decided to settle on OpenNMS. To meet my organizations requirements, I will need to generate availability reports on all the devices in specific provisioning groups between any two periods of time. In order to do so, I was thinking I would integrate with JasperServer and would expand on the code-base provided in http://www.opennms.org/wiki/JasperServer_Integration. I would expand the code to allow one to pass variables to the reporting engine through the UI (provisioning group, start date, end date..etc). Do you guys think there would be a better way to do this? Are there any similar efforts in progress?

Thanks,

Jesse

------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july

_______________________________________________ Please read the OpenNMS Mailing List FAQ: http://www.opennms.org/index.php/Mailing_List_FAQ opennms-discuss mailing list To *unsubscribe* or change your subscription options, see the bottom of this page: https://lists.sourceforge.net/lists/listinfo/opennms-discuss

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss

Benjamin Reed

Re: Reporting

Reply Threaded

In reply to this post by Ronny Trommer

Some javascript/style in this post has been disabled (why?)

Of course, I'm working through my old emails and I *just* posted about this before reading your message... :)

I did some preliminary investigation and this looks (in theory) like it would not be much work. Unfortunately, we are so slammed with custom dev, it's way down on the priority list still.

That said, if you're willing to work on it, I'd be happy to help out with questions...

On Nov 5, 2009, at 5:24 PM, Ronny Trommer <[hidden email]> wrote:

Hi,

i have attached the JasperServer stuff on a OpenNMS database. With the current implementation you can pass parameters like categorynames, nodeid or whatever with simple GET through your JasperServer. You can use every parameter you want, the only thing you have to do is, use it in your where clause in your SQL statements.

I have created a svn diff source patch which can be downloaded at

http://bugzilla.opennms.org/show_bug.cgi?id=2392

which make it easier to apply it on new versions of OpenNMS. I would like implement the real JasperReports API directly in the OpenNMS Webapp to make the JasperServer installation unneccessary. If someone has Java Spring knowledge to mentor me, do not hesitate and drop me a message ;)

Ronny Trommer (Germany)
Web: http://www.open-factory.org
IRC: irc.freenode.org - #opennms

PGP key: 7ED9 1A00 0BD9 EB84 9F63 5808 B1BC E829 E383 98A0
Keyserver: keyserver.pgp.com

On Nov 5, 2009, at 7:29 PM, Jesse White wrote:

Hi list,

After spending some time reviewing different open-source monitoring solutions I’ve decided to settle on OpenNMS. To meet my organizations requirements, I will need to generate availability reports on all the devices in specific provisioning groups between any two periods of time. In order to do so, I was thinking I would integrate with JasperServer and would expand on the code-base provided in http://www.opennms.org/wiki/JasperServer_Integration. I would expand the code to allow one to pass variables to the reporting engine through the UI (provisioning group, start date, end date..etc). Do you guys think there would be a better way to do this? Are there any similar efforts in progress?

Thanks,
Jesse

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-discuss mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-discuss