<sampler name="gwsql_lastrow">
    <sampleInterval>
        <data>20</data>
    </sampleInterval>
    <plugin>
        <Gateway-sql>
            <tables>
                <dataview>
                    <tableName>
                        <data>toolkit</data>
                    </tableName>
                    <xpath>/geneos/gateway[(@name=&quot;Primary Gateway&quot;)]/directory/probe[(@name=&quot;1_probe&quot;)]/managedEntity[(@name=&quot;Main&quot;)]/sampler[(@name=&quot;Toolkit_for_gateway_sql&quot;)][(@type=&quot;&quot;)]/dataview[(@name=&quot;Toolkit_for_gateway_sql&quot;)]</xpath>
                    <columns>
                        <column>
                            <name>
                                <data>name</data>
                            </name>
                            <type>TEXT</type>
                        </column>
                        <column>
                            <name>
                                <data>Value</data>
                            </name>
                            <type>INTEGER</type>
                        </column>
                        <column>
                            <name>
                                <data>id</data>
                            </name>
                            <type>INTEGER</type>
                        </column>
                    </columns>
                </dataview>
            </tables>
            <views>
                <view>
                    <name>
                        <data>last_row</data>
                    </name>
                    <sql>
                        <data>SELECT * FROM toolkit ORDER BY id DESC LIMIT 1;</data>
                    </sql>
                    <showRowID>true</showRowID>
                </view>
            </views>
        </Gateway-sql>
    </plugin>
</sampler>