Access Duration

mystuff · Post by **mystuff** » Tue Nov 01, 2011 12:01 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Nov 01, 2011 12:48 pm

Why do you have this need?

qt_ky · Post by **qt_ky** » Tue Nov 01, 2011 6:10 pm

What kind of users?

ray.wurlod · Post by **ray.wurlod** » Tue Nov 01, 2011 9:48 pm

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.

mystuff · Post by **mystuff** » Tue Nov 08, 2011 10:26 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Nov 08, 2011 11:33 pm

UNIX should have recorded when the user ID was created, since this is a security event and these typically are logged. Ask your UNIX administrator.

mystuff · Post by **mystuff** » Wed Nov 09, 2011 3:29 am

Hi Ray,

These users are created on the console and use the credential mapping of a generic datastage user id on unix.

mystuff · Post by **mystuff** » Mon Nov 14, 2011 9:06 pm

Hi Ray,

Can you help me out on this. The users are not created on the server, they are \credential mapped with an existing user id.

How can we do this on both Windows/Unix Server.

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon Nov 14, 2011 11:46 pm

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...

mystuff · Post by **mystuff** » Tue Nov 15, 2011 12:34 am

We are planning to enter the dates (in Title/JobTitle) while creating the user in IIS console.

Is it possible obtain information contained in these fields. So that we can parse relevant dates.

ray.wurlod · Post by **ray.wurlod** » Tue Nov 15, 2011 2:24 pm

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.

qt_ky · Post by **qt_ky** » Tue Nov 15, 2011 2:54 pm

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.