brunofl

Comments

  • Hi mitul_darji, Great work! Thanks for sharing. I am a bit new with SWQL, and I am trying to understand the following part of your code: "FROM Events StartTime ..." is it equivalent to T-SQL FROM Events as StartTime ?
    in Node Outage Duration Comment by brunofl August 2019
  • @mesverrum Thanks for your updates, I did try the query, now it provides a different error "Function REPLACE not found." I need to leave for lunch, but will make some tests, according with documentation in (SWQL Functions · solarwinds/OrionSDK Wiki · GitHub ) it should work. lat me know in case you figure it out. thanks
    in Need help converting t-sql functions 'convert()' and 'cast()' to work in SWQL Comment by brunofl August 2019
  • @mesverrum I am getting the events where an access point start having more than 30 simultaneous clients. It was easy for me to get the info from the Events table than from the Wireless_Clients_SessionHistory (not sure why, but it only gets datapoints from the past month). The query shour return Event Time (last 24hs),…
    in Need help converting t-sql functions 'convert()' and 'cast()' to work in SWQL Comment by brunofl August 2019
  • Hi Deverts, Thanks for the update, but the solution I am looking for is using the time interval like a month or so, to be able to get the 95percentile of the interaces every hours interval like every 4 hours so we can get some insight on its variation. To manually adjust the report time fram to get one report for every…
    in How to increase granularity of 95percentile report? Comment by brunofl March 2020
  • HerrDoktor Danke I was able to replace the Convert(varchar, r.Event_Time, 120) with DateTime(r.EventTime), now I am getting the following error. Let me show you my query: Select DateTime(r.Event_Time), r.AccessPoint, r.Clients From ( SELECT Orion.Events.EventTime AS Event_Time, SUBSTRING(…
    in Need help converting t-sql functions 'convert()' and 'cast()' to work in SWQL Comment by brunofl August 2019
Avatar