Access Duration
Moderators: chulett, rschirm, roy
Access Duration
Hi All,
I need to create a shell script to generate a report on Access Duration of All Users.
Can anyone share their thoughts on this?
Thanks
I need to create a shell script to generate a report on Access Duration of All Users.
Can anyone share their thoughts on this?
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I'm reminded of the old statisticians' joke: "what's the birth rate around here?" "One each."
There is a pretty neat "UniVerse" solution to this, but it does require some advanced skills to get it right. Basically you need to silently intercept the LOGIN and LOGOUT in each project and record the information in some secure fashion, which involves setting up a routine with AUTHORIZATION.
It's all in the UniVerse manuals, and probably in the DataStage BASIC manual, but it's definitely not for the unskilled or faint hearted.
There is a pretty neat "UniVerse" solution to this, but it does require some advanced skills to get it right. Basically you need to silently intercept the LOGIN and LOGOUT in each project and record the information in some secure fashion, which involves setting up a routine with AUTHORIZATION.
It's all in the UniVerse manuals, and probably in the DataStage BASIC manual, but it's definitely not for the unskilled or faint hearted.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi,
At our corporate office, we are maintaining a datastage server for employees to practice.
We have different employees who request for access. But not all use it for practice and our list of employees using datastage server is increasing day by day.
The management wanted to monitor the frequency of use and then come up with a process to remove user ids, which are not required.
In our last discussion, the management has agreed upon a report that just reports on number of days that the since the user id has been created.
Can you please let me know how to extract the number of days since the user id has been created
Thanks
At our corporate office, we are maintaining a datastage server for employees to practice.
We have different employees who request for access. But not all use it for practice and our list of employees using datastage server is increasing day by day.
The management wanted to monitor the frequency of use and then come up with a process to remove user ids, which are not required.
In our last discussion, the management has agreed upon a report that just reports on number of days that the since the user id has been created.
Can you please let me know how to extract the number of days since the user id has been created
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can't (in DataStage), because everyone is logging in as the same user. Login to DataStage uses the credentialled user, not the original user name.
Now, if everyone was credentialled to a different user ID, that would be a different matter...
Now, if everyone was credentialled to a different user ID, that would be a different matter...
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Presumably you can report this information from wherever it's held in the metadata repository. But you're on your own as far as determining where that might be is concerned; the structure of the metadata repository is deliberately undocumented by the vendor.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
The repository is also deliberately left unencrypted by the vendor, which is probably a good thing. About a decade ago I was at a company that used MicroStrategy for BI reporting and they disabled several things we relied on in a new release when they decided to encrypt their repository.
Choose a job you love, and you will never have to work a day in your life. - Confucius