Jump to content

List of Teams and Users


Recommended Posts

  • 2 weeks later...

Hi @James Ainsworth

I am simply after a report that lists the names and email addresses of all my Full Users (licenced) who can use Service Manager. I can then export and use in comms (now download option available in the users UI). Perhaps I should be able to run to include or exclude the Collaboration users.

I really am struggling can you help please? I used the report above but that tells me all the groups and people in multiple groups appear multiple times. I then tried my own report just running on the h_sys_accounts table but a simple filter by User Type = Active gives no data. But in the UI, the type is specified as User

image.thumb.png.b8a69a183e7db81fc983e52d17d0f645.png

image.thumb.png.d429910a50f38c72835e925af01d513d.png

image.thumb.png.e6cbb3340d7a626cc1a30ff3e0561322.png

Link to comment
Share on other sites

  • 1 month later...

Hey @Berto2002

The Field for user type is actually h_class

It sits under h_sys_accounts,

1 = Full Licence and 3 = Basic.

Very confusing right?, Hope this helps you! you should be able to still use the report that James supplied and just amend it slightly.

H

  • Like 2
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...