Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Has anyone combined a ticket field with a node name and status field.....

Has anyone combined a ticket field with a node name and status field so that a down staus node can have OPS input a ticket number and have that reflected in network summary for all to see?

Such as the figment below ......

-Ron

Find more posts tagged with

advanced_alerts

orion_website_customization

ticket

ticket_comment_node_status

Accepted answers

vhcato

The report includes a status icon, the node name, and the text associated with the custom property. I'm trying to attach a zip file to this message which should have everything you need to make this happen, if you so choose. Within the zip file, you will find a snapshot of what it looks like on the web, a copy of the actual Report Writer file, and a doc file which gives a little more detailed explanation of how it works. Now, let's see if I can attach it...

All comments

dmdc

Wow. What an awesome idea. I've love to know if it is possible.

vhcato

Well... Kinda...

We have a report which shows all nodes that are currently unreachable, and a custom property text field which can be edited by our Ops folks from the Node Details view. This report is included as a resource on the "Home" summary view, and can include ticket numbers, or any other pertinent info. We also created one for interface events, which currently applies to interfaces that are “Down” or “Unknown”, and also interfaces where the average number of receive errors for the last hour exceeds a certain threshold. Is that kinda what you're looking for?

Vic

RonCHenry

I believe that's close to what I'm looking for. Does the resource on the home page correlate with a down node or is it all together a seperate information field?

Thanks

Ron

Network_Guru

I've done something similar - I added a Comments field which can be updated from the Node Details page.
These comments get displayed in the Nodes Down property at the top of the Home page.

Here is the code to add this field to the Down Nodes resource here:

C:\Inetpub\SolarWinds\NetPerfMon\Resources\1-1-SummaryReports\DownNodes.resource:

%>

<table border="0" cellPadding="2" cellSpacing="0" width="100%">

   <tr>
       <td class="ReportHeader" vAlign="center" width="20">Node</td>
       <td class="ReportHeader" vAlign="center"> </td>
       <td class="ReportHeader" vAlign="center">Comments</td>
       <td class="ReportHeader" vAlign="center"> </td>
   </tr>

<%   Do While Not SQLResource.EOF   %>
<tr>
   <td class="Property" vAlign="center" width="20"><%=SQLResource.GetProperty("StatusLED;SmallIcon")%>
</td>
   <td class="Property"><a <%=SQLResource.GetProperty("NodeParamString")%> href="")%>"><%=SQLResource.GetProperty("Caption")%></a>">thwack.solarwinds.com/.../View.asp </td>

   <td class="Property"><a href="")%>"><%=SQLResource.GetProperty("Comments")%></a>">thwack.solarwinds.com/.../View.asp </td>

</tr>

<%

This is what it looks like:

down-nodes_comments.JPG

vhcato

NG beat me to it...

RonCHenry

Bingo Guru! Much thanks to you and Vic!

Network_Guru

Wow - now that's a detailed writeup - nice work Vic!

I would be interested in the code you used to add comments to interfaces as well.
Could you post that as well?

-=Thanks=-

vhcato

I would be interested in the code you used to add comments to interfaces as well.
Could you post that as well?

NG... Sure thing, I'll do my best to put it together within the next few days.

RonCHenry

Gentlemen thank you for the help!!!

I combined the generous information provided above and the results were better then I expected.

Posted below is the full code just save this as "C:\Inetpub\SolarWinds\NetPerfMon\Resources\1-1-SummaryReports\DownNodes.resource:" and remember to backup first...just in case.....

______________________________________________________________________________________________________

<%
Title=Resource.Title
If Len(Title)=0 Then Title="Down Nodes"

SubTitle="The Following Nodes are not Responding"
if Len(Resource.SubTitle)>0 Then SubTitle=Resource.SubTitle
HelpPage="DownNodes"
EditButton="/NetPerfMon/Resources/Filter.Edit.asp?ResourceID=" & Resource.ResourceID & "&ViewID=" & ViewID
DoResourceHeader

Set SQLResource = NetPerfMon.NewSQLResource
SQLResource.SQL="Select * From Nodes Where Status<>'1' Order By Caption"
SQLResource.Filter= Resource.GetProperty("Filter")
SQLResource.Execute
%>

    <tr>
        <td class="ReportHeader" vAlign="center" width="20">Node</td>
        <td class="ReportHeader" vAlign="center"> </td>
<td class="ReportHeader" vAlign="center">Ticket</td>
   <td class="ReportHeader" vAlign="right">Comments</td>
    </tr>

<% Do While Not SQLResource.EOF %>
<tr>
<td class="Property" vAlign="center" width="20"><%=SQLResource.GetProperty("StatusLED;SmallIcon")%> </td>
<td class="Property"><a <%=SQLResource.GetProperty("NodeParamString")%> href="">thwack.solarwinds.com/.../View.asp mce_href="")%>"><%=SQLResource.GetProperty("Caption")%></a>">thwack.solarwinds.com/.../View.asp </td>
<td class="Property"><a href="">thwack.solarwinds.com/.../View.asp mce_href="")%>"><%=SQLResource.GetProperty("Ticket")%></a>">thwack.solarwinds.com/.../View.asp </td>
<td class="Property"><a href="">thwack.solarwinds.com/.../View.asp mce_href="")%>"><%=SQLResource.GetProperty("Comments")%></a>">thwack.solarwinds.com/.../View.asp </td>

</tr>

<%
SQLResource.MoveNext
Loop
%>
</table>
<br>

___________________________________________________________________________________________

This will give you a field that displays which "node is down", the "ticket number" and any "comments" you include from your "Node Details" page! I'll post a pic when I can!

Hopefully this code finds it's way into version 9 I think it would be of great use...

Orion data image

Oh and after the node service is restored, the fields clear out so next time it pops up you will see it needs a ticket number and comments added!

Now if I could just figure out how to handle a bouncing router............

Best Regards All

-Ron

chris.schear

Oh and after the node service is restored, the fields clear out so next time it pops up you will see it needs a ticket number and comments added!

I had implemented a CustomProperty way back in the 7x NPM but eventually removed it because I couldn't figure out how to clear the "ticket/comments" fields after a node came back up. Each time a node went back down, the "old" custom property data was still in the database and it was causing confusion. I might have to give this another go if your process actually clears the information on an UP event!