cancel
Showing results for 
Search instead for 
Did you mean: 

System Usernames Report

pieter_joubert
Explorer
0 Kudos
97

I am trying to create a querie to identify all osers who do not have a System Username (0001) on IT 105.  If I use type 0001 as selection criteria it only creates a list with users who do have a 105 type 0001.

I select users from IT0 and IT2 and then use IT105 but cannot get a list of all users in IT0 who do not have a type0001 in IT105.

Is there a solution without having to create a customised report?

Thanks

Pieter

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Have you tried using Ad Hoc report? Not sure if we can get all the fields you want.

Pramod

Former Member
0 Kudos

Hi

Get a list of perner who has It0105/subtype 0001, then put in exclude list of perner of IT0000. Make sure you have choosen active employement.

This will give you the list for them who has not maintained 0105.

Regards

Ajay

pieter_joubert
Explorer
0 Kudos

Thanks Ajay

This is an option, but the users who need this are not clued up on excel and v-lookups, etc.  They just want one list to be produced to show them the problem users - you know how end users are!