30 Replies Latest reply on Dec 11, 2014 7:34 AM by tomasv

    how to get report https availability with URL

    malikusman

      how to get report https availability with URL??

        • Re: how to get report https availability with URL
          tomasv

          If you want to monitor anything by SAM, you need to assign monitor application to some node.

          You can create just "External Node: No Status" or "Status Only: ICMP" for some IP address, if you don't need to monitor any true box bounded to the URL.

          Assign "HTTPS Monitor" template to the node.

          Start edit the new created application, edit the one component, which it has. Set URL to what you want.

          You can add component for every URL you want to monitor.


          2014-12-08 07_46_29-Edit Application - HTTPS Monitor.png

            • Re: how to get report https availability with URL
              malikusman

              Thanks for your response,I am new for solarwinds product,I have configured HTTPS monitor same as you describe  but I don't know how to generate availability report where it can show me for example : https://gmail.com was available 100% last month

               

              https gen.JPG

                • Re: how to get report https availability with URL
                  malikusman

                  Please Help me to get availability report including url.

                    • Re: Re: how to get report https availability with URL
                      tomasv

                      To get list of Urls and theirs % availability - regardless application it is assigned to, or template it belongs to -

                      you can use Custom Table with advanced database SQL query like this:

                       

                      SELECT  TOP 10000  

                        cs.Value AS Url, 

                        AVG(daa.PercentAvailability) AS PercentAvailability

                      FROM

                          APM_AlertsAndReportsData ard, 

                          APM_DailyComponentAvailability daa,       

                          APM_ComponentDefinition cd,

                          APM_ComponentSetting cs

                       

                      WHERE

                        MONTH([DateTime]) = MONTH(GETDATE())

                        AND daa.ComponentID = ard.ComponentID

                        AND  ard.ComponentType = cd.ComponentType

                        AND cs.ComponentID = ard.ComponentID

                        AND cd.Name = 'HTTPS Monitor'

                        AND cs.[Key] = 'Url'

                      GROUP BY cs.Value

                        • Re: Re: how to get report https availability with URL
                          malikusman

                          Dear Tomasv,

                          Thanks a lot without your suggestions, it was not possible to resolve the issue once again thanks.

                          Cheers

                          • Re: how to get report https availability with URL
                            malikusman

                            I am getting everything what ever I want except History Availability .I am unable to find out option for last month.with above SQL query I am getting this-

                             

                            sql.JPG

                             

                             

                             

                            I don't have idea about SQL could you please let me know how to get below fields-

                            Avil.JPG

                            Thanks

                              • Re: how to get report https availability with URL
                                tomasv

                                If last month means last 28/30/31 days, then the query should like this:

                                SELECT  TOP 10000  

                                  cs.Value AS Name, 

                                  AVG(daa.PercentAvailability) AS PercentAvailability,

                                  ccs.Availability AS CurrentStatus

                                 

                                FROM

                                    APM_AlertsAndReportsData ard, 

                                    APM_DailyComponentAvailability daa,       

                                    APM_ComponentDefinition cd,

                                    APM_ComponentSetting cs,

                                    APM_CurrentComponentStatus ccs

                                 

                                WHERE

                                  daa.ComponentID = ard.ComponentID

                                  AND  ard.ComponentType = cd.ComponentType

                                  AND cs.ComponentID = ard.ComponentID

                                  AND ccs.ComponentID = ard.ComponentID

                                  AND cd.Name = 'HTTPS Monitor'

                                  AND cs.[Key] = 'Url'

                                  AND [DateTime] >= dateadd(m, -1, GETDATE())

                                GROUP BY cs.Value, ccs.Availability

                                 

                                If last month means - prior month, it should be something like this:

                                 

                                SELECT  TOP 10000  

                                  cs.Value AS Name, 

                                  dateadd(m, datediff(m, 0, [DateTime]), 0)  AS [Timestamp],

                                  AVG(daa.PercentAvailability) AS PercentAvailability,

                                  ccs.Availability AS CurrentStatus

                                 

                                FROM

                                    APM_AlertsAndReportsData ard, 

                                    APM_DailyComponentAvailability daa,       

                                    APM_ComponentDefinition cd,

                                    APM_ComponentSetting cs,

                                    APM_CurrentComponentStatus ccs

                                 

                                WHERE

                                  daa.ComponentID = ard.ComponentID

                                  AND  ard.ComponentType = cd.ComponentType

                                  AND cs.ComponentID = ard.ComponentID

                                  AND ccs.ComponentID = ard.ComponentID

                                  AND cd.Name = 'HTTPS Monitor'

                                  AND cs.[Key] = 'Url'

                                  AND [DateTime] BETWEEN dateadd(m,-1,DATEADD(mm, DATEDIFF(mm,0,getdate()  ), 0))

                                                        AND dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()  ), 0))

                                GROUP BY cs.Value, dateadd(m, datediff(m, 0, [DateTime]), 0),ccs.Availability