The most recent content from our members.
Need help to create an SLA breached table showing committed XXmiliseconds Vs current XX milliseconds values with SLA pass or SLA breached. Can someone please help me create a table for ICMP Operations IPSLA? What I need. I have a site with a committed SLA of 30ms around the clock. If it is more than 30ms I need to capture…
How can I schedule reports from OLM database(FROM dbo.OrionLog_LogEntryMessageView) have a working query on the database side, but not on reporting. but the query does work which I assume report know nothing about it. im not given a error but invalid query. i tried to do the same query in a dashboard and got a better error…
This is an overly simplified guide for "Keep the lights on" SQL to "Expert" SQL users wanting to jump into SolarWinds Query Language (aka Orion API) as fast as possible. Who can use SWQL? * Any user that has web credentials to the web console can use those credentials to run scripts. What is SWQL? * Orion SWQL or…
We are currently using the built in downtime report within report writer to view which nodes have gone down and for how long within the past month. I am trying to create two separate reports that accomplish a similar task but for a specific group. We have a group named "Critical Nodes". I would like (1) a report that shows…
I want to create report which shows me only First day & Last Day Utilization for Last month. below is the query, its not giving any error nor output. can someone help me DECLARE @StartDate DATETIME, @EndDate DATETIME SET @StartDate = dateadd(mm, -1, getdate()) SET @StartDate = dateadd(mm, DATEDIFF(mm,0,GETDATE()) - 1, 0)…
Hi, I have a problem about showing custom sql report created report writer. There is Nodes.Department limitation on account. That below sql query correctly runs at SSMS/Database Manager and Report Writer. But if I save this report on Report Writer and check this report via limited account, I get an error like 'The…
when custom reports are parsed currently, output is in form of table...ok, that makes sense. As this post shows, thanks to Mariusz Handke's digging, this is coded to IGNORE any breaks [see below] that might be in there as well as inserted, etc.. I'd love to see it [each cell of row] treated as...maybe....HTML, where it…
It looks like you're new here. Sign in or register to get started.