makecrazy

Hi * What version are you running? Orion Platform HF1, NCM, IPAM, NPM, NTA: 2020.2.5 * What time zone are you (your browser) in? GMT+0500 (Karachi Standard Time) * What time zone is the Orion web server in? (UTC+05:00) Islamabad, Karachi * What time zone is the SQL database in? (UTC+05:00) Islamabad, Karachi

christopher.t.jones123 by adding -1 is not giving any value monthdiff(datetime,getdate())=-1

Dear dodo123 Yours provided link not resolve my issue, main concern is that why sqwl always giving wrong output in event time/availability % as compared to web report

Thanks dear, it provided my desired result.

Main issue we are facing is that different SWQL Quires are showing Data ( Time period ) which is always - 5 Hours of current time. Because of this .reason i try to add tostring(tolocal which provide correct time period for me. In mentioned script we are trying to know the reason whether nodes ( Routers ) are getting Down…

Dear not expert in scripting that's why need help on adding +5 Hours in Node Uptime ( SELECT TOP 1 EndTime.EventTime FROM Orion.Events AS Endtime WHERE EndTime.EventTime > StartTime.EventTime AND EndTime.EventType = 5 AND EndTime.NetObjectType = 'N' AND EndTime.NetworkNode = StartTime.NetworkNode ORDER BY EndTime.EventTime…

m-milligan KMSigma can u help me on this.

ok , thanks for urs support

now this error

giving error

when you use the tolocal function is the time still 5 hours off > its resolve timime issue only on Downtime and lastboot how to add tolocal on Uptime ? ( SELECT TOP 1 EndTime.EventTime FROM Orion.Events AS Endtime WHERE EndTime.EventTime > StartTime.EventTime AND EndTime.EventType = 5 AND EndTime.NetObjectType = 'N' AND…

 christopher.t.jones123 adam.beedell let me share complete script with result , need to add +5 hours in Uptime ( down time and last boot now showing correct time ) SELECT Nodes.Caption, Nodes.IPAddress, tostring(tolocal(StartTime.EventTime)) AS DownTime , nodes.status,tostring(tolocal(LastBoot)) AS LastBoot ,…

issue is that swql giving me node up/down time which is lesser than 5 hours from down/up event actual time.

not generating any result by AddHour(+5,StartTime.EventTime)

KMSigma can any one help on this

 dodo123 In this option , undp is not available

KMSigma / m-milligan one more thing need to add node custom property in this script. Node Customproperty.ATM_Branch = UAE

christopher.t.jones123 one more thing need to add node customproperty in this script. Node Customproperty.ATM_Branch = UAE

christopher.t.jones123 i had made changes , will check after 12:00 AM and will update. but i have to change date in script ever day. -- AND (StartTime.EventTime BETWEEN DATETRUNC('day', GETDATE()) AND DATETRUNC('day', ADDDAY(1, GETDATE()))) AND StartTime.EventTime >'2022-02-24'

christopher.t.jones123 This query is not providing report after 12:00 AM its showing this Nodes outages with duration for Datasource 1 from Today (Feb 23, 2022)Last dayOrdered by:Node Caption - AscendingNODE CAPTIONIP ADDRESSNODE DOWN TIMESTAMPNODE UP TIMESTAMPBOOTTIMEDURATION (MINUTES)ATM_BRANCHESNo activity to report.…

m-milligan / christopher.t.jones123 need urs help 

now after 12:00 AM its showing this Nodes outages with duration for Datasource 1 from Today (Feb 17, 2022)Last dayOrdered by:Node Caption - AscendingNODE CAPTIONIP ADDRESSNODE DOWN TIMESTAMPNODE UP TIMESTAMPBOOTTIMEDURATION (MINUTES)ATM_BRANCHESNo activity to report.

My timezones is gmt +5

Yes it's look like time zone issue , but my other sql query are running fine

Hi Time of down/up event is different in report as compared to what NMS web showing. Report: Node CaptionIP AddressNode Down TimestampNode Up TimestampDuration (minutes)SULTANKOT-031310.3.72.12/16/2022 4:09 PM2/16/2022 4:53 PM44SULTANKOT-031310.3.72.12/16/2022 2:07 AM2/16/2022 3:07 AM60 NMS WEB: TIME OF…

Hi thanks for detail reply, need changes in date query as ( Date = always today's date ( start time 12 AM AND end time on which time query executed. ) Down Event = last time when down event generated. Do you want to find the last Node Down event if it occurs outside of the current day? YES

I had changed time from 7 days to TODAY but report is not showing correct Today's availability , as I had share report and nms web compression on availability

Dear KMSigma, your updated linked report is providing correct Node reboot count but not showing correct value of availability. Change period from 7 days to Today availability states on NMS web

above query only giving reboot count not providing availability.

dear , i think iam unable to clearly tell the reboot thing. When router ( node ) reboot its change it Last Boot time and same time display in Event = Node reboot at i had add custom property , thanks Report showing reboot count difference. ( yesterday ) 6 reboot count Node reboot event from nms which shows node only boot…