Event Groups Sample -- Too big for original post.
We really need your input in this questionnaire
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Show posts MenuSELECT
id,
primary_ip,
agent_version,
platform_name,
uname
FROM
NETXMS.netxms.NODES WITH (NOLOCK)
WHERE
platform_name like 'windows%'
ORDER BY
uname
DECLARE @startDate INT
DECLARE @endDate INT
SET @startDate = (SELECT dbo.F_DATETIME_TO_UNIX_TIME('2011/02/01'))
SET @endDate = (SELECT dbo.F_DATETIME_TO_UNIX_TIME('2011/02/03'))
SELECT TOP 1500
eventCfg.event_code,
eventCfg.event_name,
LEFT(event_message,20) as eventMessage,
COUNT(*) as eventCount,
COUNT(DISTINCT event_source) as nodeCount
FROM (
SELECT
*
FROM
NETXMS.netxms.EVENT_LOG WITH (nolock)
WHERE
event_timestamp BETWEEN @startDate and @endDate
) eventDtl
JOIN NETXMS.netxms.event_cfg eventCfg
ON eventDtl.event_code = eventCfg.event_code
GROUP BY
eventCfg.event_code,
eventCfg.event_name,
LEFT(event_message,20)
ORDER BY
event_name
SELECT
event_id,
eventCfg.event_code,
eventCfg.event_name,
dbo.F_UNIX_TIME_TO_DATETIME(event_timestamp) as event_datetime,
event_message
FROM (
SELECT
*
FROM
NETXMS.netxms.EVENT_LOG WITH (nolock)
WHERE
event_source = $P!{eventSource}
) eventDtl
JOIN NETXMS.netxms.event_cfg eventCfg
ON eventDtl.event_code = eventCfg.event_code
WHERE
dbo.F_UNIX_TIME_TO_DATE(event_timestamp) BETWEEN '2011/01/01' AND '2011/01/31'
ORDER BY
event_timestamp