Hello everyone,
So I have a fun one... As part of my current project, I need to write a query to check if a particular attribute is not assigned. Not NULL, but not a part of the IDM entry (as in an attribute that was once populated and was removed via {D})
So in essence, I want to see all entries (MX_PERSON to be exact) that do not have a given attribute(s). In my case it's MX_FIRSTNAME, MX_LASTNAME, and DISPLAYNAME. We have a process that's blanking those out, causing some issues so we need to go find and fix them.
If someone has a better way of considering this problem, I'm open to that too! 😊
I'm running this project on Oracle, but if you come up with something in MS SQL, hopefully I can work with it.
Thanks for your help!
Cheers,
Matt