For more information regarding the security incident at F5, the actions we are taking to address it, and our ongoing efforts to protect our customers, click here.

Forum Discussion

Zdenda's avatar
Zdenda
Icon for Cirrus rankCirrus
Sep 10, 2015

APM local user db mail lookup

Hi, what is the way to read mail as value from local user db? We need it in order to send mail with OTP to users stored in our local user db and nothing like: %{session.localdb.email} works..

 

Thanks Zdenek

 

3 Replies

  • boneyard's avatar
    boneyard
    Icon for MVP rankMVP
    Sep 15, 2015

    tried a couple of things but im unable to get this to work, though I was close via the VPE element Local Database, but those also only give limited access to some variables.

     

    my conclusion is that you can't access the first name, last name and email address. this is kinda weird as they are stored so why not allow access. so perhaps someone else knows how to do this or knows for sure it isn't possible. in any case if you can please open a support case and report back the answer.

     

    a possible (though ugly) work around would be the groups option in the local database, it has been abused for something similar before, see links below.

     

    https://devcentral.f5.com/questions/apm-local-user-database-and-otp

     

    https://devcentral.f5.com/questions/apm-sms-otp-local-user-database

     

  • Fred_Wittenberg's avatar
    Fred_Wittenberg
    Historic F5 Account
    Apr 26, 2018
    While it does not appear you can query the local first/last name or email address of the local user DB (you can see all the variables by dumping a session with sessiondump --sid SESSION_ID). To get around this, I simply used the user email address as the username then used the %{session.logon.last.username} variable. Alternatively, you could use %{session.logon.last.username}@doamin.com if you want to use just the username variable. Either works just fine....