The most recent content from our members.
Greetings! I'm really new at SQL, and it's probably going to become more apparent once you see my query. I encourage any of you SQL guru's out there to help me optimize this. =) I made a query to populate a report as a Top 10 by month with the following: Column 1 - The Top 10 most common Alert Names. Column 2 - The…
Hi all. I'm not an SQL expert. from below information, how do I filter by custom property? and how do I add uptime event? SELECT StartTime.EventTime, Nodes.Caption, StartTime.Message, DATEDIFF(Mi, StartTime.EventTime, (SELECT TOP 1 EventTime FROM Events AS Endtime WHERE EndTime.EventTime > StartTime.EventTime AND…
Hi Is there a fast way to make that to SQL report I cant use the web report (too many records)
Must admit i'm not a SQL person, but can muck my way through most scripting.... I've written the following Advanded SQL Report to display only certain severities from the Syslog and now would like to enhance it so that i can get some color on it. i.e IF (SysLog_SysLogSeverities.SeverityName = 'Warning') OR THEN Orange IF…
I am trying to add some custom properties on our Historical - IP SLA Report. So what I did is I created 2 reports then get the SQL code. Report A - it will generate the Average of MOS and Jitter for the Last 30 days. Report B - it will generate the current statistics of MOS and Jitter with its custom properties (ex.…
Hello, We are trying to calculate the Jitter by subtracting the Max from the Min response time. We created a SQL Query but to no avail. Have you tried this before? SELECT TOP 10000 Convert(DateTime,Floor(Cast((DateTime) as Float)),0) AS SummaryDate, Nodes.Caption AS NodeName, AVG(ResponseTime.AvgResponseTime) AS…
It looks like you're new here. Sign in or register to get started.