solarwinds  |  thwack
in
Search 44,780 posts and 623 resources contributed by 21,551 members or post a topic.

Already Joined? Sign in
Has anyone combined a ticket field with a node name and status field.....

rated by 0 users
Answered (Verified) This post has 2 verified answers | 49 Replies | 10 Followers


25 Posts
Points 69
RonCHenry posted on 06-21-2007 2:11 PM
rated by 0 users

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

We may be human but we're still animals!
  • Filed under:
  • | Post Points: 5

Answered (Verified) Verified Answers


1,386 Posts
Points 3,034
Answered (Verified) Network_Guru replied on 06-22-2007 9:49 AM
rated by 0 users

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">&nbsp;</td>
        <td class="ReportHeader" vAlign="center">Comments</td>
        <td class="ReportHeader" vAlign="center">&nbsp;</td>
    </tr>

<%    Do While Not SQLResource.EOF    %>
<tr>
    <td class="Property" vAlign="center" width="20"><%=SQLResource.GetProperty("StatusLED;SmallIcon")%>&nbsp;
</td>
    <td class="Property"><a <%=SQLResource.GetProperty("NodeParamString")%>  href="/NetPerfMon/View.asp?View=NodeDetails&NetObject=N:<%=SQLResource.GetProperty("NodeID")%>"><%=SQLResource.GetProperty("Caption")%></a>&nbsp;</td>

    <td class="Property"><a href="/NetPerfMon/View.asp?View=NodeDetails&NetObject=N:<%=SQLResource.GetProperty("NodeID")%>"><%=SQLResource.GetProperty("Comments")%></a>&nbsp;</td>

</tr>

<%        

This is what it looks like:
 


-=Cheers=-
NG

---Orion V8.1 SLX, SLX secondary poller, SQL2005 x64 SE, 14GB Ram, 12k+ elements and counting---
---Orion V9.1 SP2 SL2000, SQL2005 Express 866 elements and counting---

  • | Post Points: 8

415 Posts
Points 2,023
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... :)

Vic Cato
Technical Lead - Network Operations
Koch Business Solutions - Enterprise Technical Services

  • | Post Points: 3

All Replies


24 Posts
Points 53
dmdc replied on 06-21-2007 4:02 PM
rated by 0 users

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

  • | Post Points: 1

415 Posts
Points 2,023
vhcato replied on 06-21-2007 8:17 PM
rated by 0 users

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

Vic Cato
Technical Lead - Network Operations
Koch Business Solutions - Enterprise Technical Services

  • | Post Points: 3

25 Posts
Points 69
RonCHenry replied on 06-22-2007 8:28 AM
rated by 0 users

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

We may be human but we're still animals!
  • | Post Points: 5

1,386 Posts
Points 3,034
Answered (Verified) Network_Guru replied on 06-22-2007 9:49 AM
rated by 0 users

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">&nbsp;</td>
        <td class="ReportHeader" vAlign="center">Comments</td>
        <td class="ReportHeader" vAlign="center">&nbsp;</td>
    </tr>

<%    Do While Not SQLResource.EOF    %>
<tr>
    <td class="Property" vAlign="center" width="20"><%=SQLResource.GetProperty("StatusLED;SmallIcon")%>&nbsp;
</td>
    <td class="Property"><a <%=SQLResource.GetProperty("NodeParamString")%>  href="/NetPerfMon/View.asp?View=NodeDetails&NetObject=N:<%=SQLResource.GetProperty("NodeID")%>"><%=SQLResource.GetProperty("Caption")%></a>&nbsp;</td>

    <td class="Property"><a href="/NetPerfMon/View.asp?View=NodeDetails&NetObject=N:<%=SQLResource.GetProperty("NodeID")%>"><%=SQLResource.GetProperty("Comments")%></a>&nbsp;</td>

</tr>

<%        

This is what it looks like:
 


-=Cheers=-
NG

---Orion V8.1 SLX, SLX secondary poller, SQL2005 x64 SE, 14GB Ram, 12k+ elements and counting---
---Orion V9.1 SP2 SL2000, SQL2005 Express 866 elements and counting---

  • | Post Points: 8

415 Posts
Points 2,023
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... :)

Vic Cato
Technical Lead - Network Operations
Koch Business Solutions - Enterprise Technical Services

  • | Post Points: 3

415 Posts
Points 2,023
vhcato replied on 06-22-2007 10:56 AM
NG beat me to it... :(

Vic Cato
Technical Lead - Network Operations
Koch Business Solutions - Enterprise Technical Services

  • | Post Points: 3

25 Posts
Points 69
RonCHenry replied on 06-22-2007 1:39 PM
rated by 0 users

Extremely useful information Vic!  Thank you for the detail and time in your response!

We may be human but we're still animals!
  • | Post Points: 1

25 Posts
Points 69
RonCHenry replied on 06-22-2007 1:41 PM
rated by 0 users

Bingo Guru!  Much thanks to you and Vic!   

 

We may be human but we're still animals!
  • | Post Points: 3

178 Posts
Points 434
torrielw replied on 06-22-2007 1:53 PM
rated by 0 users

My teams will be very happy to see they can finally update the web......THANKS MUCH!!!

  • | Post Points: 1

1,386 Posts
Points 3,034
Network_Guru replied on 06-23-2007 11:25 AM
rated by 0 users

 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=- 

-=Cheers=-
NG

---Orion V8.1 SLX, SLX secondary poller, SQL2005 x64 SE, 14GB Ram, 12k+ elements and counting---
---Orion V9.1 SP2 SL2000, SQL2005 Express 866 elements and counting---

  • | Post Points: 3

415 Posts
Points 2,023
vhcato replied on 06-24-2007 6:18 PM
rated by 0 users
Network_Guru:

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.

Vic Cato
Technical Lead - Network Operations
Koch Business Solutions - Enterprise Technical Services

  • | Post Points: 3

25 Posts
Points 69
RonCHenry replied on 06-24-2007 8:52 PM
rated by 0 users

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=Down Nodes -->
<!-- Level=7 -->
<!--#include Virtual=/NetPerfMon/scripts/Resource.asp -->
<%
 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
%>

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

    <tr>
        <td class="ReportHeader" vAlign="center" width="20">Node</td>
        <td class="ReportHeader" vAlign="center">&nbsp;</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")%>&nbsp;</td>
 <td class="Property"><a <%=SQLResource.GetProperty("NodeParamString")%>  href="/NetPerfMon/View.asp?View=NodeDetails&NetObject=N:<%=SQLResource.GetProperty(" mce_href="/NetPerfMon/View.asp?View=NodeDetails&NetObject=N:<%=SQLResource.GetProperty("NodeID")%>"><%=SQLResource.GetProperty("Caption")%></a>&nbsp;</td>
 <td class="Property"><a href="/NetPerfMon/View.asp?View=NodeDetails&NetObject=N:<%=SQLResource.GetProperty(" mce_href="/NetPerfMon/View.asp?View=NodeDetails&NetObject=N:<%=SQLResource.GetProperty("NodeID")%>"><%=SQLResource.GetProperty("Ticket")%></a>&nbsp;</td>
 <td class="Property"><a href="/NetPerfMon/View.asp?View=NodeDetails&NetObject=N:<%=SQLResource.GetProperty(" mce_href="/NetPerfMon/View.asp?View=NodeDetails&NetObject=N:<%=SQLResource.GetProperty("NodeID")%>"><%=SQLResource.GetProperty("Comments")%></a>&nbsp;</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 

 

 

 

 

 

We may be human but we're still animals!

415 Posts
Points 2,023