cancel
Showing results for 
Search instead for 
Did you mean: 

FIM job users matrix

Olj
Participant
0 Kudos

Hi Dear Experts,

We have many jobs in SAP FIM 10, and these jobs has many users (executed).

Now we need to make a matrix of users with available jobs, example:

May be some 'select' from database or something else?

Thanks...

Accepted Solutions (1)

Accepted Solutions (1)

Marc_Kuipers
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Daulet

Something like this

select distinct(USER_NAME), job_name

from FIM_JOB_RUN_STATUS

Marc

Olj
Participant
0 Kudos

Hi Marc,

thanks for answer,

but you 'select' is not working if example user does not never run job, but have permissions to run this job.

I think that table FIM_JOB_RUN_STATUS is showing only launched jobs.

Marc_Kuipers
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Daulet,

The users who can run the jobs can be retrieved by this:

SELECT [job_name]

      ,[user_name]

FROM [FIM_JOB_TO_USER]

WHERE [job_name] = 'ABCD'

Note: it will list all the users you have added to the job (see below) + all FIM administrator users (who implicitly have this right)

Marc

Olj
Participant
0 Kudos

Thank you very much Marc!

Answers (0)