No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search


To have a better experience, please upgrade your IE browser.


How to display All users that count in FusionAccess' license

Publication Date:  2017-10-19 Views:  1073 Downloads:  0

Issue Description

customer want to show all Detailed User Names that counts in the FusionAccess' license

FusionAccess version:V100R005C20SPC200


l  Login in on the DB ip(HDC account) with putty using gandalf account. 

l  su - gaussdba

l  gsql -d hdcdb -U hdcdbuser // where hdcdb is you DataBase name, replace it with your machine’s DataBase name.

l  Huawei@123
select * from tbl_accounts where licenseflag='t'; // show all used users.( count in the 150 numbers), then you can check which user can be deleted.