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

How to use SQL to batch update interface caption in db? Orion always overwrite my update!

I have a customer information table, I want use SQL to batch update the interfaces caption to my cusyom name. But when I change the Interfaces table, Orion always overwrite my update with old information in short minutes. Why?

My SQL is follow:

update interfaces
    set InterfaceLastChange = getdate(), LastSync = getdate(),
        caption = ifName+' - '+ibossview.custom+' -',
        interfaceAlias = ibossview.custom,
        fullname = ibossview.nodeName + '-' + ifName+' - '+ibossview.custom+' -'
    from interfaces, ibossview
    where interfaces.interfaceid = ibossview.interfaceID and interfaces.nodeID=94

After I update the table, I can see in the web -> Node detail .But in few minutes it was back with old caption. I check the interfaces table and find it was back!

But when I use orion system manager to change the interface name, It will remain the changed name, not rollback. I check the interfaces table content, find it is like my update. Same table content, deference result!

Why?

Find more posts tagged with

Accepted answers

All comments

mark_wiggans

The SNMP fields in Orion are always updated with each SNMP request that is issued. So the values will always be the last known value set on the devices. Try to create a custom property using the Custom Property editor to insert the interface captions.

cszxc1

In My Question, I said that fact:

" But when I use orion system manager to change the interface name, It will remain the changed name, not rollback. I check the interfaces table content, find it is like my update. Same table content, deference result!"

Use Orion System Manager to change the interface name is OK! And the Table content is like my update that use SQL, How deference about two style?

mark_wiggans

You must shutdown the Orion service while doing the updates & then restart it. See if that helps.

cszxc1

I close all Orion service and use SQL to update the db, But when restart Orion service, all be back too!

I think Orion System Manager DO some additional work when change interface name, Can you tell me what to do?