changing device ID number?

[westsyde]

Is there a way to change a device ID to a different number, for example if I added a device which had a low device ID and then deleted it, could I change another device's ID number to that now unused device ID number?

[ee99ee]

A lot of database queries.... in short, no

-Chris

[BSOD2600]

Why would you ever want to do such a thing anyways?

[westsyde]

I have a bunch of devices that I added that connect via VPN, so when the internet pipe becomes highly utilized I notice that devices with IDs higher than the VPN devices will not get graphed before the poller times out, whereas the ones with a lower ID do get graphed. I know I could delete and re-add the VPN devices but was hoping to make changes to one instead of say, 75-100.

[gandalf]

Yep, that's a known drawback. And there's no general help. Your idea is quite correct and I did so some months ago. I will see to publish my "script" in case I find it ...
R.

[gandalf]

Here is, what I've come up with (old host id =1121, new host id = 4):

Code: Select all

update data_local set data_local.host_id=4 where data_local.host_id=1121;
update graph_local set graph_local.host_id=4 where graph_local.host_id=1121;
update graph_tree_items set graph_tree_items.host_id=4 where graph_tree_items.host_id=1121;
update host set host.id=4 where host.id=1121;
update host_graph set host_graph.host_id=4 where host_graph.host_id=1121;
update host_snmp_cache set host_snmp_cache.host_id=4 where host_snmp_cache.host_id=1121;
update host_snmp_query set host_snmp_query.host_id=4 where host_snmp_query.host_id=1121;
update poller_item set poller_item.host_id=4 where poller_item.host_id=1121;
update poller_reindex set poller_reindex.host_id=4 where poller_reindex.host_id=1121;

This is on your own risk!
R.

[TheWitness]

This scares me....

[westsyde]

Thank you gandalf I will try this out on my lab cacti environment.

[gandalf]

This scares me....

of course. But we need a better "load balancing". Remember discussion at San Jose? But for that, we need timings for polling, IMHO.
spine now accepts a host list, that's fine. But cmd.php doesn't.
But how to "compute" that list without timings?
R.