quote:Originally posted by tscaggsI use Kiwi Syslogd and through a little database browsing, you can have it write the traps directly into the Solarwinds Event database. These will show up on the events screen, but alerts are another matter.
quote:Originally posted by pancamoStarted using Kiwi two weeks ago.... I created a new table in the SW database Called KiwiLogs where I send router/unix syslogs, and Windows traps. I also created a few new resources that format the syslogs/traps and display them in the node details view.... works great so far.I also have NetIQ events and NetIQ CPU Charts resources integrated into the Node Details View...Now if I can only get Windows Event Logs into the SW database.... Anyone?dpquote:Originally posted by tscaggsI use Kiwi Syslogd and through a little database browsing, you can have it write the traps directly into the Solarwinds Event database. These will show up on the events screen, but alerts are another matter.
quote:Originally posted by Network_GuruHere is what I'd like to see. Log Kiwi to the Orion database and view only the syslog entries for the device you are viewing in the "Node Details" page. Has anyone found a way to do this?This would be another cool tool to use in troubleshooting a node!One stop shopping is what I am after....-=Cheers=- NG
quote:Originally posted by pancamoYes, I'm going this... I have a custom resource(see below) that reads from the KIWI syslog table and displays it on the "Node Details" page. It displays the last XX syslogs for the node...I also have a win32 app that uses a GRID(see link below) that allows us to quickly display/search/group/sort all the syslogs...works great...www.devexpress.com/.../popup.aspx--------------<!-- Title=KIWI Top 5 Syslogs by Node Name--><!-- Level=7 --><!-- Advanced=FALSE --><!--#include Virtual=/NetPerfMon/scripts/Resource.asp --><%If Node.GetProperty("Node_sub_type") <> "WINDOWS" Then if len(Resource.Title) = 0 then Resource.Title = "SNMP SYSLOGS" Resource.Sync end if Title=Resource.Title SubTitle=Resource.SubTitle EditButton="/NetPerfMon/Resources/NetIQServerEvents.Edit.asp?ResourceID=" & Resource.ResourceID & "&ViewID=" & ViewID & "&NetObject=" & NetObject HelpPage="Node-ResponseTimeLoss" DoResourceHeader maxseverity =Resource.GetProperty("MaxRecords") if maxseverity = "" then maxseverity = 10 end if 'remove FQDN ip = Node.GetProperty("IP_Address") fqdn = Node.GetProperty("DNS") MyPos = InStr(1, fqdn, ".") if (MyPos > 0) then hostname = Left(fqdn,MyPos-1) end if 'or MsgTest Like '%housperf1%' Set cd = CreateObject("ChartDirector.API") SQL="Select Top 10 MsgDateTime, MsgPriority, MsgHostname, MsgInputSource, MsgText " & _ " FROM KiwiSyslog " & _ " WHERE (MsgInputSource <> 'SNMP') and MsgHostAddress = '" & ip & "' " & _ " ORDER BY MsgDateTime DESC" Set rs = CreateObject("ADODB.RecordSet") Call rs.Open(SQL, "DSN=KiwiSolarwinds; USER ID=sa; PASSWORD=XXXXX") Set dbTable1 = cd.DBTable(rs,-1,10) rs.Close() MsgDateTime = dbTable1.getCol(0) MsgPriority = dbTable1.getCol(1) MsgHostname = dbTable1.getCol(2) MsgInputSource = dbTable1.getCol(3) MsgText = dbTable1.getCol(4) DoReport DoFooter%><br><% Sub DoFooter Response.Write("</table>") End Sub%><% Sub DoHeader If Not DidHeader Then %> <table border=0 cellPadding=2 cellSpacing=0 width="100%"> <tr> <td class="ReportHeader">EVENT MESSAGE</td> <td class="ReportHeader">TIME</td> </tr><% DidHeader = TRUE End If End Sub%><% Sub DoReport %><% DoHeader For i = 0 to Ubound(MsgHostname) if (MsgHostname(i) <> "") then %> <td class="Property"><a href="solarwinds.amvescap.com/.../SearchNodes.Action.asp </td> <td class="Property"><a href="solarwinds.amvescap.com/.../SearchNodes.Action.asp </td> </tr><% End If Next End Sub%><% End If %>-----------quote:Originally posted by Network_GuruHere is what I'd like to see. Log Kiwi to the Orion database and view only the syslog entries for the device you are viewing in the "Node Details" page. Has anyone found a way to do this?This would be another cool tool to use in troubleshooting a node!One stop shopping is what I am after....-=Cheers=- NG
quote:Originally posted by francismcphailAny chance of getting a screen dump of what it looks like in Orion?Cheers,Francis.quote:Originally posted by pancamoYes, I'm going this... I have a custom resource(see below) that reads from the KIWI syslog table and displays it on the "Node Details" page. It displays the last XX syslogs for the node...I also have a win32 app that uses a GRID(see link below) that allows us to quickly display/search/group/sort all the syslogs...works great...www.devexpress.com/.../popup.aspx--------------<!-- Title=KIWI Top 5 Syslogs by Node Name--><!-- Level=7 --><!-- Advanced=FALSE --><!--#include Virtual=/NetPerfMon/scripts/Resource.asp --><%If Node.GetProperty("Node_sub_type") <> "WINDOWS" Then if len(Resource.Title) = 0 then Resource.Title = "SNMP SYSLOGS" Resource.Sync end if Title=Resource.Title SubTitle=Resource.SubTitle EditButton="/NetPerfMon/Resources/NetIQServerEvents.Edit.asp?ResourceID=" & Resource.ResourceID & "&ViewID=" & ViewID & "&NetObject=" & NetObject HelpPage="Node-ResponseTimeLoss" DoResourceHeader maxseverity =Resource.GetProperty("MaxRecords") if maxseverity = "" then maxseverity = 10 end if 'remove FQDN ip = Node.GetProperty("IP_Address") fqdn = Node.GetProperty("DNS") MyPos = InStr(1, fqdn, ".") if (MyPos > 0) then hostname = Left(fqdn,MyPos-1) end if 'or MsgTest Like '%housperf1%' Set cd = CreateObject("ChartDirector.API") SQL="Select Top 10 MsgDateTime, MsgPriority, MsgHostname, MsgInputSource, MsgText " & _ " FROM KiwiSyslog " & _ " WHERE (MsgInputSource <> 'SNMP') and MsgHostAddress = '" & ip & "' " & _ " ORDER BY MsgDateTime DESC" Set rs = CreateObject("ADODB.RecordSet") Call rs.Open(SQL, "DSN=KiwiSolarwinds; USER ID=sa; PASSWORD=XXXXX") Set dbTable1 = cd.DBTable(rs,-1,10) rs.Close() MsgDateTime = dbTable1.getCol(0) MsgPriority = dbTable1.getCol(1) MsgHostname = dbTable1.getCol(2) MsgInputSource = dbTable1.getCol(3) MsgText = dbTable1.getCol(4) DoReport DoFooter%><br><% Sub DoFooter Response.Write("</table>") End Sub%><% Sub DoHeader If Not DidHeader Then %> <table border=0 cellPadding=2 cellSpacing=0 width="100%"> <tr> <td class="ReportHeader">EVENT MESSAGE</td> <td class="ReportHeader">TIME</td> </tr><% DidHeader = TRUE End If End Sub%><% Sub DoReport %><% DoHeader For i = 0 to Ubound(MsgHostname) if (MsgHostname(i) <> "") then %> <td class="Property"><a href="solarwinds.amvescap.com/.../SearchNodes.Action.asp </td> <td class="Property"><a href="solarwinds.amvescap.com/.../SearchNodes.Action.asp </td> </tr><% End If Next End Sub%><% End If %>-----------quote:Originally posted by Network_GuruHere is what I'd like to see. Log Kiwi to the Orion database and view only the syslog entries for the device you are viewing in the "Node Details" page. Has anyone found a way to do this?This would be another cool tool to use in troubleshooting a node!One stop shopping is what I am after....-=Cheers=- NG
quote:Originally posted by gallo007Pancamo- You stated "Started using Kiwi two weeks ago.... I created a new table in the SW database Called KiwiLogs where I send router/unix syslogs, and Windows traps. I also created a few new resources that format the syslogs/traps and display them in the node details view.... works great so far."You created a new table and send all syslog information to that table via Kiwi (I got this far...). Can you post an example of a custom resource that would just show the last X events from your table (similar to 81-Last25Events.Resource)?Mike