Has anyone ever used the same “users” table for both alerting and authentication?
In other words, database based authentication creates a table called USERS. Distribution list alerting creates a table called alert_distro_contacts. Has anyone ever combined these into one table? If so, do you have any advice?
I haven’t seen anyone do that as of yet. However, it is possible.
In the alert notification profile, you can specify the “Users” table as the contacts table. You just have to make sure that the columns Id, Name and Email exist in the users table. So, if you let Ignition create the users table make sure you specify the ID column. Then once the table is created manually add the other two columns.
If you do that it should all work.