cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

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

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?

0 Kudos
1 Reply
Level 16

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 Name]
, 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

neomatrix1217_0-1605672064898.png

 

0 Kudos