This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Request for Collaboration to Integrate Stats from Nokia wireless with NPM

Hi,

I work with Nokia Wireless team. We are currently working on updating Stats for Nokia Wireless HW with Solarwinds NPM.

This initiative is based on a request from customer who's network is monitored using Solarwinds NPM/NMS servers.

We would like to have a closed loop private discussion on this topic.

We had one meeting with Lau, Yan Qing. In our follow up email to him, he has recommended to seek support in THWACK community.

We have completed the following

1) Installed a trial version of Solarwinds Orion package.

2) View schema of tables of interest.

3) Added a controller node for monitoring.

4) Able to view status of controller node in Orion.nodes view.

5) Wrote sample queries using SWQL to insert, update and delete from individual tables.

We solicit your collaboration to discuss specific details on the table content updation.

Discuss specifics on table updates which when populated will provide the output required by our customer.

Looking forward to hear from you.

Thanks and Regards

Lak.

  • Hi,

    Gentle Reminder. Please acknowledge the message and do the needful


    Thanks and Regards

    Lak.

  • Create a Universal Device Poller (UnDP) - SolarWinds Worldwide, LLC. Help and Support

    What you need most likely is just to build some SNMP custom pollers for whatever info you want to poll from the Nokia devices. 

  • Hi

    We are not supporting PM stats over SNMP in the current release. In our earlier conversation, with Lau, we concluded to use REST interface to update the tables directly.

    Can u share the sequence of steps we must follow for the same.

    We must add the NE under Nodes table first. Then how and in what sequence should we update the tables.

    Thanks and Regards

    Lak

  • To be honest, building a 3rd party integration into Solarwinds only through direct API edits is pretty challenging, I would say nearly impossible.  You will need to have a very deep understanding of the Solarwinds application, the database (they do not publish db information so you will basically only learn by trial and error) and not every table even allows you to create or update entries from the API so you may find limitations there where you get forced into using regular SQL editing, which carries the added risk that once you get everything worked out they could release a new version with changes to the tables that break your integration.

    If you are willing to embark on that project I don't know that you will get much support from within Thwack, it's not the kind of "question" that someone would be able to write a simple post and explain for you. If, in the course of your own work, you find a specific API verb that you are having trouble with then it is likely you could get some clarification on the expected syntax etc but questions without specific answers are not likely to get much response.

    There are consultants who you could possibly pay to collaborate with you but this would likely be a pretty complex project with a measurable risk of failure, so I know my own employer would be pretty unlikely to take it on without agreeing to some very specific terms regarding billing and such.  They tend to stay away from ambiguous things like this.

  • Thanks a lot for the elaborate explanation, risks, alternate options and potential issues with them.

    Is there a mechanism to know if direct edits are allowed using REST APIs for the following tables:

    Wireless. (Clients, AccessPoints, Controller, Interfaces and Rouge).

    Any example scripts using REST APIs to update any table will get us onboard quickly. We can employ it to try out SQL statements to update the above tables to see if we can make any progress or completely shelve the idea.

    Appreciate you sharing the background details about potential changes to database which may cause integration to fail.

    Appreciate your inputs,

    Lak.

  • If you load up swql studio there is a section called metadata, I don't recall exactly which tables in there would be the ones you need but there are lists of objects and it they have columns for create update read etc that let you know if the api will accept that kind of command for those objects.   There's also tables outlining all the verbs and their arguments

  • Thank you for the pointer. It took us one step closer to the solution. We could pull the tables and relevant columns using SWQL.

    For Orion.Wireless.AccessPoints, Orion.Wireless.Clients, Orion.Wireless.Rogue and Orion.Wireless.Controllers CanCreate, CanUpdate and CanDelete are False. CanRead is TRUE.

    Does that imply that using REST API we cannot update the above Tables?

    Thanks and Regards

    Lak.

  • That would be my understanding yes, tdanner​ might be able to confirm

  • That is correct: these tables do not support modification through the API.

    lputcha​ - have you tried reaching out to cobrien​? I think he would be interested in discussing this with you.