We have a process where requests are raised for termination of users and based on the workflow of that request a couple of tasks get created. One of those tasks is to remove user extensions. However, not all users will have extensions and so the ask from the stakeholder is to do a check before that task is created.
The list of existing extensions and their users is held in a SQL server inside of our companies network, but it's not kept on ServiceNow table.
So I am trying to resolve this and been having a hard time with this. My idea was to add additional step to the existing workflow so before it creates a task it queries the SQL server for the extensions. If it finds an extension that belongs to the user it creates a task and if it doesn't find it then it just moves on to the next task.
I have found some mentions of JDBC actions but those only seem to work if you have Integration Hub installed? And would that really solve this particular issue? Since the SQL query would change each time depending on user ID
