Database view join User and RITM table

[Rutuja K]

Hi,

I want to create a db view to get report of inactive users but their termination catalog item is not submitted in ServiceNow i.e. they don't have associated terminate user RITM.

We have a catalog item to terminate user i.e. to make user inactive. We are looking for users which are made inactive manually instead of using catalog item form.

E.g.: Test12 user is inactive in sys_user table but terminate user RITM is NOT created for this user.

can you please help me with this...

Thank you!

Rutuja.

[Bert_c1]

Here's a start:

Set the desired field to be shown on the list view of the results.

You can add a filter on the results 'usr_active=false. I have no idea what is meant by "user is inactive in sys_user table but terminate user RITM is NOT created for this user".  Seems specific to a requested item. If so add the appropriate filter for that.

[Rutuja K]

Hi Bert, 

Thank you for the response.

We have a catalog item to terminate user i.e. to make user inactive. We are looking for users which are made inactive manually instead of using catalog item form. 

How can we achieve this 

Thank you!

Rutuja.

[Bert_c1]

You ask "We are looking for users which are made inactive manually instead of using catalog item form." How is that done? If users are made in-active via updating the sys_user table, then you could write a business rule for that table. To update any associated sc_req_item records, but that is a separate request here. A database view has been proposed. And what about the specific Request the Requested Items are for?

[Rutuja K]

Hi Bert,

We are trying to find user for whom terminate request is not submitted. They are just made inactive in other system and through daily data load(integration), they are made inactive in sys_user table for ServiceNow.