The most recent content from our members.
Is it possible to convert a string value to the date format with SWQL somehow? I have some metrics from custom poller: CurrentValueCaption03/15/2021a.host04/25/2021b.host11/13/2020c.hostUnknownd.host09/06/2021e.host "CurrentValue" contains a date in MM/DD/YYYY format (actually a string value), and I want to compare it with…
Hello, We've been using the "Convert into Service Request" feature for a few months now and we would like now to know if there is a plan to Convert a "Service Request/Catalogue" into a "Service Request/Catalogue"? Sometimes users are submitting their request under the wrong Service Catalogue item, and it would be useful to…
Hi Team, Any idea on how we can change this to mbps or gbps? Thanks!
Hello Orion SDK Community, I hope I'm just unaware of the ability to convert string data to a number - I'm attempting to determine (based on the polling frequency of an application template) the approximate "weight" of the components for an application monitor. To that end, I'm pulling the value from the…
I have created an interface alert that inform me of the following for a specific Interface: Xmit bps is greater than or equal to 8388608 (traffic OUT of the interface greater than 8.0 Mbps) In the response action I have it configured to e-mail me the following: OUT Bps: ${Outbps} I get the following results in e-mail: OUT…
Out of my depth on this one - typically I deal with Windows boxes. For those who are not familiar, some items track time passage with Linux Epoch time, which counts the number of seconds since 1/1/1970. Great for computers, not so good for people as "1452714901" doesn't mean much to a human. In SQL, I was able to convert…
I've looked around a bit but can't find a thread with a question like this, so please forgive me and just link it if this has been answered in a previous post. I'm looking to pull data on memory usage from a node over a given time. I know this is built in to a point but limited based on what the user is asking to be…
What's the correct way to format this SQL statement? I'm attempting to convert a celsius value to fahrenheit to include it in the alert message and NPM Event Log. Thank you!! ${SQL:Select CASE ${SensorUnit} WHEN 'Celsius' THEN (${SensorValue} * 9 / 5) + 32 ELSE 0 END} I get this error .... MACRO SQL ERROR - incorrect…
It looks like you're new here. Sign in or register to get started.