FIM 10: Jobwise list of users

[phadke_manas]

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

[Marc_Kuipers · Accepted solution]

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

[phadke_manas · Accepted solution]

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

[Marc_Kuipers · Accepted solution]

You'd have to do this with SQL

SELECT [job_name],[user_name]

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