<!-- Created with Jaspersoft Studio version 7.0.3.final using JasperReports Library version 7.0.3-41034ca841d452f3305ba55b9042260aaa1ab5dd  -->
<jasperReport name="Blank_A4" language="java" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="aa86a89f-696b-47cd-ae18-d92d9dd880b0">
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Netxms"/>
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<query language="sql"><![CDATA[SELECT
    n.primary_name,
    n.primary_ip,
    i.node_id,
    i.mac_addr,
    ial.ip_addr,
    i.description
FROM interfaces i
JOIN nodes n 
    ON i.node_id = n.id
JOIN interface_address_list ial
    ON ial.iface_id = i.id
WHERE i.description = 'WAN';]]></query>
	<field name="primary_name" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="primary_name"/>
		<property name="com.jaspersoft.studio.field.label" value="primary_name"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="nodes"/>
	</field>
	<field name="primary_ip" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="primary_ip"/>
		<property name="com.jaspersoft.studio.field.label" value="primary_ip"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="nodes"/>
	</field>
	<field name="node_id" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="node_id"/>
		<property name="com.jaspersoft.studio.field.label" value="node_id"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="interfaces"/>
	</field>
	<field name="mac_addr" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="mac_addr"/>
		<property name="com.jaspersoft.studio.field.label" value="mac_addr"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="interfaces"/>
	</field>
	<field name="ip_addr" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="ip_addr"/>
		<property name="com.jaspersoft.studio.field.label" value="ip_addr"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="interface_address_list"/>
	</field>
	<field name="description" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="description"/>
		<property name="com.jaspersoft.studio.field.label" value="description"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="interfaces"/>
	</field>
	<background splitType="Stretch"/>
	<title height="79" splitType="Stretch">
		<element kind="staticText" uuid="6f8edf5f-02ab-4217-937b-e67a88005169" x="180" y="10" width="501" height="61" fontSize="22.0" hTextAlign="Center" vTextAlign="Middle">
			<text><![CDATA[Обнаруженные машины с WAN интерфейсом]]></text>
		</element>
	</title>
	<pageHeader height="12" splitType="Stretch"/>
	<columnHeader height="35" splitType="Stretch">
		<element kind="staticText" uuid="f6f960fb-ba08-433c-9f84-f9b746afe71b" x="0" y="0" width="137" height="30">
			<text><![CDATA[primary_name]]></text>
			<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6e667b0a-8e52-47b3-bf11-5bce5bdf2da0"/>
		</element>
		<element kind="staticText" uuid="fe68c1ed-4b31-4161-9c19-6e9c059ff812" x="137" y="0" width="133" height="30">
			<text><![CDATA[primary_ip]]></text>
			<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="cb7b26df-4f8c-490c-87c6-49979e21dfd2"/>
		</element>
		<element kind="staticText" uuid="0b6c96b2-acb6-4c38-8284-bf7e73ae0cfb" x="270" y="0" width="133" height="30">
			<text><![CDATA[node_id]]></text>
			<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3e6964a3-78ee-40e2-b189-69c0e7ba4c33"/>
		</element>
		<element kind="staticText" uuid="6baccd0d-1640-4f85-9332-303ce6ce5b21" x="403" y="0" width="133" height="30">
			<text><![CDATA[mac_addr]]></text>
			<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="14008653-f290-4a94-9d29-22fdc2baf3e7"/>
		</element>
		<element kind="staticText" uuid="7208d134-8132-4eef-8af2-25f22aea5adc" x="536" y="0" width="133" height="30">
			<text><![CDATA[ip_addr]]></text>
			<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="b113f899-2ab1-47ce-a3b9-1de9859d17e2"/>
		</element>
		<element kind="staticText" uuid="1dc926df-f012-413e-b30e-35b4f7edbcdd" x="669" y="0" width="133" height="30">
			<text><![CDATA[description]]></text>
			<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e47870e8-6751-4a18-a7fd-aec3d48a82e3"/>
		</element>
	</columnHeader>
	<detail>
		<band height="34" splitType="Stretch">
			<element kind="textField" uuid="a2f76970-f982-419b-a48b-11c8e35cba4b" x="0" y="0" width="137" height="30">
				<expression><![CDATA[$F{primary_name}]]></expression>
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6e667b0a-8e52-47b3-bf11-5bce5bdf2da0"/>
			</element>
			<element kind="textField" uuid="1ce03248-aa0c-4865-84c3-8c1ab698c0b6" x="137" y="0" width="133" height="30">
				<expression><![CDATA[$F{primary_ip}]]></expression>
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="cb7b26df-4f8c-490c-87c6-49979e21dfd2"/>
			</element>
			<element kind="textField" uuid="dd07ad83-f4a2-4ace-bb01-40284ac47593" x="270" y="0" width="133" height="30">
				<expression><![CDATA[$F{node_id}]]></expression>
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3e6964a3-78ee-40e2-b189-69c0e7ba4c33"/>
			</element>
			<element kind="textField" uuid="305a827a-c318-4033-8d06-6e093c320424" x="403" y="0" width="133" height="30">
				<expression><![CDATA[$F{mac_addr}]]></expression>
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="14008653-f290-4a94-9d29-22fdc2baf3e7"/>
			</element>
			<element kind="textField" uuid="4539a69c-5afc-4da9-a3ce-2e8e0d68b2e1" x="536" y="0" width="133" height="30">
				<expression><![CDATA[$F{ip_addr}]]></expression>
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="b113f899-2ab1-47ce-a3b9-1de9859d17e2"/>
			</element>
			<element kind="textField" uuid="109a714e-954a-4f30-85a3-d06a79712177" x="669" y="0" width="133" height="30">
				<expression><![CDATA[$F{description}]]></expression>
				<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e47870e8-6751-4a18-a7fd-aec3d48a82e3"/>
			</element>
		</band>
	</detail>
	<columnFooter height="45" splitType="Stretch"/>
	<pageFooter height="54" splitType="Stretch"/>
	<summary height="42" splitType="Stretch"/>
</jasperReport>
