nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Fun with edit a custom property

Don331

In working with the excellent info from network_guru on the new "edit a custom property" resource, came across something that would be real cool, but I can't figure out how to do it.

Q: How to get this function to edit a normal property - in our case to be able to edit the nodes.caption entries

So in reverse-engineering, since the function knows to edit the custom properties we've added, can the nodes.caption column be tagged as a custom property?? Dunno.

But this would be a super mod, as a lot of users like to modify the node name after it gets loaded up. And if I can do it via the WWW, it keeps the worker bees off the server console!

Any thoughts???

Don Barry
Aegis Mortgage Corp
Houston, TX

Find more posts tagged with

Accepted answers

All comments

Network_Guru

Hey Don, that would be a great help in Managing the devices in Orion.
However, just like in the CPE, you can only edit fields which you have created or listed in the "Add" field, like "Manager's dogs name".
Any field in CPE with the heading in black text is fixed in the DB & cannot be edited directly in CPE. It is either a discovered property, or like the node.caption field, must be edited in the System Manager.
Only the headings in blue text can be edited.

Perhaps V8 will have a web gui to replace the System Manager interface?

-=Cheers=-
NG

Don331

N_G, I agree this would be a home-run if we could do it. I found where the fields list for the console custom property editor are - it's in the program files\Solarwinds\Network Performance Monitor V7\CustomPropertyEditor.cfg file.

Just move the entry
<SystemProperty Table="Nodes" Name="Caption"/>

To be below the <CustomProperties> section.

Don

Don Barry
Aegis Mortgage Corp
Houston, TX

Don331

Figured it out....
You can change the property to edit in the ResourceProperties table in the netperfmon DB.

Basically create a resource with the edit custom properties item, then go to Preview. Then set up the headings, and set the property to edit to one you would never use - for instance SMTPV2.

Then go to the table in enterprise manager, find the corresponding entry, and change the value.

That's all there is to it. Works great!

Oh, FWIW, users using the default GUEST account cannot edit these fields.

Don

Don Barry
Aegis Mortgage Corp
Houston, TX

Network_Guru

Just an FYI,

I just found a bug in the Web update which affects my filtering and views.
When updating certain properties a space is prepended to the text.
The space is treated as a separate character when filtering the property for the Orion Web access permission or Report Writer reports.

The space does not show up on the web update page, but you can see it in the actual CPE on the server. I'll poke around and see if I can figure out where this is coming from.

-=Cheers=-
NG

snowjay

Well I figured out where that space is coming from. It's being inserted via the web editing. If you do a trace on the database you can see when the xxx.Update.asp code is run it updates the field like this in the query:

fieldname=' 1'

instead of

fieldname='1'

That leading space is not allowing me to update my true/false fields since they are of a bit datatype in the database and the leading space is screwing that up.

I'm guessing the update code is in NetPerfMon.asp but its encoded so I can't fix it. Might just have to comment out the SetProperty line in the Update.asp and make my own update query.

iunderwo

I think the problem with the extra space is due to the way IIS handles the input. You need to run a trim on the field to remove any extra spaces. Something like trim(variable) in the code.

// Ian Underwood - Network Engineering
// Boston Stock Exchange

snowjay

I actually fixed the leading space problem for my circumstance.

Here is the background:
I created custom fields for alerting purposes (peoples names, if checked they get alerted) and wanted to be able to update them thru the web interface.

Because I wanted them to be check boxes on the web interface I created 99-EditAlertDetails.Resource which is a copy of 99-EditCustomProperty.Resource and EditAlertDetails.Update.asp which is a copy of EditCustomProperty.Update.asp.

I changed 99-EditAlertDetails.Resource to display custom fields as checkboxes and change the Form action to point to the new EditAlertDetails.Update.asp.

Inside EditAlertDetails.Update.asp the line of code that updates the custom property is:

NetDevice.SetProperty PropertyName, PropertyValue

When checkboxes are set on the web page the value is "on" and I used an IF statement to change that to a 1 or 0 to satisfy the bit field in the database.


       If PropertyValue = "on" then 
		PropertyValue=1
	Else 
		PropertyValue=0
	End if

Even with that code, I was getting leading spaces for my value

' 1' instead of '1'

So it definitely isn't an IIS thing since I'm not even using the value passed from the web page.

Needless to say the database wasn't updating the bit field because of the space.

So I commented out the NetDevice.SetProperty line and added my own SQL Resource.


       Set SQLResource = NetPerfMon.NewSQLResource
	SQL="UPDATE Nodes SET " & PropertyName & "='" & PropertyValue & "' WHERE (NodeID=" & NID & ")"
	SQLResource.SQL=SQL
	SQLResource.Execute

Voila, no more leading spaces and the fields update properly.

I'd be willing to be that the same code could be applied to the EditCustomProperty.Update.asp to eliminate the leading space problem on other fields. I haven't tried it yet, I'm still working my my new alerting mechanism.

Also the field NID you see above is the NodeID that I grab from a hidden field I created on the .Resource file. The usual Node.NodeID didn't work inside the Update.asp so instead I used that to create a hidden field that I can grap the Node ID from. I suppose I could of parsed it from the NetObject value but that seemed like more work than this line of code in the .Resource file.


<input type="hidden" Name="NID" Value="<%=Node.NodeID%>">

martek01

An easy, although not so pretty way, to edit custom properties via the web is to install UTE (Universal Table Editor) in a protected directory on your webserver and allow direct table editing of the custom property fields.

Here's a link to UTE. We use the heck out of it here.

www.codeproject.com/.../ute.asp

Evans Martin

---
Evans L. Martin - IS Analyst
Metro Govt. of Nashville, TN & Davidson County
615.862.4066 Office 615.862.6288 Fax AOL AIM: Martek01

vhcato

Snowjay,

Were you able to get your code to work with "Edit Custom Property"? I've tried it, but can't seem to get it to work. I don't know much about coding, but I did the best I could based on what little I do understand, and I also tried going through SW Support, but didn't get anywhere.

Thanks,
Vic