Print all user

Moderator: crythias

Locked
kajeflento
Znuny newbie
Posts: 37
Joined: 19 Sep 2011, 10:09
Znuny Version: 3.0
Real Name: Kwizera Jean Florent
Company: MINECOFIN

Print all user

Post by kajeflento »

Hi dears,

I would like to print out a list of all customers, is it possible? if yes how? because i want to give my boss a list of all customers and writing all customers seems to be a big problem. plz if possible i need your help!

Kind Regards,
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Print all user

Post by jojo »

use the SQL Box
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
kajeflento
Znuny newbie
Posts: 37
Joined: 19 Sep 2011, 10:09
Znuny Version: 3.0
Real Name: Kwizera Jean Florent
Company: MINECOFIN

Re: Print all user

Post by kajeflento »

jojo wrote:use the SQL Box
Please Jojo can u help me more? i know it is mysql query but, i still ignore the name of table and fields, could you plz suggest me a querry i can use?
Thx a lot for ur help!
regards,
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Print all user

Post by crythias »

Try removing the limit entry in SQL Box, then
show tables

hmm... there's a table called users and a table called customer_user
we can
describe customer_user
or
describe users

ah... fields!
Select this_field, that_field from the_table
use csv instead of html...
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
kajeflento
Znuny newbie
Posts: 37
Joined: 19 Sep 2011, 10:09
Znuny Version: 3.0
Real Name: Kwizera Jean Florent
Company: MINECOFIN

Re: Print all user

Post by kajeflento »

crythias wrote:Try removing the limit entry in SQL Box, then
show tables

hmm... there's a table called users and a table called customer_user
we can
describe customer_user
or
describe users

ah... fields!
Select this_field, that_field from the_table
use csv instead of html...

Hahaha Crythias,
Thx a lot for ur guidance but i'm trying and i can't find the result, have you tried and see if it works? for me i'm stuck it doesn't i don't know why! could you plz tell me more if possible? some query give " no result found " others give error messages, plz give me the one u tried and see if i can get them.
I appreciate ur work, and the way u're always there for us, thx a lot!

Regards,
kajeflento
Znuny newbie
Posts: 37
Joined: 19 Sep 2011, 10:09
Znuny Version: 3.0
Real Name: Kwizera Jean Florent
Company: MINECOFIN

Re: Print all user

Post by kajeflento »

Wow thx a lot, i've found it!
:D
Locked