# system.device.addDevice bacnet LOCALBACNETDEVICESETTINGSID

**URL:** <https://forum.inductiveautomation.com/t/system-device-adddevice-bacnet-localbacnetdevicesettingsid/48959>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [July 19, 2021, 7:24pm UTC](https://forum.inductiveautomation.com/t/system-device-adddevice-bacnet-localbacnetdevicesettingsid/48959 "2021-07-19T19:24:01Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![cbarker](https://avatars.discourse-cdn.com/v4/letter/c/c6cbf5/32.png) [@cbarker](https://forum.inductiveautomation.com/u/cbarker)\
**Post date:** [July 19, 2021, 7:24pm UTC](https://forum.inductiveautomation.com/t/system-device-adddevice-bacnet-localbacnetdevicesettingsid/48959/1 "2021-07-19T19:24:01Z")

</div>

I am currently trying to make a custom form for populating the bacnet device list. Eventually this will be fed data from another source to churn out a lot of these connections, rather than hand addition.

I am basing this addition off of [this forum post](https://forum.inductiveautomation.com/t/system-device-adddevice-for-bacnet-driver/46584/3) and it works so far. However, the LOCALBACNETDEVICESETTINGSID field is abstract. It seems to be just the index of the list of local devices as seen in the dropdowns, and has no name associated with it.

Is it possible to access the BACNet Local Devices list as a list with names or is the best method of accessing this to use the index numbers only?

---

<div class="post-metadata">

**Author:** ![nicholas.robinson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nicholas.robinson/32/22188_2.png) [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\
**Post date:** [July 19, 2021, 8:16pm UTC](https://forum.inductiveautomation.com/t/system-device-adddevice-bacnet-localbacnetdevicesettingsid/48959/2 "2021-07-19T20:16:38Z")

</div>

Modify your gateway web address to have /web/status/sys.internaldb

From there you can see which integer number is associated with each local connection.

Nick

---

<div class="post-metadata">

**Author:** ![cbarker](https://avatars.discourse-cdn.com/v4/letter/c/c6cbf5/32.png) [@cbarker](https://forum.inductiveautomation.com/u/cbarker)\
**Post date:** [July 20, 2021, 1:31pm UTC](https://forum.inductiveautomation.com/t/system-device-adddevice-bacnet-localbacnetdevicesettingsid/48959/3 "2021-07-20T13:31:25Z")

</div>

Thank you for your help.  
For anyone else that needs this, this address points to a page that allows one to query the internal databases usin SQL. The Table you want to query is BACNETIPLOCALDEVICESETTINGS .

Query String: select \* from BACNETIPLOCALDEVICESETTINGS

---

<div class="post-metadata">

**Author:** ![nicholas.robinson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nicholas.robinson/32/22188_2.png) [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\
**Post date:** [July 20, 2021, 1:55pm UTC](https://forum.inductiveautomation.com/t/system-device-adddevice-bacnet-localbacnetdevicesettingsid/48959/4 "2021-07-20T13:55:15Z")

</div>

One more point, in the original ticket, how we built out 178 devices was to build an external spreadsheet, import it to a dataset, and then loop through it using each line to populate the device creation parameters. It takes a bit of work to gather all data up, but by importing it into ignition as a dataset you then have one concise record for connection parameters.

Nick

---

<div class="post-metadata">

**Author:** ![cbarker](https://avatars.discourse-cdn.com/v4/letter/c/c6cbf5/32.png) [@cbarker](https://forum.inductiveautomation.com/u/cbarker)\
**Post date:** [July 20, 2021, 2:07pm UTC](https://forum.inductiveautomation.com/t/system-device-adddevice-bacnet-localbacnetdevicesettingsid/48959/5 "2021-07-20T14:07:24Z")

</div>

Thank you for this info, that is what we are trying to do.