Skip to Content
0

FIM 10: Jobwise list of users

Jan 31, 2017 at 08:46 AM

55

avatar image

Hi Experts,

As part of access review procedures we need to generate a jobwise list of users from FIM. Going through the user as well as admin manual, there's nothing that has been mentioned in terms of exporting user lists. Could you please help if anybody has had a similar requirement previously? Can such a list be generated?

Regards,

Manas Phadke

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Marc Kuipers
Jan 31, 2017 at 06:16 PM
0

Hello Manas

FIM does not have its own user-table, therefore you won't see an 'export' function

All users are defined in the CMC (BOE) and if a user belongs to one of the four FIM groups (defined in the FIM Admin tool), it is regarded a FIM user.

Perhaps there is an option to export in BOE (with some filter on the user-group)

Marc

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thanks Marc, however the extract from CMC with the FIM groups wouldnt help since we specifically need details of the jobs each user has access to.

Manas

0

You'd have to do this with SQL

SELECT [job_name],[user_name]

FROM [FIM].[dbo].[FIM_JOB_TO_USER]

0