Exporting SysLogs shouldn't require DB Access

Ideally, anybody with Solarwinds access to the Syslogs should be able to export the syslogs they are interested in. This should be able to done via CSV or TEXT document or whatever - we shouldn't need to copy/paste from the syslogs to a document.

Can we please get an export function in the UI for Syslogs / Traps / Events?

Find more posts tagged with

traps

syslog

idea

npm

Events

Accepted answers

All comments

adam.beedell

You can query this with SWQL kinda but it's a good point. Should put it in the feature request section before someone else says so too

mbutler756

Thanks, Adam - I was looking for it the other day and couldn't find it easily - I posted it there for voting: thwack.solarwinds.com/.../export-functionality-for-syslogs-traps-events

bobmarley

Until a feature is release you could use a powershell script. This will pull out the Top 1000 syslogs and save it to a .CSV file on your machine. Review the notes as you need to put your server name in as well as adjust the path for your environment. You can change the results by changing the query within the script.

cls
cd c:\powershellscripts #Adjust the patch here and below where the file is written out according to your environment
Import-Module -Name SwisPowerShell
Add-PSSnapin SwisSnapin 
$swis = Connect-Swis -host YOURORIONSERVER -Trusted # Put the proper Orion servername in this line
$query = "

    SELECT top 1000
e.LogMessageSource.Caption AS [DisplayName],
e.DateTime AS [ObservationTimeStamp],
e.InstanceSiteId AS [InstanceSiteID]
FROM Orion.OLM.LogEntry e

"

$rows = Get-SwisData -SwisConnection $swis -Query $query
$rows | Export-CSV -Path "C:\PowershellScripts\Syslogs.csv" -NoTypeInformation #Adjust the file path to your environment