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

Custom resource for a site specific summary view

We have a need for a new resource for Orion, but I don’t quite have the coding skills to make it happen. If I have an example that’s close, I can generally figure out how to modify it to do what I want, but this one is over my head.

Here’s what I would like to do…

We have a custom property called “DV_Facility” which we populate with the facility code associated with each device. When we get a call that there are “network problems” at a particular facility, we would like to have a “Site View” resource where we can type in the facility code and have it launch a summary view that includes only devices where the value of DV_Facility is equal to the facility code entered. The resource would function much like the “Search for Nodes” resource, whereby text is entered into a text box and if there is only one match, the specified view is launched with a view limitation equivalent to the facility code entered, or if a wildcard is used and there are multiple matches, then a list of candidates is presented, and the view (with limitation) is launched upon selecting one of the matches. The summary view that’s launched would be the same for all facilities, but the trick is to apply a view limitation based on the facility code indicated.

Naturally, we could create a summary view (with view limitation) for each facility, but this is not really a scalable solution when dealing with hundreds of locations.

This is a resource that we would also like to present to our internal customers so that they can quickly and easily obtain info on all devices at a particular facility of interest. For example, we provide monitoring services for a number of our remote facilities, but they have local IT staff that actually has operational responsibility for that location. With a resource such as this, we don't have to manage and maintain summary views for each and every one of these facilities.

I tried running this through SW Support, but they couldn't do anything with it. Does anyone out there have anything like this?

Thanks,
Vic

Find more posts tagged with

Accepted answers

All comments

lucast

Suggestion....

Make a copy of each of the resource module scripts from the Netperfmon/resources/.... directories. Rename them. Modify the ASP code to read in a URL parameter. This parameter would contain the DV_Facility code to look up. Modify the SQL query in each module code to include a WHERE clause looking for the custom property value.

In theory, this would work quite well however I just don't have time at the moment to write it for you. Perhaps when things settle down here, I.e. after we get V8 up and running solidly.

HTH

vhcato

quote:Originally posted by lucast

Suggestion....

Make a copy of each of the resource module scripts from the Netperfmon/resources/.... directories. Rename them. Modify the ASP code to read in a URL parameter. This parameter would contain the DV_Facility code to look up. Modify the SQL query in each module code to include a WHERE clause looking for the custom property value.

In theory, this would work quite well however I just don't have time at the moment to write it for you. Perhaps when things settle down here, I.e. after we get V8 up and running solidly.

HTH

I'm afraid that's a little beyond my coding abilities. I have modified or created new resources when there is an example of something close to what I want, but this is a little beyond me. I might be able to figure it out, but it would take much more time than I can spare at the moment.

Thanks for the input.

vhcato

OK, I'm taking a stab at this. I've gotten far enough that it displays a list of all the facilities matching a wildcard, or launches the summary view for specific facilities, but I'm having trouble with setting the view limitation. I think all I need to do is update the "WhereClaus" field for the limitation associated with this summary view in the database with the target facility code, but I don't really know how to do it, or where to place it.

Here's the reource file:


<!--#include Virtual=/NetPerfMon/scripts/NetPerfMon.asp -->

<% 

	SelectWeb "NetPerfMon"
	VerifyLogin "USER"

	Dim SQLResource
	Dim SearchStr
	Dim Count
	Dim ViewID
	Dim Field

	Field = Request("Field")
	SearchStr = Request("SearchStr")

	Count = 0

	DoStyleSheets
%>

	<table width="100%" border="0" cellpadding="8" cellspacing="0">
	<tr class="ViewHeader">
		<td height="35" align="left" nowrap>
			View Search Results of '<b><%=SearchStr%></b>' within <b><%=Field%></b>
		</td>
	</tr>
	</table>

<%
	SearchStr = Replace(Replace(SearchStr, "*", "%"), "'", "")
	Set SQLResource = NetPerfMon.NewSQLResource
	SQLResource.SQL="Select DV_Facility From Nodes Where [" & NetPerfMon.CleanSQLParam(Field) & "] Like '" & NetPerfMon.CleanSQLParam(SearchStr) & "' Group by DV_Facility "
	SQLResource.Execute


	If SQLResource.EOF Then
		Response.write "<br><font color=red size=2>No facilities were found with ""<b>" & SearchStr & "</b>"" in the <b>" & Field & "</b> Property.<br></font>"
		Response.Write "<br><br><font size=2>Try using wildcards in your search.<br>For Example :<br><br>"
		Response.Write "  Cisco*<br>  10.15.*.*<br>  W?ndows<br>  Server-*<br>  *.SolarWinds.Net </font>"
	End If
%>	

<table border="0" cellPadding="2" cellSpacing="0" width="100%">
<%	Do While Not SQLResource.EOF	%>
<tr>
	<% ViewID = 23 %>
	<td class="Property" nowrap><a href="thwack.solarwinds.com/.../View.asp </td>
	<% If Field <> "Caption" Then %>
	<td class="Property" nowrap><a href="thwack.solarwinds.com/.../View.asp </td>
	<% End If %>
	<td class="Property" width="100%"> </td>
</tr>

<%		
		SQLResource.MoveNext
		Count = Count + 1
	Loop
%>
</table>
<br>
<% if Count = 1 then
		Response.Redirect "/NetPerfMon/View.asp?ViewID=" & ViewID
	End if
%>

Here's the line of code I think I need to insert, but I'm not quite sure where to put it, or if the syntax is correct for inserting the selected text (see the "Field" notation).


SQLResource.SQL="UPDATE Limitations SET WhereClause = '((Nodes.DV_Facility = '(Field)'))' WHERE LimitationID = '49'"

If anyone can help me with it, it would be greatly appreciated.

Thanks,
Vic