FIND THE LIST OF USER DETAILS USING SQL @CENTRO

/* FIND THE LIST OF USER DETAILS
LIKE USERNAME, USER_ROLE, USER_ID, USER_EMAIL, USER_LAST_LOGIN_DATE , USER_LOGIN_STATUS etc…
@MID/BU LEVEL */

SELECT
R.NAME AS ROLE,
M.NAME AS BUSINESSUNIT,
E.USERID, E.EMAIL,
E.NAME AS USERNAME,
MELT.LASTLOGINDATE,
CASE WHEN MELT.LOGINFAILURECOUNT > 3 THEN ‘LOCKED OUT’ ELSE ‘ACTIVE’ END AS LOGINSTATUS
FROM SYSTEMDBSERVER.SYSTEMDB.DBO.MEMBEREMPLOYEE E (NOLOCK)
JOIN SYSTEMDBSERVER.SYSTEMDB.DBO.MEMBEREMPLOYEEBUSINESSUNIT B (NOLOCK) ON E.EMPLOYEEID = B.EMPLOYEEID
JOIN ROLEUSER RU (NOLOCK) ON RU.USERID = E.EMPLOYEEID
JOIN ROLE R (NOLOCK) ON R.ROLEID = RU.ROLEID
JOIN SYSTEMDBSERVER.SYSTEMDB.DBO.MEMBERS M (NOLOCK) ON B.BUSINESSUNITID = M.MEMBERID
JOIN SYSTEMDBSERVER.SYSTEMDB.DBO.MEMBEREMPLOYEELOGINTRACKING MELT (NOLOCK) ON E.EMPLOYEEID = MELT.EMPLOYEEID
WHERE M.MEMBERID = XXXXX /* NEED TO PASS MID */

/* ALL USER DETAILS @USER LEVEL ONLY “BU/MID” */

SELECT
E.USERID,
E.EMAIL,
E.NAME AS USERNAME,
*
FROM SYSTEMDBSERVER.SYSTEMDB.DBO.MEMBEREMPLOYEE E (NOLOCK)