Automate finding missing network devices sysobjectOIDs based on discovery data.

[Patrick DeCarl1]

Solution Overview

Automate finding missing network devices sysobjectOIDs based on discovery data. ServiceNow doesn't track all network network devices OIDs in the SNMP OID OOTB. So during discovery projects you might be asked to find/update the missing OIDs for network devices. 

---

Detailed Description

Script below will review network devices data for the sysobjectoid of the network devices that has no manufacturer and it was created/updated via discovery. For a large client this might be over 8000 records but you really only need to update SNMP OID table with 5 to cover all missing OIDs. In the past you might review one at a time. Now you can do it all within minutes. The script not only finds the sysobjectoid but will output the missing 

---

Solution

Script to run in background or fixed script. (attached as well). You can take output and import into excel to create pivot table if needed (attached).

See attached file for script.