VSOM local user database

[mcwalter]

Does anyone know where I can get a report of all the users on the local database? The audit log shows who logged in but what I am looking for is just a list of users that are configured on VSOM. We had a customer import 50+ and now they want a list. I looked in the support reports as well but did not find the list. Any ideas?

[Scott Olsen]

I came up with the following for you, in hopes it might provide what you need for some form of local user reporting:

sudo /usr/BWhttpd/vsom_be/db/mysql/bin/mysql --defaults-file=/usr/BWhttpd/vsom_be/db/db.cnf VSOM -e "select * from userinfo;" > local_userinfo.tsv

Careful, it also contains password hashes.  No idea if they are salted or what algo it is... but best to keep private ;-)

Cheers!

[mcwalter]

Thx Scott. You are a wizard my friend.