User Export

[BobbyB]

Hello, I have searched but can't see a way to export a list of all my Users on our system.  Is there a straight forward way?  I currently use a report but find I'm missing some accounts and as the User accounts have a cost implication I'd like to see exactly who all my User accounts are.

 

Thank you,

Bobby

@Alisha

[Sam P]

This report will show all Users utility---hornbill-service-manager-subscriptions.report.txt (check the filter in case it doesn't meet your criteria)

[Bob Dickinson]

Hi @BobbyB

The reporting would only miss accounts if you have filtering applied. If you wanted to get a full list of every single account in Hornbill, you can create a report against the h_sys_accounts table with no filtering (keep in mind there may be a limit on the number of results returned based on your system settings)

Kind Regards

Bob

[BobbyB]

Thanks @Sam P and @Bob Dickinson,

 

So the report just using the h_sys_accounts does work but for me to distinguish between us (IT) and our Business side I need to also include the account Department.  Now I believe you may have helped with this in the past Bob, with my tables setup as this:

But the issue I get with this is multiple entries for a User as it is listing all of their roles.

This filtering works on just the h_sys_accounts_roles, now just need to get the department displayed.

Thanks,

Bobby

[Bob Dickinson]

Hi @BobbyB Could you export your report definition and send it to me or post it here? I'll take a look for you

[BobbyB]

Thanks @Bob Dickinson, I've emailed over the report definition.

[Bob Dickinson]

Hi @BobbyB

I'm not sure where or what that table was originally used for (especially if I created it years ago! ) but it doesn't really work for your requirement - so I have amended it and hopefully, the attached meets your criteria:
 

it---service-desk---hornbill---users-grouped-by-department.report.txt

A few points:

• This will only show a user that has an associated Department. If they don't have a Department, they won't show on the report
• If for whatever reason a user has 2 (or more) Departments associated to them, they would appear twice on the report

 

I've also attached another report that you can upload - which shows you if there are any users on your instance that don't have an associated department. You can then troubleshoot accordingly:

users---all-users---no-department-assigned.report.txt

 

Is this what you need?

Kind Regards

Bob

[BobbyB]

Thanks @Bob Dickinson, as soon as I can get back into Hornbill (it's currently down for us) I'll have a look at both of those reports.

[JanS2000]

Morning @Sam P @Bob Dickinson and @BobbyB these reports would be useful to me as well, thanks! I've downloaded them (I hope that's okay!), but how do import them back to Hornbill? I get an error when I try to just upload the downloaded txt files.

[Steve Giller]

22 minutes ago, JanS2000 said:

I get an error when I try to just upload the downloaded txt files.

What is the error?

[JanS2000]

Hi @Steve Giller, I get the error below:

[Sam P]

@JanS2000 start a new report and then select the upload button here:

[JanS2000]

Ah, thank you @Sam P!