Is there anyway of changing all my access switch interfaces to be Unplugged rather than down?
Ideally I don;t want to have to select every interface on every switch and then edit properties to make the change.
Thanks
Jon
UPDATE Interfaces SET UnPluggable=1 WHERE NodeID in (SELECT NodeId FROM Nodes WHERE Device_Type='Access')
If you are able to identify interfaces in database with WHERE condition, you can run query
UPDATE Interfaces SET UnPluggable=1 WHERE <your condition>
State will be changed to Unplugged with next poll.
That's exactly what I'm looking for, I'm not particularly good with SQL so wondered if you could help out a little further.
I have a custom property on all our monitored devices that is called Device_Type so how would I continue the statement above using Device_Type = Access to identify the switches?
Device_Type is custom property on nodes and you want to set all interfaces on nodes with Device_Type='Access' to UnPlugged, right?
That's correct.
