Exporting User List from V8

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

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

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

Thanks Paul

Hi Shayne,

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

Regards,

Paul

Hi Paul,

We've managed to resolve the issue another way.

Thanks for your help.

Shayne

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