how to retrieve users list in hana studio for active user and inactive users?

[former_member182921]

Hi SAP Experts ,

how to retrieve users list in hana studio for active user and inactive users?

Regards,

Abhi

[vivekbhoj]

Hi Abhishek,

Check USERS View and there you can check if user is deactivated or not in the USER_DEACTIVATED column and can also check LAST_SUCCESSFUL_CONNECT column to check when the user last logged in

SELECT * FROM "PUBLIC"."USERS"

Regards,

Vivek

[former_member182921]

Thanks Vivek Can we export this to excel .

Regards,

Abhi

[former_member256353]

Mark that empty box in the upper left corner with a right click and select "export result".

Then specify in what fileformat you want to save it and where...

[abhishek_singh11]

Hi,

Check: http://sapbw.optimieren.de/hana/hana/html/_u_s_e_r_s.html