Can I create a Log Viewer Page or Dashboard with specific filter ?
No need to click on the Filters every time ?
e.g. the page can only show a specific node syslog message.
or anyway I can grep the message and display to the dashboard?
Can I create a Log Viewer Page or Dashboard with specific filter ?
-
You can try something like this
SELECT
OOL.LogMessageSource.OrionNode.Caption as [Node Name]
, addhour(-5, OOL.DateTime) as [Time]
, OOL.Tags.Name as [tag]
, OOL.Level
,OOL.Message AS [Message]
FROM Orion.OLM.LogEntry OOL
where OOL.Tags.Name='User Logon'or
select
OriNodes.Caption as [Node Name]
, count(OOL.NodeID) as [Number of Hits]
from Orion.OLM.LogEntry OOL
Inner join Orion.Nodes OriNodes ON OOL.NodeID = OriNodes.NodeID
where OOL.DateTime >= ADDHOUR(-1, GETUTCDATE()) AND OOL.Tags.Name='Windows System'
GROUP BY OriNodes.Caption