To Identify List of Inactive Users who are not involved in IDS Case records

[Thej1]

HI,

The requirement is to find how many inactive not LDAP users are not involved in Case records. 

Five fields we have considered in IDS Case Table :

1. contact
2. opened_by
3. resolved_by
4. closed_by
5. sys_created_by

Please provide me with the solution and suggestions.

@Kieran Anson @Amit98 @Ankur Bawiskar @SANDEEP28 

[Ankur Bawiskar]

@Thej1 

So you want to know which users are not present in those 5 fields and out of those which one are inactive?

[Thej1]

Hi ankur,

we want to know the inactive users from the user table, who are not involved in these 5 fileds of IDS case table.

Thanks

Thej

[Ankur Bawiskar]

@Thej1 

you can use database view and join sys_user with case table

[Thej1]

Hi @Ankur Bawiskar ,

I didn't get it exactly. Could you please let me know in detail ?

Thanks