JessicaHolle607440

sql query: which user connects from which host

Discussion created by JessicaHolle607440 on Feb 23, 2016
Latest reply on Feb 24, 2016 by Pete Wirfs
H!
We have automic-users, which are used by more than one person or from more than one server and they use only the callapi.
Is it possible to detect via sql from which host these global users are connected? When I use the systemoverview I see the connected user and from which host they have connected but I can't find a table where these information is stored historical or for the moment

After this problem is solved I want to know, which user started which jobs on day X.

Has anybody an idea?

Best wishes,
Jessica

Outcomes