ad_allusers_v

SELECT 0 AS ad_client_id,

    0 AS ad_org_id,

    ad_user.ad_user_id AS ad_allusers_v_id,

    ad_user.ad_client_id AS ad_allclients_v_id,

    ad_user.isactive,

    ad_user.created,

    ad_user.createdby,

    ad_user.updated,

    ad_user.updatedby,

    ad_user.value,

    ad_user.name,

    ad_user.email,

    ad_user.ldapuser,

    ad_user.description,

    ad_user.datelastlogin,

    ad_user.userpin,

    ad_user.password,

    ad_user.salt,

    ad_user.islocked,

    ad_user.failedlogincount,

    ad_user.datepasswordchanged,

    ad_user.isnopasswordreset,

    ad_user.isexpired,

    ad_user.ad_user_uu AS ad_allusers_v_uu,

    ad_user.issupportuser,

    ad_user.isnoexpire,

    ad_user.dateaccountlocked

   FROM ad_user

  WHERE (ad_user.password IS NOT NULL);