SELECT ROW_NUMBER() OVER(ORDER BY LLD.ID ASC),AT.ID,APP.NAME,APP.APPID,URD.USERROLEDESC,UM.UserBadgeNo,UM.GHRSID,CONVERT(NVARCHAR,LLD.LASTLOGIN),UM.FIRSTNAME, CASE WHEN URD.COUNTRY='ALL' OR URD.COUNTRY='APP' THEN URD.COUNTRY ELSE FCL.COUNTRYDESC
END AS COUNTRY FROM LASTLOGINDETAILS LLD
INNER JOIN ACCESSTABLE AT ON AT.APPID=LLD.APPID AND AT.COUNTRY=LLD.COUNTRY AND AT.USERID=LLD.GHRSID
INNER JOIN APPLICATIONS1 APP ON APP.APPID=AT.APPID
INNER JOIN CONNECTION1 CON ON CON.APPID=APP.APPID AND CON.COUNTRY=AT.COUNTRY
INNER JOIN USERROLEDETAILS URD ON URD.APPID=CON.APPID AND URD.COUNTRY=CON.COUNTRY
INNER JOIN USERMASTER UM ON UM.COUNTRY=URD.COUNTRY AND UM.USERROLE=URD.USERROLECODE
LEFT JOIN FALCONCOUNTRYLIST FCL ON FCL.COUNTRYCODE=UM.COUNTRY
WHERE URD.ISACTIVE='1' AND UM.ISACTIVE='1' AND AT.UPDATEDON >= DATEADD(DAY,-90,CONVERT(date,GETDATE()))