This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Current logged on user in Identity Manager Application

I have a scenario where we need to capture the current logged on users username from Identity Manager Application so that when the user makes a change (System Entitlement UNSAccountBInUNSGroupB) is changed, I can log this into a new Custom table.

How do I grab the current logged on user's username?

0 mekindad over 9 years ago

use

uid_person='%useruid%'
Cancel
Up 0 Down

Cancel
0 smmellac over 8 years ago

uid_person = '%useruid%' is not fetching the current logged in user. Can you please advice?

Thanks
Cancel
Up 0 Down

Cancel
0 aravagg over 8 years ago

Are you capturing the logged in user from the IT Shop? Can you share you complete where clause?
Cancel
Up 0 Down

Cancel
0 smmellac over 8 years ago

Hi aravagg

Below is our SQL. We are trying to capture logged in user on the web portal

select uid_person from person where uid_person='%useruid%'
Cancel
Up 0 Down

Cancel
0 aravagg over 8 years ago

If this is in a component, you can try using a global function GetUser()

something like this:

sqlcompare("uid_person",GetUser(),"string","equal","none")

Do a web designer search for GetUser() which should show you some more examples of how this is used.
Cancel
Up 0 Down

Cancel
0 smmellac over 8 years ago

Thanks aravagg. Worked like a charm
Cancel
Up 0 Down

Cancel