15 Replies Latest reply on Jun 5, 2012 4:48 PM by Wael Hilal

    Solarwinds API

    Wael Hilal

      Hi

      i had looked at the documentation on SDK but could not find Solarwinds API that are needed to communicated between solarwinds IPSLA and portal server that reads from it??

        • Re: Solarwinds API
          tom.rybka

          Hi,

           

          You can send SWQL queries against Orion.IpSla.* entity types to SolarWinds Information Service, very similar way you would do with SQL queries. You can access IPSLA operation instance information as well as statistics data collected for every operation.

           

          In order to access SWIS, you need to use a client in a custom script or an application that will send required SWQL queries and transform the information into a form which your portal server is capable to consume. How to write such scripts or client code, you can take an inspiration from samples provided in SDK (VB, Java, Perl), you can also use PowerShell commandlets provided by a snapin available in SDK, eventually you can use C# as well.

           

          Could you be please more specific what use case you wish to cover?

            • Re: Solarwinds API
              Wael Hilal

              Hi

              Actually what we need is to put a portal server that customers will access via web and each customer will get an account to monitor IP SLA reports, this server has to communicate with Solarwinds server. And we need to know the API needed for the portal server to talk with Solarwinds.

               

               

              Regards\

                • Re: Solarwinds API
                  tom.rybka

                  Do you plan to have your portal server render the reports for your customers, based on data collected by Orion and queried using its API? Or do you intend to provide your customers with an access to Orion native reports? Also, please try to be more specific in description of how the portal server "has to communicate with Solarwinds server" - I am trying to identify what API you are looking for on the Orion side.

                    • Re: Solarwinds API
                      Wael Hilal

                      Hi

                       

                      Actually what we want is to have a dedicated server as portal, this portal will collect data for Orion Solarwinds server, the data we want to collect is related to IP SLA statistics, Delay, Jitter, link status, packet loss!!

                      Also if you have passed with cases like ours to get IP SLA statistics for portal server dedicated for our customers.

                       

                      Regards

                        • Re: Solarwinds API
                          Wael Hilal

                          Hi

                          Can anybody help in this regard??

                           

                          Thanks

                            • Re: Solarwinds API
                              Wael Hilal

                              Hi Tom

                              can you help in this regard??

                               

                               

                              Thanks

                               

                              regards

                                • Re: Solarwinds API
                                  michal.hrncirik

                                  Hi Wael Hilal,

                                   

                                  if I understand that correctly, you basically want to display data from SolarWinds IPSLA on your custom "portal server". Correct? If so, then you would like to do that because of policy restrictions of because of different content of the data you have on such "portal server". I'd like to understand what problem are you trying to resolve and why to be able to help you.

                                   

                                  thanks,


                                  Michal

                                    • Re: Solarwinds API
                                      Wael Hilal

                                      Hi many thanks for your reply.

                                      The problem is that we want the API from Solarwinds or if you have passed through this, the API that I can use to retrieve the IP SLA statistics for customers from this portal server.

                                      So this portal will be used by our customers to get statistics on their lines from Solarwinds server regarding IP SLA statistics.

                                       

                                       

                                      Regards

                                       

                                       

                                      Re: Solarwinds API

                                      Wael Hilal

                                      IP Planning Supervisor | IP Core Planning | Strategic Planning & Development Directorate

                                      • Re: Solarwinds API
                                        Wael Hilal

                                        Hope that you can help in this regard.

                                         

                                        Re: Solarwinds API

                                        Wael Hilal

                                        IP Planning Supervisor | IP Core Planning | Strategic Planning & Development Directorate

                                         

                                         

                                        From: Wael Hilal

                                        Sent: Wednesday, May 30, 2012 2:43 PM

                                        To: 'jive-861857486-34i6-2-3ojb@solarwinds.hosted.jivesoftware.com'

                                        Subject: RE: Re: Solarwinds API - Solarwinds API

                                         

                                        Hi many thanks for your reply.

                                        The problem is that we want the API from Solarwinds or if you have passed through this, the API that I can use to retrieve the IP SLA statistics for customers from this portal server.

                                        So this portal will be used by our customers to get statistics on their lines from Solarwinds server regarding IP SLA statistics.

                                         

                                         

                                        Regards

                                         

                                         

                                        Re: Solarwinds API

                                        Wael Hilal

                                        IP Planning Supervisor | IP Core Planning | Strategic Planning & Development Directorate

                                        • Re: Solarwinds API
                                          Wael Hilal

                                          Hi Michal

                                          Really I need your help, please your feedback

                                           

                                          Regards

                                           

                                           

                                          Re: Solarwinds API

                                          Wael Hilal

                                          IP Planning Supervisor | IP Core Planning | Strategic Planning & Development Directorate

                                           

                                           

                                          From: Wael Hilal

                                          Sent: Wednesday, May 30, 2012 2:43 PM

                                          To: 'jive-861857486-34i6-2-3ojb@solarwinds.hosted.jivesoftware.com'

                                          Subject: RE: Re: Solarwinds API - Solarwinds API

                                           

                                          Hi many thanks for your reply.

                                          The problem is that we want the API from Solarwinds or if you have passed through this, the API that I can use to retrieve the IP SLA statistics for customers from this portal server.

                                          So this portal will be used by our customers to get statistics on their lines from Solarwinds server regarding IP SLA statistics.

                                           

                                           

                                          Regards

                                           

                                           

                                          Re: Solarwinds API

                                          Wael Hilal

                                          IP Planning Supervisor | IP Core Planning | Strategic Planning & Development Directorate

                                            • Re: Solarwinds API
                                              michal.hrncirik

                                              Hi,

                                               

                                              you can use our SWQL and get IPSLA related data. For instance:

                                              SELECT op.OperationName, op.CurrentStats.RoundTripTime

                                              FROM Orion.IpSla.Operations op

                                               

                                              But can't you just create special group of users on SolarWinds web console and show data directly? I still don't know if you solve this problem because of policy restrictions, data accessibility or something else. Please let us know.

                                               

                                              thanks,

                                              Michal

                                                • Re: Solarwinds API
                                                  Wael Hilal

                                                  Hi Michal

                                                  Can you please clarify what is the SQWL, and where can I find it??

                                                  This SQWL will be on the portal?? And will it get the IPSLA statistics from Solarwinds server or from the DB??

                                                  Actually we prefer to use special portal from performance perspective, and from security perspective.

                                                  Do you have ready API that we can depend on???

                                                   

                                                   

                                                  Regards

                                                   

                                                  Re: Solarwinds API

                                                  Wael Hilal

                                                  IP Planning Supervisor | IP Core Planning | Strategic Planning & Development Directorate

                                                  • Re: Solarwinds API
                                                    diyaa.awad

                                                    Hi Michal,

                                                    can you please help in getting the below data from the database directly (queries) per line, or how to get it from API:

                                                     

                                                    • Utilization (%)
                                                    • Packet loss (%)
                                                    • Availability Status- report
                                                    • RTD (ms)
                                                    • Jitter (ms)

                                                     

                                                    Thank you

                                                      • Re: Solarwinds API
                                                        michal.hrncirik

                                                        Hi,

                                                         

                                                        I'd start here: http://thwack.solarwinds.com/thread/39001 download SDK and read an attached document with an example. It seem that your are going to build a complex solution so you really need to understand how our API works and how you can pull the data. I believe our engineers or community will help you if you will put here a SWQL query that doesn't fork for you or if you need something special But first of all, try to do a simple database query as it is described in attached SDK doc and let us know if it does work for you.

                                                         

                                                        also, part of mentioned link above are few other thwack discussions where people solving similar issues. let me know if that helped.

                                                         

                                                        thanks,

                                                        Michal

                                                          • Re: Solarwinds API
                                                            Wael Hilal

                                                            Hi Michal

                                                            Thanks for your reply.

                                                            Actually we had received the reply response from you before, we go deeply into it, but could not make use of it, as it contains query to DB, but actually we are not familiar of the DB tables, fields, and relations between tables!! We accessed also to the DB and see that there are hundreds of tables and correlations that are difficult to deal with, as we may get inaccurate data or reports. We drilled deeply in the Orion SDK and in the documentations, but all it contains is samples that do not help us.

                                                             

                                                            What we want is to build a customized reports for our customers related to status of their lines, IPSLA reports (Jitter, delay, RTT, etc), and in order to do that either you have APIs that we can depend on, or send us a ready queries in order to achieve this, as you well aware of the DB and all its tables, fields and correlations.

                                                             

                                                            Please help us in this issue, we had support on your product and they forward us to you in this forum.

                                                             

                                                             

                                                            Regards

                                                             

                                                             

                                                            Re: Solarwinds API

                                                            Wael Hilal

                                                            IP Planning Supervisor | IP Core Planning | Strategic Planning & Development Directorate