Query Active Directory from Ignition

Is there any way to query Active Directory from Ignition? I would like to use a unique identifier to reference users from an AD/internal user source, like an Active Directory SID, and avoid complications if users have the same name
e.g. a user, John Smith, leaves the company and a new John Smith is hired but reference to either of them in reports, etc. must be discernable.

1 Like

I connected to our AD instance as a Linked server in MS SQL Server. I have a few stored procedures or table value functions that fetch the data I need.

1 Like

Thank's @zacht, It seems like that would work. Unfortunately it also seems that SQL Server on Linux does not support linked servers to platforms other than SQL Server and our server is, in fact, on Linux.

https://stackoverflow.com/questions/58883835/microsoft-sql-server-management-studio-cant-select-other-data-source-when-ad
More info on this here ^