SQL user import issue - export user list?

[Joe]

Hi,

How do I get a list of Customers out of the system?

We use SQL user import utility to populate customers in Service Manager but are sorting a problem with some missing. We have a fix but need to compare source data with users in Service Manager. How do I get a list of Customers out of the system? I can't see anything in Admin. Thanks!

[SamS]

Hi @Joe,

Please have a look at https://github.com/hornbill/goHornbillDataExport and specifically at the skipdb option

[SamS]

that was assuming you ( @Joe ) wanted to automate something - a simple report would do the trick as well.

[Joe]

Hi, thanks for the response, No it was not automation, just a check. Simple report sounds great but I'm not a DBA so was looking for something in the Admin pages to pass on to our DBA.

 

[James Ainsworth]

Hi Joe,

When you say "Customers" are these contacts or users that you are looking for?

For contacts there is an export option on the main contact list.

  

[Joe]

Hi, Apologies if I'm not using the right lingo. I'm referring to users - All as they appear in Admin and under the "Coworkers" search for All. Not contacts.