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?

  • 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

    neomatrix1217_0-1605672064898.png