You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query to fetch Inactive users

Received Response
30
Views
5
Comments
edited Jul 3, 2020 11:12AM in Sales 5 comments

Summary

Query to fetch Inactive users

Content

Hi all,

We are using the below Query to fetch the inactive users but we couldn't.

SELECT 
       jrrp.person_name,
       pu.username,
       pu.active_flag,
       jrrmv.role_id,
       jrrmv.role_name,
       JRRP_Parent.person_name Reports_To
FROM jtf_rs_resource_profiles JRRP,
     hz_parties HP,
     per_users PU,
     JTF_RS_REP_MANAGERS_V JRRMV,
     jtf_rs_resource_profiles JRRP_parent
where     PU.user_guid  =  HP.user_guid
      AND HP.party_id = JRRP.party_id
      and JRRP.party_id = JRRMV.resource_id

 

Can you please help us how to get inactive users in sales cloud.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!