4 Replies Latest reply on Nov 13, 2018 1:31 PM by mesverrum

    SWCL Log Extract anyone?

    voipdoug

      Has anyone used the SWCL tools to write up a simple log extraction from the SQL database of log events from a device?  What are some of the things others have built. Until there's a log extraction or export to CSV or something Log manager is a pretty Web based tool. I don't want to have to run Kiwi Syslog Daemon underneath all of this and forwarded logs to a different port.

        • Re: SWCL Log Extract anyone?
          mesverrum

          Not sure what you have in mind exactly, but this is the swql query I added to my node details page to display all the messages from that node.

           

          SELECT MessageDateTime, isnull(ms.Caption, ms.IPAddress) as Source, Level, Message

          FROM Orion.OLM.LogEntry le

          join orion.olm.MessageSources ms on ms.MessageSourceID = le.MessageSourceID

          where le.nodeid=${nodeid}

          and messagedatetime > addday(-8, getdate())

          --and message like '%${SEARCH_STRING}%'

           

          order by MessageDateTime desc