Can I create a Log Viewer Page or Dashboard with specific filter ?

alexsiu

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?

neomatrix1217

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