38 Replies Latest reply on May 8, 2017 3:12 PM by josephwdowling

    Interface Availability Report

    rgward
      Report Writer only provides Availability at the Node level.
      Has anyone found a way to create an Availability report at the interface level?  Any thoughts how to do this?
        • Re: Interface Availability Report
          Network_Guru
          You can track the interface down time (not the availability) using the events.
          Just create an alert for any interface down. This will show up in the events, which you can create a report for minutes of down-time per outage.

          You could then manually convert this into availability.

          -=Cheers=-
                    NG
          • Re: Interface Availability Report
            rgward
            Thanks for your advice, NG!  I'll give it shot.
              • Re: Interface Availability Report

                i am new to orion, i use v 9.1 with sql express on win 2003.

                i need availability on interfaces BAD!!!

                i tried using the posts in this forum, but it

                not wrk much for me.  Can u please give me a

                step by step approach? i'd apreciate it greatly.

                  • Re: Interface Availability Report
                    mgibson

                    Follow this thread there are many examples available. Here is some more rudimentory code.

                    use netperfmon

                    SELECT Nodes.Caption AS NodeName,

                    nodes.department AS Dept,

                    Nodes.IP_Address AS IP_Address,

                    AVG(ResponseTime.Availability) AS AVERAGE_of_Availability

                     FROM

                    Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)

                     WHERE

                    ( DateTime BETWEEN 39448 AND 39478 )

                     GROUP BY Nodes.Caption, Nodes.IP_Address,nodes.department

                     ORDER BY nodes.department ASC, 4 ASC

                    • Re: Interface Availability Report
                      mgibson

                      Sorry, my previous reply was for node availability. Here is the correct code for interface availability

                      use netperfmon
                      IF exists (SELECT * FROM dbo.sysobjects where id = object_id(N'dbo.SUMTABLE'))

                      DROP TABLE SUMTABLE


                      go
                      SELECT
                      EventTime,
                      Interfaces.Caption,
                      NetObjectID,
                      NodeID,

                      DATEDIFF(MINUTE, StartTime.EventTime,
                      (SELECT TOP 1 EventTime
                      FROM Events AS Endtime
                      WHERE
                      EndTime.EventTime > StartTime.EventTime
                      AND EndTime.EventType = 11
                      AND EndTime.NetObjectType = 'I'
                      AND EndTime.NetObjectID = StartTime.NetObjectID
                      ORDER BY EndTime.EventTime))
                      AS OutageDurationInMinutes
                      INTO SUMTABLE
                      FROM Events AS StartTime
                      INNER JOIN Interfaces ON StartTime.NetObjectID = Interfaces.InterfaceID
                      WHERE
                      (StartTime.EventType = 10)
                      AND (StartTime.NetObjectType = 'I')
                      AND (eventtime between '11/01/2008 00:00:00' and '11/30/2008 23:59:59')
                      GROUP BY
                      Interfaces.NodeID,
                      NetObjectID,
                      Interfaces.Caption,
                      Interfaces.InterfaceID,
                      StartTime.EventTime,
                      StartTime.NetObjectID

                      go

                      Select DISTINCT
                      Nodes.Caption AS Router_Name, 
                      interfaces.caption,

                      COALESCE(CONVERT(char(10),100-Round(SUM(Convert(float,OutageDurationInMinutes)/(DATEDIFF(Minute, '09/01/2005 00:00:00', '09/30/2005 23:59:59') + 1 )*100),2)),'100') + '%' AS "Avalibility This Month",
                      COALESCE(SUM(OutageDurationInMinutes), 0) AS OutageTimeInMinutes
                      FROM (Nodes INNER JOIN Interfaces ON Interfaces.NodeID = Nodes.NodeID) LEFT JOIN SUMTABLE ON SUMTABLE.NetObjectID = Interfaces.InterfaceID

                      GROUP BY Nodes.Caption, interfaces.caption, nodes.department

                      ORDER BY Nodes.Caption

                      DROP TABLE SUMTABLE

                        • Re: Interface Availability Report
                          denny.lecompte

                          mgibson,

                          Have you uploaded your custom report to the content exchange zone so that more folks can benefit from it?

                          • Re: Interface Availability Report

                            Thank man.... ur a life saver..

                            query works great!!!!!!!!!

                            • Re: Interface Availability Report
                              kkan

                              Hello mgibson,

                              The report you have created is perfect, really helpfull!

                              I am trying to understand what do I have to change in order to create this report but only for specific interfaces and not for all in the database.
                              F.e. Select specific interfaces using InterfaceID.
                              Can you please help on this?

                              Best Regards
                              Kostas Kanellopoulos

                                • Re: Interface Availability Report
                                  jcooler

                                  You can limit it to certain interfaces by adding a WHERE statement between the FROM line and the GROUP BY line.

                                  Example:

                                  FROM .....

                                  WHERE (Interfaces.InterfaceID = '##' 

                                            or Interfaces.InterfaceID = '##'

                                            or ......)

                                  GROUP BY .....

                                   

                                  replace the ## with the interface ids you are looking to report on. Just keep adding OR statements for each interface you want to add to the report.

                                   

                                  Another way (cleaner way) to achieve this is to use a custom property on the interfaces.Create a True/false property and call it something like "reportAvailability".  Set the property to TRUE  for any interface that you want to include. This will all be done in the Custom Property editor application on the Orion server.

                                  Then, instead of using the WHERE statement listed above in the SQl report, you will use this one instead...

                                  WHERE (reportAvailability = 'TRUE')     

                                  This is assuming that "reportAvailability" is the name of the custom property that you created.

                                  Hope this helps you out.

                                  Jeremy

                                    • Re: Interface Availability Report
                                      Mahmood

                                      is this working 100%?? i can get only 2 months data, when i change the dates to anything older than 2 month the availability shows 100% for all which is impossible!

                                      can someone help pleas.

                                      • Re: Interface Availability Report
                                        josephwdowling

                                        I try to add a WHERE clause and SW keeps telling me "query invalid" here is my query I'm trying to select multiple interfaces: Interface 9056 works

                                         

                                        DECLARE @StartDate DateTime
                                                DECLARE @EndDate DateTime

                                                SET @StartDate = ${FromTime}
                                                SET @EndDate = ${ToTime}

                                                SELECT Interfaces.InterfaceId,
                                                Nodes.NodeID,
                                                Nodes.Caption AS NodeName,
                                                Interfaces.Caption AS Interface_Caption,
                                                        Maxbps_In95,
                                                Maxbps_Out95,
                                                Maxbps_In99,
                                                Maxbps_Out99
                                                FROM Nodes
                                                INNER JOIN Interfaces ON Nodes.NodeID = Interfaces.NodeID
                                                INNER JOIN (
                                                SELECT InterfaceID = 9056,
                                              
                                                dbo.GetInBpsPercentile(InterfaceID, @StartDate, @EndDate,95) AS Maxbps_In95,
                                                dbo.GetOutBpsPercentile(InterfaceID, @StartDate, @EndDate,95) AS Maxbps_Out95,
                                                dbo.GetInBpsPercentile(InterfaceID, @StartDate, @EndDate,99) AS Maxbps_In99,
                                                dbo.GetOutBpsPercentile(InterfaceID, @StartDate, @EndDate,99) AS Maxbps_Out99
                                                FROM InterfaceTraffic
                                                WHERE InterfaceTraffic.DateTime >= @StartDate AND InterfaceTraffic.DateTime <= @EndDate
                                                GROUP BY InterfaceID
                                                ) TrafficStat
                                                ON Interfaces.InterfaceID = TrafficStat.InterfaceID
                                             

                                    • Re: Interface Availability Report
                                      msab

                                      Hi,

                                      This report is very nice. I can figure out how to use it in its current format.  I am also a mediocre SQL person.  Is there an easy way to get the sql to show the current month, previous month or last 30 days?

                                       

                                      I see where I can edit to change the time frames but what would I use for current month, previous month and last 30 days?

                                       

                                      Also too is there a easy way just to show m-f 8-6  and exclude nights and weekends?

                                       

                                      Thanks for all this great work.

                                      Mike

                                • Re: Interface Availability Report
                                  Network_Guru
                                  quote:On this issue of interface availability, how would I create a report based on down events to calculate interface availability?  Would I use a report similar to the canned Outage Duration report for nodes?  Thanks


                                  That is correct.
                                  I haven't actually done this with interfaces, but it should work the same as the Node Outage Duration reports. You may have to customize the SQL query to do this.


                                  -=Cheers=-
                                            NG
                                  • Re: Interface Availability Report
                                    This is SQL query for
                                    Interfaces-outage-in minutes-monthly
                                    please some one help me about creating Availabillity report for interfaces how to summ all outages (minutes) and give in percents for my manager ???? emergency 
                                    and how it will go on web?
                                    ************************************
                                    SELECT
                                    CONVERT(DateTime,LTRIM(MONTH(EventTime)) + '/01/' + LTRIM(YEAR(EventTime)),101) AS SummaryMonth,
                                    Interfaces.NodeID,
                                    Interfaces.Caption,
                                    Interfaces.InterfaceID,
                                    DATEDIFF(Mi, StartTime.EventTime,
                                    (SELECT TOP 1
                                    EventTime
                                    FROM Events AS Endtime
                                    WHERE EndTime.EventTime > StartTime.EventTime AND EndTime.EventType = 11
                                    AND EndTime.NetObjectType = 'I'
                                    AND EndTime.NetObjectID = StartTime.NetObjectID
                                    ORDER BY EndTime.EventTime)) AS OutageDurationInMinutes

                                    FROM Events StartTime INNER JOIN Interfaces ON StartTime.NetObjectID = Interfaces.InterfaceID
                                    WHERE (StartTime.EventType = 10) AND (StartTime.NetObjectType = 'I') AND ( EventTime BETWEEN 38410 AND 38439 )

                                    GROUP BY CONVERT(DateTime,LTRIM(MONTH(EventTime)) + '/01/' + LTRIM(YEAR(EventTime)),101),
                                    Interfaces.NodeID,Interfaces.Caption, Interfaces.InterfaceID, StartTime.EventTime, StartTime.NetObjectID
                                    • Re: Interface Availability Report
                                      rossw
                                      Zoran,
                                      Did you ever get this to work?
                                      Im very interested in the same thing.

                                      Ross warren
                                      • Re: Interface Availability Report
                                        rossw
                                        This is very close.. Not quite in percentages yet.





                                        IF exists (SELECT * FROM dbo.sysobjects where id = object_id(N'[dbo].[SUMTABLE]'))
                                        DROP TABLE SUMTABLE


                                        SELECT CONVERT(DateTime,LTRIM(MONTH(EventTime)) + '/07/' + LTRIM(YEAR(EventTime)),101) AS SummaryMonth,
                                        EventTime,
                                        Interfaces.Caption,
                                        NetObjectID,


                                        DATEDIFF(MINUTE, StartTime.EventTime,
                                           (SELECT TOP 1 EventTime
                                             FROM Events AS Endtime
                                             WHERE
                                                 EndTime.EventTime > StartTime.EventTime
                                             AND EndTime.EventType = 5001
                                             AND EndTime.NetObjectType = 'I'
                                             AND EndTime.NetObjectID = StartTime.NetObjectID
                                           ORDER BY EndTime.EventTime))

                                           AS OutageDurationInMinutes

                                        INTO SUMTABLE
                                        FROM Events AS StartTime
                                           INNER JOIN Interfaces ON StartTime.NetObjectID = Interfaces.InterfaceID
                                           WHERE
                                               (StartTime.EventType = 10)
                                           AND (StartTime.NetObjectType = 'I')
                                           AND (Interfaces.Service = 'Internet')
                                           --AND ( EventTime BETWEEN 38410 AND 38439 )

                                        GROUP BY CONVERT(DateTime,LTRIM(MONTH(EventTime)) + '/07/' + LTRIM(YEAR(EventTime)),101),
                                        Interfaces.NodeID,
                                        NetObjectID,
                                        Interfaces.Caption,
                                        Interfaces.InterfaceID,
                                        StartTime.EventTime,
                                        StartTime.NetObjectID

                                        GO

                                        Select Caption AS Circuit_Name, SUM(OutageDurationInMinutes) AS TotalOutageTime
                                        from SUMTABLE

                                        GROUP BY Caption
                                        HAVING SUM(OutageDurationInMinutes) IS NOT NULL
                                        • Re: Interface Availability Report
                                          rossw
                                          Interface availability based on Zoran's start.
                                          With Percentage.
                                          NOTE: I use the custom property Interfaces.Service = "Internet"
                                          to define my circuits. Thanks Yahoo chart guy!



                                          IF exists (SELECT * FROM dbo.sysobjects where id = object_id(N'[dbo].[SUMTABLE]'))
                                          DROP TABLE SUMTABLE


                                          SELECT CONVERT(DateTime,LTRIM(MONTH(EventTime)) + '/07/' + LTRIM(YEAR(EventTime)),101) AS SummaryMonth,
                                          EventTime,
                                          Interfaces.Caption,
                                          NetObjectID,
                                          NodeID,


                                          DATEDIFF(MINUTE, StartTime.EventTime,
                                             (SELECT TOP 1 EventTime
                                               FROM Events AS Endtime
                                               WHERE
                                                   EndTime.EventTime > StartTime.EventTime
                                               AND EndTime.EventType = 5001
                                               AND EndTime.NetObjectType = 'I'
                                               AND EndTime.NetObjectID = StartTime.NetObjectID
                                             ORDER BY EndTime.EventTime))

                                             AS OutageDurationInMinutes

                                          INTO SUMTABLE
                                          FROM Events AS StartTime
                                             INNER JOIN Interfaces ON StartTime.NetObjectID = Interfaces.InterfaceID
                                             WHERE
                                                 (StartTime.EventType = 10)
                                             AND (StartTime.NetObjectType = 'I')
                                             AND (Interfaces.Service = 'Internet')
                                             --AND ( EventTime BETWEEN 38410 AND 38439 )

                                          GROUP BY CONVERT(DateTime,LTRIM(MONTH(EventTime)) + '/07/' + LTRIM(YEAR(EventTime)),101),
                                          Interfaces.NodeID,
                                          NetObjectID,
                                          Interfaces.Caption,
                                          Interfaces.InterfaceID,
                                          StartTime.EventTime,
                                          StartTime.NetObjectID

                                          GO

                                          Select Nodes.Caption, SUMTABLE.Caption AS Circuit_Name,
                                          COnvert(char(5),Round(SUM(Convert(float,OutageDurationInMinutes)/43200*100),2)) + '%' AS "Percent unavailable Per Month"
                                          from SUMTABLE LEFT JOIN Nodes ON Nodes.NodeID = SUMTABLE.NodeID

                                          GROUP BY Nodes.Caption, SUMTABLE.Caption
                                          HAVING SUM(OutageDurationInMinutes) IS NOT NULL


                                          Im just talking to my self
                                          Ross Warren
                                          • Re: Interface Availability Report
                                            Network_Guru
                                            quote:Originally posted by rossw

                                            Interface availability based on Zoran's start.
                                            With Percentage.
                                            NOTE: I use the custom property Interfaces.Service = "Internet"
                                            to define my circuits. Thanks Yahoo chart guy!

                                            Im just talking to my self
                                            Ross Warren


                                            Brilliant work Ross,
                                            I wish I had this kind of SQL savvy!

                                            It just goes to show the untapped potential of the Orion reporting engine.


                                            -=Cheers=-
                                                      NG
                                            • Re: Interface Availability Report
                                              rgward
                                              My thanks to everyone for your feedback with this post! Very nice work Ross and Zoran too!  I wish I had your skill sets to develop this kind of stuff!
                                              • Re: Interface Availability Report
                                                rossw
                                                A slight update:

                                                I changed the calculation to availability, not unavailability.
                                                Also made the output show all the interfaces.service = 'Internet'
                                                not just the interfaces that show up in events. Got to show those
                                                100%s!!!!..


                                                IF exists (SELECT * FROM dbo.sysobjects where id = object_id(N'[dbo].[SUMTABLE]'))
                                                DROP TABLE SUMTABLE

                                                SELECT
                                                EventTime,
                                                Interfaces.Caption,
                                                NetObjectID,
                                                NodeID,

                                                DATEDIFF(MINUTE, StartTime.EventTime,
                                                   (SELECT TOP 1 EventTime
                                                     FROM Events AS Endtime
                                                     WHERE
                                                         EndTime.EventTime > StartTime.EventTime
                                                     AND EndTime.EventType = 5001
                                                     AND EndTime.NetObjectType = 'I'
                                                     AND EndTime.NetObjectID = StartTime.NetObjectID
                                                   ORDER BY EndTime.EventTime))

                                                   AS OutageDurationInMinutes

                                                INTO SUMTABLE
                                                FROM Events AS StartTime
                                                   INNER JOIN Interfaces ON StartTime.NetObjectID = Interfaces.InterfaceID
                                                   WHERE
                                                       (StartTime.EventType = 10)
                                                   AND (StartTime.NetObjectType = 'I')
                                                   AND (Interfaces.Service = 'Internet')

                                                GROUP BY
                                                Interfaces.NodeID,
                                                NetObjectID,
                                                Interfaces.Caption,
                                                Interfaces.InterfaceID,
                                                StartTime.EventTime,
                                                StartTime.NetObjectID

                                                GO

                                                Select DISTINCT Nodes.Caption AS Router_Name, Interfaces.Caption,
                                                COALESCE(CONVERT(char(5),100-Round(SUM(Convert(float,OutageDurationInMinutes)/43200*100),2)),'100') + '%' AS "Avalibility This Month"
                                                FROM (Nodes INNER JOIN Interfaces ON Interfaces.NodeID = Nodes.NodeID) LEFT JOIN SUMTABLE ON SUMTABLE.NodeID = Interfaces.NodeID
                                                Where Interfaces.Service = 'Internet'

                                                GROUP BY Nodes.Caption, Interfaces.Caption
                                                ORDER BY Nodes.Caption
                                                • Re: Interface Availability Report
                                                  rgward
                                                  Ross...I attempted to set up the SQL report but Report Writer didn't like the GO statement.  Can you shed any light?  SQL if not my forte.
                                                  • Re: Interface Availability Report
                                                    Network_Guru
                                                    quote:Originally posted by rgward

                                                    Ross...I attempted to set up the SQL report but Report Writer didn't like the GO statement.  Can you shed any light?  SQL if not my forte.


                                                    Ron, I believe you must use M$ Enterprise SQL Manager to run this code.

                                                    -=Cheers=-
                                                              NG
                                                    • Re: Interface Availability Report
                                                      rossw
                                                      Yes. I cant get it to run in Report Writer either.
                                                      Still working on it. Will Share when I do.

                                                      Yes SQL Enterprize manager is what I use.

                                                      Ross Warren
                                                      • Re: Interface Availability Report
                                                        rgward
                                                        Thank you Gents!  I'll run it thru SQL Manager.

                                                        Ross...Report Writer version will be nice too. Hope it's not too much trouble.

                                                        Ron
                                                        • Re: Interface Availability Report
                                                          Hmmmmmmmm...


                                                          I can't seem to get this to work, I get the following error:

                                                          Server: Msg 207, Level 16, State 3, Line 4
                                                          Invalid column name 'Service'.
                                                          Server: Msg 208, Level 16, State 1, Line 2
                                                          Invalid object name 'SUMTABLE'.

                                                          I should be able to just run this out of SQL Query Analyzer without any DB mods, correct?

                                                          Thanks everyone!

                                                          -Steve
                                                          • Re: Interface Availability Report
                                                            rossw
                                                            Steve,
                                                            You need to do a custom property called service.
                                                            Was an idea i gleamed from the Yahoo Charts thread.

                                                            Ross W
                                                            • Re: Interface Availability Report

                                                              Or using one of my existing groups seems to work ok too


                                                              Thanks!

                                                              -Steve
                                                              • Re: Interface Availability Report
                                                                Hi,

                                                                Any ideas if this would be possible querying the syslog messages? Some of our WAN outages don't involve an interface actually going down, but we get and EIGRP neighbor state change message in the syslog. I want to be able to setup a report for monthly outages that queries the syslog tables for these messages.

                                                                Cheers

                                                                Owen
                                                                • Re: Interface Availability Report
                                                                  I ran the SQL query from rossw (dated 8/4) and got the following

                                                                  Server: Msg 208, Level 16, State 1, Line 2
                                                                  Invalid object name 'SUMTABLE'.

                                                                  Unfortunately I am not really SQL savvy,  can someone tell me what this means?

                                                                  Incidently, I was using the SQL Query Analyzer..
                                                                  • Re: Interface Availability Report
                                                                    rossw
                                                                    SUMTABLE is just a temp table that gets build to aggregate data.

                                                                    Mine just started to fail after upgrading to 7.8.. Must check into.

                                                                    Ross Warren
                                                                    • Re: Interface Availability Report
                                                                      I ran the report once, then it failed complaining about the SUMTABLE so I nuked that table and it ran again..

                                                                      Seems that it doesn't clean up correctly or something..


                                                                      -Steve
                                                                      • Re: Interface Availability Report
                                                                        rossw
                                                                        Had some Errors and incorrect reporting.
                                                                        My DBA and I fixed these up.

                                                                        This is for September and is keyed of Interfaces.Service = 'backbone'.  I have started using Interfaces.Service to help us define different reports.. Such as 'Internet' or 'backbone' or 'Customer'  etc.



                                                                        IF exists (SELECT * FROM dbo.sysobjects where id = object_id(N'[dbo].[SUMTABLE]'))

                                                                        DROP TABLE SUMTABLE


                                                                        go
                                                                        SELECT
                                                                        EventTime,
                                                                        Interfaces.Caption,
                                                                        NetObjectID,
                                                                        NodeID,
                                                                        Interfaces.Service_Type,

                                                                        DATEDIFF(MINUTE, StartTime.EventTime,
                                                                           (SELECT TOP 1 EventTime
                                                                            FROM Events AS Endtime
                                                                             WHERE
                                                                                 EndTime.EventTime > StartTime.EventTime
                                                                             AND EndTime.EventType = 11
                                                                             AND EndTime.NetObjectType = 'I'
                                                                             AND EndTime.NetObjectID = StartTime.NetObjectID
                                                                           ORDER BY EndTime.EventTime))
                                                                           AS OutageDurationInMinutes
                                                                        INTO SUMTABLE
                                                                        FROM Events AS StartTime
                                                                           INNER JOIN Interfaces ON StartTime.NetObjectID = Interfaces.InterfaceID
                                                                           WHERE
                                                                               (StartTime.EventType = 10)
                                                                           AND (StartTime.NetObjectType = 'I')
                                                                           AND (Interfaces.Service = 'Backbone')
                                                                           AND (eventtime between '09/01/2005 00:00:00' and '09/30/2005 23:59:59')
                                                                        GROUP BY
                                                                        Interfaces.NodeID,
                                                                        NetObjectID,
                                                                        Interfaces.Caption,
                                                                        Interfaces.InterfaceID,
                                                                        StartTime.EventTime,
                                                                        StartTime.NetObjectID,
                                                                        Interfaces.Service_Type

                                                                        go


                                                                        Select DISTINCT
                                                                        Nodes.Caption AS Router_Name,
                                                                         
                                                                        Interfaces.Label AS Interface,
                                                                        Interfaces.Service_Type,


                                                                        COALESCE(CONVERT(char(10),100-Round(SUM(Convert(float,OutageDurationInMinutes)/(DATEDIFF(Minute, '09/01/2005 00:00:00', '09/30/2005 23:59:59') + 1 )*100),2)),'100') + '%' AS "Avalibility This Month",
                                                                        COALESCE(SUM(OutageDurationInMinutes), 0) AS OutageTimeInMinutes
                                                                        FROM (Nodes INNER JOIN Interfaces ON Interfaces.NodeID = Nodes.NodeID) LEFT JOIN SUMTABLE ON SUMTABLE.NetObjectID = Interfaces.InterfaceID
                                                                        Where Interfaces.Service = 'Backbone'
                                                                        GROUP BY Nodes.Caption, Interfaces.Label, Interfaces.Service_Type

                                                                        ORDER BY Nodes.Caption

                                                                        DROP TABLE SUMTABLE



                                                                        • Re: Interface Availability Report
                                                                          rossw
                                                                          This still doesnt run in Report Writer.
                                                                          Ugggh.
                                                                          • Re: Interface Availability Report
                                                                            rgward
                                                                            Bump...Ross, ever get this query working in Report Writer?
                                                                            • Re: Interface Availability Report
                                                                              rossw
                                                                              We dont really use report writer anymore. We have created our own clustered DB server that takes in data from or satellite modems, Remedy,  Cisco call manager and Solarwinds and runs reports with Crystal Reports and Sharepoint. 

                                                                              The problem with my query and report writer is the use of the temp table.  If some one (smarter) could re-write it without the use of the temp table it might work.

                                                                              -Ross Warren
                                                                                • Re: Interface Availability Report
                                                                                  Prysm

                                                                                  Hi all,


                                                                                  i'm new in this forum and i'm not skilled on SQL;


                                                                                  i was trying to create a report with your advanced query but i notice that works only with events that are closed inside the month and doesn't work with events that haven't an EndTime inside selected month; then i tried to insert a period that is longer then a month but nothing..


                                                                                  Is there anybody who can help me ?


                                                                                  Thanks in advance.


                                                                                  Prysm

                                                                                  • Re: Interface Availability Report
                                                                                    kreases

                                                                                    I followed this thread the whole way through in the hope I would be able to get a report that gives me the availability of interfaces selected by a custom property only to find none of these suggestions will run in report writer. Unlike others report writer is all I have, surely there must be a way round the syntax error on the GO command, any ideas would be appreciated.