Exporting User List from V8

Shayne Morris shared this question 2 months ago
Answered

What is the simplest way to export a list of users with the user propities assoated to each user? e.g. Username, Groups, Role, etc

Comments (7)

photo
1

Hi Shayne,

Thanks for getting in touch with support. Can I ask what the purpose is for doing this so I can better understand the question? Are you talking about exporting user properties such as specified in the import columns?

ie.

# First Name, Last Name, Initial, Salutation Code, Language Code, Time Zone Code, Email Address, UserName, Password, Role Code, Job Description, User Status

"Bob", "Jones", "A", "MR", "EN", "", "bob.jones@company.com", "bob.jones@company.com", "password", "YFADMIN","CEO","ACTIVE"

Thanks,

Paul

photo
1

Hi Paul,

Yes those columns, but also Roles, Groups, and Client Org when user Multi Tenancy.

I am trying to clean up an instance and understand what users are in which client orgs.

Thanks,

Shayne

photo
1

Hi Shayne,

We don't have a specific query for this, however the 4 main tables you would need to look at would be iprltshp, ipclass, person and staffmemberrole. You should be able to join these and build the required output.

Please let me know if you need more information.

Regards,

Paul

photo
1

Thanks Paul

photo
1

Hi Shayne,

No problems. Do you need any more help on this one?

Regards,

Paul

photo
1

Hi Paul,

We've managed to resolve the issue another way.

Thanks for your help.

Shayne

photo
1

Hi Shayne

That is great to hear and glad it has been resolved. I will mark this as complete, but if you need further help please get back to me.

Thanks,

Paul