
<sampler name="Gwy-sql-TableCellsPerDataview">
	<description/>
	<sampleInterval>
		<data>0</data>
	</sampleInterval>
	<sampleOnStartup>false</sampleOnStartup>
	<plugin>
		<Gateway-sql>
			<tables>
				<xpath>
					<tableName>
						<data>TableCells</data>
					</tableName>
					<xpaths>
						<xpath>/geneos/gateway/directory/probe/managedEntity/sampler/dataview/rows/row/cell</xpath>
					</xpaths>
					<columns>
						<column>
							<name>
								<data>Probe</data>
							</name>
							<xpath>ancestor::probe</xpath>
							<type>TEXT</type>
						</column>
						<column>
							<name>
								<data>Virtual</data>
							</name>
							<xpath>ancestor::probe/parameters/@Virtual</xpath>
							<type>TEXT</type>
						</column>
						<column>
							<name>
								<data>Imported</data>
							</name>
							<xpath>ancestor::probe/parameters/@Imported</xpath>
							<type>TEXT</type>
						</column>
						<column>
							<name>
								<data>ME</data>
							</name>
							<xpath>ancestor::managedEntity</xpath>
							<type>TEXT</type>
						</column>
						<column>
							<name>
								<data>Sampler</data>
							</name>
							<xpath>ancestor::sampler</xpath>
							<type>TEXT</type>
						</column>
						<column>
							<name>
								<data>Dataview</data>
							</name>
							<xpath>ancestor::dataview/@name</xpath>
							<type>TEXT</type>
						</column>
					</columns>
				</xpath>
			</tables>
			<views>
				<view>
					<name>
						<data>TableCellsPerDataview</data>
					</name>
					<sql>
						<data>select *, count(*) as Cells from TableCells group by ME, Dataview</data>
					</sql>
					<showRowID>true</showRowID>
				</view>
			</views>
		</Gateway-sql>
	</plugin>
</sampler>