Database Administration (MOSC)

MOSC Banner

how to get the real USERHOST from unified_audit_trail

edited Jul 31, 2025 7:46PM in Database Administration (MOSC) 4 commentsAnswered

Hi all, I would like to check from which application server the connection were, but the result from one of our databases show like below: As you can see the userhost are 'gip-chokidar-deployment-22-9hb86' or ' 202 gip-chokidar-deployment-22-5kh8k' ..just copied a few. Any suggestions how can I get the real application server name ?

select OS_USERNAME,DBUSERNAME,count(*) ,USERHOST
from unified_audit_trail
where DBUSERNAME ='GISROUTER'
group by OS_USERNAME,DBUSERNAME,USERHOST;

S_USERNAM DBUSERNAME COUNT(*) USERHOST

? GISROUTER 193 gip-chokidar-deployment-22-9hb86
? GISROUTER 202 gip-chokidar-deployment-22-5kh8k

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center