Alcatel-Lucent 7750 "sap qos queue" XML file

[franckcalleja]

Hello,

l'm trying to setup a new xml file for gathering SNMP stats for an Alcatel-Lucent 7750 router.
The MIB i'm interesting in is structured as follow :

- 3 distincts tables : SvcBaseInfo, SapBaseInfo, SapIngQosQueueStats.
- I want to graph 2 OID from the last table SapIngQosQueueStats, but to present correctly the different data to the operator, so that he can make a good selection (which service, sap and queue) to graph, I need to present data coming from other tables.

Here are a summary of the table structure :

Table SvcbaseInfo :

• SvcId (index) : .1.3.6.1.4.1.6527.3.1.2.4.2.2.1.1
• SvcType : .1.3.6.1.4.1.6527.3.1.2.4.2.2.1.3
• SvcDescription : .1.3.6.1.4.1.6527.3.1.2.4.2.2.1.6
• The IndexValue for this table is field : SvcId

Table SapBaseInfo :

• SapPortId (index) : .1.3.6.1.4.1.6527.3.1.2.4.3.2.1.1
• SapEncapValue (index) : .1.3.6.1.4.1.6527.3.1.2.4.3.2.1.2
• SapDescription : .1.3.6.1.4.1.6527.3.1.2.4.3.2.1.5
• The IndexValue for this table is field : SvcId.SapPortId.SapEncapValue

Table sapIngQosQueueStats :

• sapIngQosQueueId (index) : .1.3.6.1.4.1.6527.3.1.2.4.3.7.1.1
• sapIngQosQueueStatsOfferedHiPrioOctets : .1.3.6.1.4.1.6527.3.1.2.4.3.7.1.6
• sapIngQosQueueStatsOfferedLoPrioOctets : .1.3.6.1.4.1.6527.3.1.2.4.3.7.1.8
• The IndexValue for this table is field : SvcId.SapPortId.SapEncapValue.SapIngQosQueueId

As you can see, the index value of the Table I'm interested in is made of fields coming from others table.

I would like to present the following table to the operator, with a complete list of sapIngQosQueueStats entries

| svcId | svcType | svcDescription | SapPortId | sapEncapValue | sapDescription | sapIngQosQueueId |


And when the operator select a line in it, it will give him a graph of sapIngQosQueueStatsOfferedHiPrioOctets and sapIngQosQueueStatsOfferedLoPrioOctets related to the selected object.


Based on others post, I've imagined the following xml file, but I'm not sure I've fully understand how it works. I do not have any OID that counts the number of index in the table sapIngQosQueueStats, so I've put # sign.

Any help would be appreciated.

Thanks
Franck.

Code: Select all

<interface>
        <name>Alcatel SAP QoS Statistics</name>
        <description>Queries list of SAP's Svc monitorable queues</description>
        <oid_index>.1.3.6.1.4.1.6527.3.1.2.4.3.7.1.1</oid_index>
        <oid_num_indexes>##########????</oid_num_indexes>
        <oid_index_parse>OID/REGEXP:^.{33}(.*)</oid_index_parse> 
        <index_order>AlcatelIndex:ifName:ifPolicy</index_order>
        <index_order_type>numeric</index_order_type>
        <index_title_format>|chosen_order_field|</index_title_format>
        <fields>
                <QosQueueIndex>
                        <name>Service index</name>
                        <source>index</source>
                        <direction>input</direction>
                </QosQueueIndex>
                <sapEgrQosQueueId>                                                                                              
                        <name>Interface Name</name>                                                                    
                        <method>walk</method>                                                                         
                        <source>value</source>                                                                        
                        <direction>input</direction>                                                                  
                        <oid>.1.3.6.1.4.1.6527.3.1.2.4.3.8.1.1</oid>
                </sapEgrQosQueueId>
                <svcId>                                                                                              
                        <name>Service Id</name>                                                                    
                        <method>walk</method>                                                                         
                        <source>value</source>                                                                        
                        <direction>input</direction>                                                                  
                        <oid>.1.3.6.1.4.1.6527.3.1.2.4.2.2.1.1</oid>
                </svcId>
                <SvcType>                                                                                              
                        <name>Service Type</name>                                                                    
                        <method>walk</method>                                                                         
                        <source>value</source>                                                                        
                        <direction>input</direction>                                                                  
                        <oid>.1.3.6.1.4.1.6527.3.1.2.4.2.2.1.3</oid>
                </SvcType>
                <SvcDescription>
                        <name>SvcDescription</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.6527.3.1.2.4.2.2.1.6</oid>
                </SvcDescription>
                <SapPortId>
                        <name>SapPortId</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.6527.3.1.2.4.3.2.1.1</oid>
                </SapPortId>
                <SapEncapValue>
                        <name>SapEncapValue</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.6527.3.1.2.4.3.2.1.2</oid>
                </SapEncapValue>
                <SapDescription>
                        <name>SapDescription</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>input</direction>
                        <oid>.1.3.6.1.4.1.6527.3.1.2.4.3.2.1.5</oid>
                </SapDescription>
                <sapIngQosQueueStatsOfferedHiPrioOctets>
                        <name>sapIngQosQueueStatsOfferedHiPrioOctets</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>output</direction>
                        <oid>.1.3.6.1.4.1.6527.3.1.2.4.3.7.1.6</oid>
                </sapIngQosQueueStatsOfferedHiPrioOctets>
                <sapIngQosQueueStatsOfferedLoPrioOctets>
                        <name>sapIngQosQueueStatsOfferedLoPrioOctets</name>
                        <method>walk</method>
                        <source>value</source>
                        <direction>output</direction>
                        <oid>.1.3.6.1.4.1.6527.3.1.2.4.3.7.1.8</oid>
                </sapIngQosQueueStatsOfferedLoPrioOctets>
        </fields>
