Activity overview
Latest activity by jankla
I also experience install issue. Downloaded 6.0.18 today (31-1-2017) and get error message: Failed to run SQL monitor Web error 0x80070057. retried download several times. / comments
I also experience install issue. Downloaded 6.0.18 today (31-1-2017) and get error message: Failed to run SQL monitor Web error 0x80070057. retried download several times.
Hi,
This qeury is used by me for the past 6 months. Seems to do the trick:
DECLARE @now BIGINT
SET @now = utils.DateTimeToTicks(GETUTCDATE())
;WITH cte AS (
SELECT acu.[AlertId]
FROM [alert].[Alert_Current] acu
LEFT JOIN [alert].[Alert_Cleared] ac
ON ac.AlertId = acu.AlertId
WHERE (ac.AlertId IS NULL) AND (acu.[Event]=1 OR acu.[LastSeverity] = 0)
)
INSERT INTO alert.[Alert_Cleared]
(
[AlertId],
[Date],
[Cleared]
)
SELECT
[AlertId], @now,
1
FROM
cte
GO / comments
Hi,
This qeury is used by me for the past 6 months. Seems to do the trick:
DECLARE @now BIGINT
SET @now = utils.DateTimeToTicks(GETUTCDATE())
;WITH cte AS (
SELECT acu.[AlertId]
FROM [alert].[Alert...
Qeurying SQL Monitor 4.x Repository
Hi All,
I am searching for means of qeurying the SQL MOnitor 4.x Data repository. How about sharing findings sofar?
My contributions:
--- Overview Servers, instances and databases:
use [RedGateSQLM...