Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Database Reports -> Provide Examples for Resource Query Data

Description

One of the requirements for a Jasper report is to report on the disk space used on monitored nodes, but I can't find any detailed explanation or examples on how to use the resourceQuery language in a dataset query string.

For example I'm trying to get the results of this queryString:

--rrdDir /opt/opennms/share/rrd/snmp/ --nodeid XX --resourceType dskIndex --string ns-dskPath

After running this the documentation only states that "To get the fields provider to work you will need to install the resource query fields provider jar"

Can someone please provide an example on how it would look in the jrxml for this report?

Acceptance / Success Criteria

None

Lucidchart Diagrams

Activity

Show:

Corey Hammerton March 18, 2015 at 11:01 AM

I added a Query Executor statement to the options with the following settings:

Name: resourceQuery
Factory: org.opennms.netmgt.jasper.resource.ResourcequeryExecutorFactory
Fields Provider: org.opennms.netmgt.jasper.resource.ResourceQueryFieldsProvider

Also added this executor to the RRD data:

Name: jrobin
Factory: org.opennms.netmgt.jasper.resource.JRobinQueryExecutorFactory

The fields provider jar is bundled with either the jasper-extensions or org.opennms.core-lib jar that is packaged with OpenNMS.

Reports that require the use of the resource query and RRD results should now work.

Corey Hammerton June 19, 2014 at 1:31 PM

Resolved, I figured out the fields that are being collected from this type.

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

PagerDuty

Created June 17, 2014 at 1:46 PM
Updated February 14, 2018 at 10:00 PM
Resolved June 19, 2014 at 1:31 PM