Hi
Do any one have reports showing counts of number of reboot of a device in frame of time e.g. last 24 Hrs. currently in report writer we have whole reboot events reports not showing particular exact count.
Thank you,
I am not really SQL expert however you can create something using count option .
Last Events - Group By Node Down, Up Reboot, Interface Up & Down
basically what you need to create some sql query to count the reboot event in 24/hrs time frame for each node .
may be someone already have that created can help you .
Thank you, its really give me idea to resolve the problem. thanks again.
I'm able to count reboot events but have mention reboot event time for evidence also
Can anyone help????
SELECT COUNT(Events.EventTime) AS COUNT_of_Event_Time,
Nodes.Caption AS NodeName
FROM
Nodes INNER JOIN (Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType = Events_EventTypes.EventType)) ON (Nodes.NodeID = Events.NetworkNode)
WHERE
( EventTime BETWEEN 42525.5 AND 42526.5416666667 )
AND
(
(Events.EventType = 14)
)
GROUP BY Nodes.Caption
ORDER BY 1 DESC
You will have to provide an aggregate function of some kind to get the information:
SELECT COUNT(Events.EventTime) AS COUNT_of_Event_Time,Min(Events.EventTime) as From_Time, MAX(Events.EventTime) Until_timeNodes.Caption AS NodeNameFROMNodes INNER JOIN (Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType = Events_EventTypes.EventType)) ON (Nodes.NodeID = Events.NetworkNode) WHERE( EventTime BETWEEN 42525.5 AND 42526.5416666667 )AND( (Events.EventType = 14))GROUP BY Nodes.CaptionORDER BY 1 DESC
