reporting issue User Type in table h_sys_accounts is blank

[samwoo]

Good morning,

When reporting on Users using Platform Configuration -> Reporting or Service Manager -> Reporting, the User Type column is mostly blank except for about 16 users which has a User Type of 0.

It's important that we are able to capture whether a user is a "Basic" user or "User" user, and I can't seem to be able to do that at the moment.

Please can someone have a look. I have attached the report definition file.

Thanks,

Samuel

all-users.report.txt

[Steve Giller]

The h_class field holds the values for Full (1) or Basic (3) Users

[samwoo]

thanks @Steve Giller!