Simple IP Inventory report created
authorAlex Kirhenshtein <alk@netxms.org>
Mon, 3 Oct 2011 13:37:04 +0000 (13:37 +0000)
committerAlex Kirhenshtein <alk@netxms.org>
Mon, 3 Oct 2011 13:37:04 +0000 (13:37 +0000)
.gitattributes
reports/IP Inventory.jrxml [new file with mode: 0644]

index 5a03689..f6375c0 100644 (file)
@@ -105,6 +105,7 @@ images/f9105c54-8dcf-483a-b387-b4587dfd3cba -text
 include/netxms_isc.h -text
 include/nxdbapi.h -text
 include/nxlpapi.h -text
+reports/IP[!!-~]Inventory.jrxml -text
 sdk/install/netxms-sdk.iss -text
 sdk/openssl/lib/x64/libeay32.lib -text
 sdk/openssl/lib/x64/ssleay32.lib -text
diff --git a/reports/IP Inventory.jrxml b/reports/IP Inventory.jrxml
new file mode 100644 (file)
index 0000000..4bf131e
--- /dev/null
@@ -0,0 +1,78 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="IP Inventory" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
+       <property name="ireport.zoom" value="1.0"/>
+       <property name="ireport.x" value="0"/>
+       <property name="ireport.y" value="0"/>
+       <queryString language="SQL">
+               <![CDATA[SELECT
+     interfaces.ip_addr AS interfaces_ip_addr,
+     interfaces.ip_netmask AS interfaces_ip_netmask,
+     object_properties.name AS object_properties_name,
+     interfaces.node_id AS interfaces_node_id
+FROM
+     object_properties
+INNER JOIN
+       interfaces
+ON
+       object_properties.object_id = interfaces.node_id
+ORDER BY
+       interfaces_node_id, interfaces_ip_addr]]>
+       </queryString>
+       <field name="interfaces_ip_addr" class="java.lang.String"/>
+       <field name="interfaces_ip_netmask" class="java.lang.String"/>
+       <field name="object_properties_name" class="java.lang.String"/>
+       <field name="interfaces_node_id" class="java.lang.Integer"/>
+       <group name="interfaces_node_id">
+               <groupExpression><![CDATA[$F{interfaces_node_id}]]></groupExpression>
+               <groupHeader>
+                       <band height="20">
+                               <textField>
+                                       <reportElement x="0" y="0" width="555" height="20"/>
+                                       <textElement>
+                                               <font size="14" isBold="true"/>
+                                       </textElement>
+                                       <textFieldExpression><![CDATA[$F{object_properties_name}]]></textFieldExpression>
+                               </textField>
+                       </band>
+               </groupHeader>
+       </group>
+       <background>
+               <band splitType="Stretch"/>
+       </background>
+       <detail>
+               <band height="20" splitType="Stretch">
+                       <textField>
+                               <reportElement x="20" y="0" width="143" height="20"/>
+                               <textElement/>
+                               <textFieldExpression><![CDATA[$F{interfaces_ip_addr}]]></textFieldExpression>
+                       </textField>
+                       <textField>
+                               <reportElement x="163" y="0" width="143" height="20"/>
+                               <textElement/>
+                               <textFieldExpression><![CDATA[$F{interfaces_ip_netmask}]]></textFieldExpression>
+                       </textField>
+               </band>
+       </detail>
+       <pageFooter>
+               <band height="21">
+                       <line>
+                               <reportElement x="0" y="0" width="555" height="1"/>
+                       </line>
+                       <textField pattern="dd/MM/yyyy HH:mm:ss">
+                               <reportElement positionType="FixRelativeToBottom" x="0" y="1" width="100" height="20"/>
+                               <textElement/>
+                               <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
+                       </textField>
+                       <textField>
+                               <reportElement positionType="FixRelativeToBottom" x="435" y="1" width="80" height="20"/>
+                               <textElement textAlignment="Right"/>
+                               <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
+                       </textField>
+                       <textField evaluationTime="Report">
+                               <reportElement positionType="FixRelativeToBottom" x="515" y="1" width="40" height="20"/>
+                               <textElement/>
+                               <textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
+                       </textField>
+               </band>
+       </pageFooter>
+</jasperReport>