none
using IIF function for DN logic RRS feed

  • Question

  • Dear All,

    how to use IIF function for the below requirement. 

    requirement: if "location = location1 and department = department1 "the output value should be OU=department1,OU=location1,DC=domain,DC=com

    thanks in advance.

    shashidhar






    • Edited by Shashidhar J Wednesday, October 23, 2019 9:01 AM
    Tuesday, October 22, 2019 7:47 AM

Answers

  • Hi,

    Just off the top of my head, but:

    IIF(Eq(location,"location1"),IIF(Eq(department,"IT"),"OU=Department,OU=location1,DC=domain,DC=com",Null()),Null())

    Br,

    Leo


    Did my post help? Please use "Mark as answer" or "Propose as answer". Thank you!

    • Proposed as answer by Leo Erlandsson Wednesday, October 23, 2019 9:13 AM
    • Marked as answer by Shashidhar J Thursday, October 31, 2019 7:52 AM
    Tuesday, October 22, 2019 2:44 PM

All replies

  • Hi,

    Just off the top of my head, but:

    IIF(Eq(location,"location1"),IIF(Eq(department,"IT"),"OU=Department,OU=location1,DC=domain,DC=com",Null()),Null())

    Br,

    Leo


    Did my post help? Please use "Mark as answer" or "Propose as answer". Thank you!

    • Proposed as answer by Leo Erlandsson Wednesday, October 23, 2019 9:13 AM
    • Marked as answer by Shashidhar J Thursday, October 31, 2019 7:52 AM
    Tuesday, October 22, 2019 2:44 PM
  • Hi Leo,

    Thanks for the reply. :)


    Wednesday, October 23, 2019 8:57 AM