Getting the list of IS users along with last logged-in time
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
Getting the list of IS users along with last logged-in time
Hi Experts,
Is there anyway to get the list of all the Infosphere users along with last access time? I have checked XMETA.USERS_2 but this table has only 2 records - admin and guest
Currently we are having LDAP configured in our Linux servers. We have to send the list of all the users who have not logged in from last 45 days.
Thanks in Advance!!
Is there anyway to get the list of all the Infosphere users along with last access time? I have checked XMETA.USERS_2 but this table has only 2 records - admin and guest
Currently we are having LDAP configured in our Linux servers. We have to send the list of all the users who have not logged in from last 45 days.
Thanks in Advance!!
http://findingjobsindatastage.blogspot.com/
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
Thanks for the information.
I have opened PMR with IBM, will update this post once I receive information from IBM.
Thanks again.
I have opened PMR with IBM, will update this post once I receive information from IBM.
Thanks again.
http://findingjobsindatastage.blogspot.com/
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
Hey Ray,ray.wurlod wrote:There may be something like this in the new operational quality monitoring tool for 9.1.2, but I haven't played with that yet. ...
If you're referring to the new Information Governance Dashboard, then no they don't.
It covers BG, IA in relation to data rules and how they link to BG, and the underlying views also have a little bit of common metadata stuff.
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
Hi Experts,
As per IBM support we can get job level information from DS_AUDIT table and from the ISauditLog_0.log file which Stuart suggested.
But we are looking to get the list of all users logged in to particular project, list of the users last logged in, list of the users based on access level, inactive users etc.
Is this level of information avaialble in Infosphere suite may be in some XMETA table?
So far I have found one table 'XMETA.ASCLModel_xmetagen_Userb1c498ce' which contains information about the user id, but the creation timestamp column has values which are difficult to debug...
For E.g:-
As per IBM support we can get job level information from DS_AUDIT table and from the ISauditLog_0.log file which Stuart suggested.
But we are looking to get the list of all users logged in to particular project, list of the users last logged in, list of the users based on access level, inactive users etc.
Is this level of information avaialble in Infosphere suite may be in some XMETA table?
So far I have found one table 'XMETA.ASCLModel_xmetagen_Userb1c498ce' which contains information about the user id, but the creation timestamp column has values which are difficult to debug...
For E.g:-
Code: Select all
SELECT distinct
A0.XMETA_CREATED_BY_USER_XMETA
,A0.FIRSTNAME_XMETA
,A0.LASTNAME_XMETA
,A0.PRINCIPALID_XMETA
,A0.XMETA_CREATION_TIMESTAMP_XMETA
,A0.XMETAMODIFICATIONTIMESTAMPXMET FROM
ASCLModel_xmetagen_Userb1c498ce A0
XMETA_CREATION_TIMESTAMP_XMETA=1889220711147
XMETAMODIFICATIONTIMESTAMPXMET=1389220682002
http://findingjobsindatastage.blogspot.com/
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
All of the create and mod "date" columns in xmeta are milliseconds since 1970-01-01 00:00:00 UTC.
There are reports under Administration/Security you can do to get currently logged in users or user lists based on roles etc.
It can't just give a complete user dump with groups/roles etc.
You don't have a way to see inactive users (other than coming up with a rule based on last login etc).
Users either don't get used or you delete them out of InfoSphere. There is no active/inactive user flag you set in the admin page, and doing a Delete removes the user record from xmeta.
There are reports under Administration/Security you can do to get currently logged in users or user lists based on roles etc.
It can't just give a complete user dump with groups/roles etc.
You don't have a way to see inactive users (other than coming up with a rule based on last login etc).
Users either don't get used or you delete them out of InfoSphere. There is no active/inactive user flag you set in the admin page, and doing a Delete removes the user record from xmeta.
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
Thanks all for the help!!
So for now we will just load the data from ISauditLog.log into table.
Appreciate your help!!
So for now we will just load the data from ISauditLog.log into table.
Appreciate your help!!
http://findingjobsindatastage.blogspot.com/
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
Theory is when you know all and nothing works. Practice is when all works and nobody knows why. In this case we have put together theory and practice: nothing works. and nobody knows why! (Albert Einstein)
-
- Participant
- Posts: 64
- Joined: Fri Jan 25, 2008 4:41 am
Hi, from this topic its seems like there is no way we can accurately identify active users, but do we have anyway just to list all users, their role and which project they have access too.
We do audit of all users, their roles and access to project. Currently we are retriving the userlist manually but don't know if there is any command to retirve it?
We do audit of all users, their roles and access to project. Currently we are retriving the userlist manually but don't know if there is any command to retirve it?
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne