I am trying to get User ACTIVE and EMAIL ID in company using LDAP.

​@prpogaku Maybe try this for your AD query:

(&(objectCategory=person)
  (objectClass=user)
  (displayName=$rEmployeName{"WEARER NAME"}$)
  (!(userAccountControl:1.2.840.113556.1.4.803:=2))
  (mail=*))

That should return the mail attribute.

Thank you for the response, @Aaron.Gleason. I have tried the provided query and also experimented with some variations. However, the results shown in the message box currently only display the employee name (e.g., “Steve Scot”). I am looking to also retrieve and display the email ID alongside the username in the message box.

Could you please advise or provide an example on how to include both the user status and email ID in the output? Any guidance on how to fetch and display these multiple LDAP attributes properly in Automation 360 would be greatly appreciated.

(&(objectCategory=person)(objectClass=user)(displayName=Steve Scot)(!(userAccountControl:1.2.840.113556.1.4.803:=2))(mail=*))

I am looking for below two things:

1. User status (Which already I'm getting)

2. Email id for the same user( If the user is active in the company).

Thanks again for your help!

​@prpogaku were you able to find a workaround?

Hi ​@prpogaku,

Try the below query once.

(&

  (objectCategory=person)

  (objectClass=user)

  (displayName=$rEmployeName$)

  (userAccountControl=*)

  (!(userAccountControl:1.2.840.113556.1.4.803:=2))

  (|(mail=*)(proxyAddresses=smtp:*))

)

• Use with attributes to return: displayName,mail,proxyAddresses,sAMAccountName,userPrincipalName,userAccountControl.
• Primary email resolution: prefer mail; else parse proxyAddresses and pick the SMTP: entry.