<!-- Created with Jaspersoft Studio version 7.0.3.final using JasperReports Library version 7.0.3-41034ca841d452f3305ba55b9042260aaa1ab5dd  -->
<jasperReport name="Registered Users" language="java" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="535" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenResourceMissingType="Key" uuid="397d32ab-34b1-4e17-b600-366d750335cb">
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<import>net.sf.jasperreports.engine.*</import>
	<import>java.util.*</import>
	<import>net.sf.jasperreports.engine.data.*</import>
	<query language="sql"><![CDATA[SELECT NB.NBS_UUID, NB.NBS_NAME
FROM OKM_NODE_BASE NB, OKM_NODE_DOCUMENT ND, OKM_NODE_VERSION NV
WHERE NB.NBS_UUID=ND.NBS_UUID AND ND.NBS_UUID=NV.NV_PARENT
AND NV.NV_CHECKSUM IN (
  SELECT NV_CHECKSUM FROM OKM_NODE_VERSION GROUP BY NV_CHECKSUM HAVING COUNT(NV_CHECKSUM) > 1
)
ORDER BY NV.NV_CHECKSUM, NB.NBS_NAME]]></query>
	<field name="nbs_uuid" class="java.lang.String"/>
	<field name="nbs_name" class="java.lang.String"/>
	<background splitType="Stretch"/>
	<title height="44" splitType="Stretch">
		<element kind="image" uuid="29d8860e-4136-461a-9ad4-362bf2de564d" key="image-1" x="374" y="0" width="150" height="35">
			<expression><![CDATA["http://localhost:8080/openkm/logo/report"]]></expression>
		</element>
		<element kind="textField" uuid="2b74964c-5ebb-4d8a-8d3e-e48c4edb1f29" key="textField-13" x="0" y="0" width="65" height="10" forecolor="#010101" fontName="Arial" fontSize="8.0" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" pattern="yyyy/MM/dd" blankWhenNull="false" underline="false" bold="true" vTextAlign="Middle">
			<expression><![CDATA[new Date()]]></expression>
			<box>
				<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="0.0" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
		</element>
		<element kind="textField" uuid="32c7ef5c-8e6a-4dc4-b1a0-9ee768fc6daf" key="textField-14" x="0" y="10" width="65" height="10" forecolor="#010101" fontName="Arial" fontSize="8.0" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" pattern="h.mm.ss a" blankWhenNull="false" underline="false" bold="true" vTextAlign="Middle">
			<expression><![CDATA[new Date()]]></expression>
			<box>
				<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				<bottomPen lineWidth="0.0" lineColor="#000000"/>
				<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
			</box>
		</element>
		<element kind="line" uuid="20e4dbcc-f011-44cf-a660-6d61fb1c61ca" key="line-3" x="-15" y="42" width="562" height="1" forecolor="#010101"/>
		<element kind="staticText" uuid="39458349-009a-4174-92fb-b29664fb3b2c" x="77" y="0" width="297" height="44" fontName="Arial" fontSize="22.0" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" bold="true" pdfEmbedded="false" hTextAlign="Center" vTextAlign="Middle">
			<text><![CDATA[Duplicated files]]></text>
		</element>
	</title>
	<pageHeader splitType="Stretch"/>
	<columnHeader height="30" splitType="Stretch">
		<element kind="line" uuid="871f3b0e-4aac-470a-89da-4230c08c6bc7" key="line-4" x="0" y="28" width="140" height="1" forecolor="#010101"/>
		<element kind="line" uuid="72e1c68c-04dd-4ab3-9f35-45d2bd58a2cc" key="line-5" x="145" y="28" width="390" height="1" forecolor="#010101"/>
		<element kind="staticText" uuid="ca1bb707-7e6c-4bd7-a05b-ac6be8eb2793" x="0" y="12" width="127" height="14" fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" bold="true" pdfEmbedded="false">
			<text><![CDATA[UUID]]></text>
		</element>
		<element kind="staticText" uuid="ef613d61-5413-49e6-820b-7a2985a89d50" x="155" y="12" width="380" height="14" fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" bold="true" pdfEmbedded="false">
			<text><![CDATA[Name]]></text>
		</element>
	</columnHeader>
	<detail>
		<band height="18" splitType="Stretch">
			<element kind="textField" uuid="3a54eb8a-e5ba-4b0e-9775-36e8426b455b" key="textField" x="0" y="0" width="127" height="18" fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" blankWhenNull="false">
				<expression><![CDATA[$F{nbs_uuid}]]></expression>
			</element>
			<element kind="textField" uuid="f905898f-09cd-43c1-8c2d-a3344d71f621" key="textField" x="155" y="0" width="380" height="18" fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" blankWhenNull="false">
				<expression><![CDATA[$F{nbs_name}]]></expression>
			</element>
		</band>
	</detail>
	<columnFooter splitType="Stretch"/>
	<pageFooter height="30" splitType="Stretch">
		<element kind="line" uuid="373b2c15-b25c-4e97-9435-445743514ca5" key="line-2" x="-15" y="4" width="567" height="1" forecolor="#010101" backcolor="#FFFFFF"/>
	</pageFooter>
	<summary splitType="Stretch"/>
</jasperReport>
