I followed this guide PostgreSQL -Configure ODBC on ISE 2.1 with PostgreSQL - Cisco
I have this set up on Ubuntu and I have pgAdmin4 up and running connected the database as well. What I would like to do is set up groups or tables for mac addresses for devices like printers and other devices so we can store MAC addresses. has anyone else have this setup or something similar. this is only for testing purposes what we have planned is eventually have a database that desktop support can add mac address of devices like printers and other devices through a webpage. We want to keep them out of ISE and not keep sending these requests to be added to the ISE team.
If someone has a more efficient option I would like to hear about it.
Thanks