Question concerning CLI-Tools

[ncmbu]

Hi,
I was wondering about the otrs.Console.pl Tools recently. The Tool has some really nice functions, like adding new queues or users, deleting tickets or dumping them.
But what I don't get: How comes, that some of the most simple functions don't exist?
I'm thinking of stuff like:

• Getting a list of the avaiable queues and their status (which group do the belong to...)
• Getting a list of tickets in a specific queue
• Getting the number of open/closed tickets per queue

and so on. Simply speaking: Show information about the current state of the system, which should be the logical step before changing something.

Is there a special reason, that tools like those don't exist? Comparing to the stuff that's there, it should be trivial to implement. But maybe there is some kind of policy...

[wurzel]

Hi,

It is a open source product, feel free to add the functionality to the command


It is not implemented, because no one did it until now.


You can use SQL commands like
SELECT name, group_id FROM queue

And for the other requirements you can use statistic module

Flo

[ncmbu]

It is a open source product, feel free to add the functionality to the command

That's probably what I'm gonna do if I find the spare time to do so...

It is not implemented, because no one did it until now.

Or someone already did and didn't get it implemented to the main release.
That's one of the problems of open source: Everybody has the possibility to contribute, but in too many projects, those kind of additions didn't make it to the people because they have to get approved by a small amount of core developpers.

Code: Select all

You can use SQL commands like 
SELECT name, group_id FROM queue

Working directly on the database is too much of a dirty hack in my opinion.
Besides: It requires to know SQL and the necessary passwords for the database.

[wurzel]

Hi,

Working directly on the database is too much of a dirty hack in my opinion.
Besides: It requires to know SQL and the necessary passwords for the database.

There is a SQL Box in the admin area which allows SELECT queries.


To use the otrs.Console.pl command you need to know Linux/Shell and the parameters
To use SQL you need to know SQL
so there is no difference


That this is a dirty hack, or "not nice" or whatever... yes

Flo