</interface>

[gandalf]

As you need to combine data from different tables using DIFFERENT INDEXES, this can't be solved by the current pure SNMP Data Query. This only accepts a single index (the index may consist of multiple numbers, but it must be a single index).

So the approach would be to create a Script Data Query. You then may query whichever tables you need, construct a complex index based on whichever base indexes you want and at last go to the table you really want to graph using that complex index. Well, in your case this is really a complex task as you need to query three different tables and need to join 4 different index fields.

Find some starting hints at 1st link of my sig; there's a bried introduction for creating custom Script Data Queries
R.

[franckcalleja]

Hi gandalf,

Thanks for that reply.
I'll take a look at script data query.

But question just raised in my mind : would this script be run just once, at graph creation, to present the data clearly to the operator, and then spine will do the data collection every period as usual using direct SNMP OID ?

In fact I have several 7750 routers, having dozen of service, having themselves several interface (sap) and each having several QOS? I would like to be sure that normal data collection will not be impacted by using a script instead of a traditionnal SNMP data query ?

Franck.

[gandalf]

You hit it right and square.
1. A script query fetching a single OID is way less efficient than a pure SNMP query (you will have to start the PHP environment or perl in case you prefer that or whatever programming language you like)
2. Due to the precessing scheme used by Cacti, at least for a re-index operation (e.g. the first time you associate the query to a target) the script will scan those tables. Depending on the script and the caching mechanisms you may want to use, this occurs once per table (e.g. powerful caching in place) or, when coded starightforward, will scan each table once for each target OID.

I don't say that it would NOT be possible to implement sth. like an SNMP index recombination feature into the pure SNMP XML. But it's simply not yet available and would take longer than an afternoon

R.

[harmen]

Hey franckcalleja,

If you have found a solution to this issue please can you provide some details ?

Thanks in Advance.

[gandalf]

In case you combine the indexes into a single, 3 level index, all is fine. There's a second thread covering the Alcatel SAP stuff; and that one features a solution, AFAIK
R.

[harmen]

After some tests I am now successfully drawing sap drop statistics, as well as per sap traffic for vpls for Alcatel Lucent 7750. As gandalf said, I combined 3 indexes,
and used Alcatel Lucent Sap Descriptions to differentiate different saps. Uploading my xml for this stuff in case anyone needs. Thanks.

[gandalf]

Thy for your effort and for publishing.
But it would be better to publish on the Scripts and Templates Forum and/or at 4th link of my sig
R.

[dttung]

Dear harmen ;
Could you share your template to view sap statisctic with me
My email : tungtel@gmail.com

[harmen]

You can download from the link above.

[dttung]

Thanks harmen for reply me .
Could you add my Yahoo ID : tungtel
I have some problem with SAP monitoring that I need your help .
Please !

[dttung]

Hi alll ;
Now I can monitor BW on SAP for VPLS and VPRN services. It 's really interesting but anyone could tell me how to manage cacti database . Because cacti database is increased day by day , when it 's too large . How can I delete or make it smaller .

Thanks

[SammyKim]

Hello Guys. I know it's been forever since there was any comment on this conversation, but kindly allow me to resurrect this topic. For some reason, the importation of Harmen's xml file into my cacti is unsucessful. Have you ever encountered this issue? Any help? Thanks...