If you created an outer-join form between CTM:People and your AD form, you could run a query or have a table qualification where you have a value from CTM:People but the corresponding value from the AD form is NULL. That would give you all the records that are in CTM:People but not in AD. For example, Let's say that you join the two forms on Remedy Login ID = cn. Then you add something like the lastModifiedDate from AD. If you query that form where lastModifiedDate is NULL, you'll get back all the records that don't have a match in AD. Does that make sense?
Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Shane Buchholz Sent: Friday, May 29, 2009 1:05 PM To: [email protected] Subject: LDAP question ** We are trying to configure Remedy to set the Profile Status to "Obsolete" in the CTM:People form when they have been deleted from Active Directory. The most logical approach is to use an escalation that will fire at regular intervals to keep the CTM:People form as up to date as possible, but the limitations of the workflow seem to make this impossible to do. We are using the inetorgperson form to pull data in from AD, and have an escalation that fires and creates new accounts in the CTM:People form. It recognizes new accounts, but we haven't been able to determine how to have it recognize that an account is no longer in AD. Please let me know if this is even possible, and if so what the best approach is. ARS 7.1 ITSM 7.1 SQL Server 2005 Windows Server 2003 Thanks, Shane Buchholz Information Security Specialist Account Services - Information Services ________________________________ Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
