
<sampler name="Gwy-sql-SampleInterval">
	<description/>
	<sampleInterval>
		<data>0</data>
	</sampleInterval>
	<sampleOnStartup>false</sampleOnStartup>
	<plugin>
		<Gateway-sql>
			<tables>
				<xpath>
					<tableName>
						<data>sampler</data>
					</tableName>
					<xpaths>
						<xpath>/geneos/gateway/directory/probe/managedEntity/sampler</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>@name</xpath>
							<type>TEXT</type>
						</column>
						<column>
							<name>
								<data>SampleInterval</data>
							</name>
							<xpath>descendant-or-self::parameters/@SampleInterval</xpath>
							<type>TEXT</type>
						</column>
					</columns>
				</xpath>
			</tables>
			<views>
				<view>
					<name>
						<data>Sample Interval</data>
					</name>
					<sql>
						<data>select * from sampler order by Probe</data>
					</sql>
					<showRowID>true</showRowID>
				</view>
			</views>
		</Gateway-sql>
	</plugin>
</sampler>