SNMP Informant - SQL: how do i make a snmp query from this?

[agent1994]

We bought SNMP informant (Advanced and SQL) and im trying to gather database stats from our SQL server.

In order to do this, im trying to make an SNMP query, if you use snmp walk you'll see something like this:

.enterprises.wtcs.informant.sqlServer.sqlServerDatabasesTable.sqlServerDatabasesEntry.ssdInstance.1."master" = STRING: master

The "master" between quotes is on the very OID as ASCII:

.1.3.6.1.4.1.9600.1.3.27.1.1.1.6.109.97.115.116.101.114 = STRING: master

The SNMP query i tried is:

Code: Select all

<query>
    <name>SNMP Informant - SQL - Database Stats</name>
    <description>SNMP Informant - SQL - Database Stats</description>
    <oid_index>.1.3.6.1.4.1.9600.1.3.27.1.1.1</oid_index>
        <fields>
            <ssdInstance>
                <name>Database</name>
                <method>walk</method>
                <source>value</source>
                <direction>input</direction>
                <oid>.1.3.6.1.4.1.9600.1.3.27.1.1.1</oid>
            </ssdInstance>
        </fields>
        <fields>
            <ssdActiveTransactions>
                <name>Active Transactions</name>
                <method>walk</method>
                <source>value</source>
                <direction>output</direction>
                <oid>.1.3.6.1.4.1.9600.1.3.27.1.2.1</oid>
            </ssdActiveTransactions>
        </fields>
        <fields>
            <ssdLogFileSSizeKB>
                <name>Log File Size (KB)</name>
                <method>walk</method>
                <source>value</source>
                <direction>output</direction>
                <oid>.1.3.6.1.4.1.9600.1.3.27.1.11.1</oid>
            </ssdLogFileSSizeKB>
        </fields>
        <fields>
            <ssdLogFileSUsedSizeKB>
                <name>Log File Used (KB)</name>
                <method>walk</method>
                <source>value</source>
                <direction>output</direction>
                <oid>.1.3.6.1.4.1.9600.1.3.27.1.12.1</oid>
            </ssdLogFileSUsedSizeKB>
        </fields>
        <fields>
            <ssdTransactionsPerSec>
                <name>Transactions per second</name>
                <method>walk</method>
                <source>value</source>
                <direction>output</direction>
                <oid>.1.3.6.1.4.1.9600.1.3.27.1.32.1</oid>
            </ssdTransactionsPerSec>
        </fields>
</query>

And of course it doesnt work. All i get is this when i try the query in verbose mode:

+ Running data query [12].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/usr/share/cacti/resource/snmp_queries/BCR_snmpi-sql_ssd.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.4.1.9600.1.3.27.1.1.1'

I already read the manual but im unable to find what's wrong. Any clues will be appreciated.

Thanks in advance.

[agent1994]

Update: these numbers appears to be the lenght of the string embedded in the OID, ie:

.1.3.6.1.4.1.9600.1.3.27.1.1.1.4.109.115.100.98 = STRING: msdb
.1.3.6.1.4.1.9600.1.3.27.1.1.1.6.116.101.109.112.100.98 = STRING: tempdb
.1.3.6.1.4.1.9600.1.3.27.1.1.1.5.109.111.100.101.108 = STRING: model