Tracking logins to Datastage

whenry6000 · Post by **whenry6000** » Tue Mar 29, 2011 7:33 am

I'm wondering if there is an easy way to get a daily report of which users have logged into Datastage over the course of a day. Is this information stored anywhere that is easily accessible? Is there any kind of script that a sys admin can use to access this information??
Thnaks!

GJ_Stage · Post by **GJ_Stage** » Tue Mar 29, 2011 7:51 am

Using below command you can get machine name who is loggin in datastage:

netstat -a | grep servername.dsrpc

Sample :

netstat -a | grep UATDS.dsrpc

whenry6000 · Post by **whenry6000** » Tue Mar 29, 2011 8:00 am

Thanks for the response. It seems like that will tell you who is currently logged in, but I was looking for something that could be run nighly and let a sysadmin know who was logged in throughout the course of the day. Is that possible?

jwiles · Post by **jwiles** » Tue Mar 29, 2011 8:56 am

Prior to at least IS 8.1 FP1, there is no true activity logging from which you could extract this info. You would basically need to run a background process which retrieves active sessions at an interval.

From IS 8.1 FP1 and on, I believe, this has been added to some extent (basically "userid logged in at x time") and may be available either through a WAS log or ASBServer/ASBNode log of some sort. I'm not sure what is available within IS 8.5.

I would recommend asking your official support provider for specifics.

Regards,

jwiles · Post by **jwiles** » Tue Mar 29, 2011 12:31 pm

To follow up on this, here is the link describing the additional auditing options that were enabled with IS 8.1 FixPack1:
http://www.ibm.com/support/docview.wss? ... wg21411120

Regards,

PaulVL · Post by **PaulVL** » Wed Mar 30, 2011 6:29 pm

<your WAS install path here>/AppServer/profiles/default/logs $ tail ISauditLog_0.log
==> ISauditLog_0.log <==
Mar 30, 2011 7:20:55 PM com.ibm.is.auditing
INFO: LOGIN (dsheartbeat): UserID="dsheartbeat", Client="Command client", Origin="<snip>", SessionID="08E673AE-FE96-4D7C-86AB-26538BBAF05D"
Mar 30, 2011 7:21:12 PM com.ibm.is.auditing
INFO: LOGOUT (dsheartbeat): UserID="dsheartbeat", Client="Command client", Origin="<snip>", SessionID="08E673AE-FE96-4D7C-86AB-26538BBAF05D"
Mar 30, 2011 7:21:46 PM com.ibm.is.auditing
INFO: LOGOUT (dnguye0): UserID="dnguye0", Client="DataStage Director", Origin="honts2884c", SessionID="EA62493F-3451-45CC-8A8C-C0B3CD81BC67"
Mar 30, 2011 7:21:52 PM com.ibm.is.auditing
INFO: LOGOUT (dnguye0): UserID="dnguye0", Client="DataStage Designer", Origin="honts2884c", SessionID="46490E39-C591-47C2-9170-65C1F973B116"
Mar 30, 2011 7:26:11 PM com.ibm.is.auditing
INFO: LOGOUT (jswasdi): UserID="jswasdi", Client="DataStage Designer", Origin="honts2884h", SessionID="1297D255-948F-4077-AE56-0E799A2781C5"
<your WAS install path here>/AppServer/profiles/default/logs $

You have to enable the tracing. This is part of 8.1 and not present in 8.0.1.