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]

I can't comment on any integration results, you'll need to provide more details and then others here with that experience can assist you.