Query to fetch Inactive users

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.