<?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="Registered Users" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="535" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenResourceMissingType="Key">
	<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 value="net.sf.jasperreports.engine.*"/>
	<import value="java.util.*"/>
	<import value="net.sf.jasperreports.engine.data.*"/>
	<queryString>
		<![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]]>
	</queryString>
	<field name="nbs_uuid" class="java.lang.String"/>
	<field name="nbs_name" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="44" splitType="Stretch">
			<image>
				<reportElement key="image-1" x="374" y="0" width="150" height="35"/>
				<imageExpression class="java.lang.String"><![CDATA["http://localhost:8080/openkm/logo/report"]]></imageExpression>
			</image>
			<textField pattern="yyyy/MM/dd" isBlankWhenNull="false">
				<reportElement key="textField-13" x="0" y="0" width="65" height="10" forecolor="#010101"/>
				<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>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" size="8" isBold="true" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
			</textField>
			<textField pattern="h.mm.ss a" isBlankWhenNull="false">
				<reportElement key="textField-14" x="0" y="10" width="65" height="10" forecolor="#010101"/>
				<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>
				<textElement verticalAlignment="Middle">
					<font fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" size="8" isBold="true" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
			</textField>
			<line>
				<reportElement key="line-3" x="-15" y="42" width="562" height="1" forecolor="#010101"/>
				<graphicElement fill="Solid"/>
			</line>
			<staticText>
				<reportElement x="77" y="0" width="297" height="44"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" size="22" isBold="true" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Duplicated files]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="30" splitType="Stretch">
			<line>
				<reportElement key="line-4" x="0" y="28" width="140" height="1" forecolor="#010101"/>
			</line>
			<line>
				<reportElement key="line-5" x="145" y="28" width="390" height="1" forecolor="#010101"/>
			</line>
			<staticText>
				<reportElement x="0" y="12" width="127" height="14"/>
				<textElement>
					<font fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" isBold="true" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[UUID]]></text>
			</staticText>
			<staticText>
				<reportElement x="155" y="12" width="380" height="14"/>
				<textElement>
					<font fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H" isBold="true" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Name]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="18" splitType="Stretch">
			<textField isBlankWhenNull="false">
				<reportElement key="textField" x="0" y="0" width="127" height="18"/>
				<textElement>
					<font fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{nbs_uuid}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" x="155" y="0" width="380" height="18"/>
				<textElement>
					<font fontName="Arial" pdfFontName="unicode.ttf" pdfEncoding="Identity-H"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{nbs_name}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="30" splitType="Stretch">
			<line>
				<reportElement key="line-2" x="-15" y="4" width="567" height="1" forecolor="#010101" backcolor="#FFFFFF"/>
				<graphicElement fill="Solid"/>
			</line>
		</band>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
