how to get the real USERHOST from unified_audit_trail
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