Search found 10 matches

by sevensins
16 Mar 2013, 08:54
Forum: Help
Topic: Queus to group to group members with permissions mapping
Replies: 8
Views: 2125

Re: Queus to group to group members with permissions mapping

excellent, support help much appreciated..
by sevensins
15 Mar 2013, 22:08
Forum: Help
Topic: Queus to group to group members with permissions mapping
Replies: 8
Views: 2125

Re: Queus to group to group members with permissions mapping

As I am a novice, would request patience from the gurus

It would be very helpful to have all the users permission in additional columns in the report, the above query does show results but each permission is in a new row for the same user, would much appreciate if anyone could help me out in this.
by sevensins
15 Mar 2013, 15:11
Forum: Help
Topic: Queus to group to group members with permissions mapping
Replies: 8
Views: 2125

Re: Queus to group to group members with permissions mapping

thankyou, actually i have over 50+ master queues and numerous sub queues in them with over 200agents with interlacing permissions, just wanted to have a map of what where and who :D would much appreciate if you could show me how to use the JOIN as I am a novice in sql :D currently im using the below...
by sevensins
15 Mar 2013, 12:41
Forum: Help
Topic: Queus to group to group members with permissions mapping
Replies: 8
Views: 2125

Re: Queus to group to group members with permissions mapping

though i am not a software engg nor a DBA, just went through the otrs database with navicat tool, came up with the following query and it does provide the required result to some extent, would love to have the permissions come as one horizontal rather than a listing but it works :D SELECT DISTINCT q...
by sevensins
15 Mar 2013, 00:26
Forum: Help
Topic: SMSgateway - Compose Reply TO field doesnt accept +
Replies: 5
Views: 2577

Re: SMSgateway - Compose Reply TO field doesnt accept +

Hi!, I used ActiveSMS - IntelliSoftware SMS Gateway pro version, that was for £299(+VAT), the GSM modem was Siemens for around 400$, Ran the sms gateway with its own inbuilt smtp with a subdomain name of my internal windows domain. .e.g. my internal domain abc.com and the subdomain is smsgateway.abc...
by sevensins
15 Mar 2013, 00:03
Forum: Help
Topic: Queus to group to group members with permissions mapping
Replies: 8
Views: 2125

Queus to group to group members with permissions mapping

Hi!,

I am trying to find an sql query to show queue --> Group --> Group members --> permissions

any help would be much appreciated

Rgds


OTRS 3.2.3 :: ITSM 3.2.2 Running on CentOS 5.7
by sevensins
26 Feb 2013, 17:50
Forum: Help
Topic: SMSgateway - Compose Reply TO field doesnt accept +
Replies: 5
Views: 2577

Re: SMSgateway - Compose Reply TO field doesnt accept +

got it working to the time being by disabling

Framework -> Core -> CheckEmailAddresses.

even tough this does create a risk of invalid email addressing ,
by sevensins
26 Feb 2013, 13:01
Forum: Help
Topic: SMSgateway - Compose Reply TO field doesnt accept +
Replies: 5
Views: 2577

Re: SMSgateway - Compose Reply TO field doesnt accept +

have tried but unfortunately the smsgateway is a locked code and doesnot have the functionality.

Please help if there is some restriction at OTRS end that can be removed or changed so that the reply TO can accept +


rgds
by sevensins
26 Feb 2013, 12:28
Forum: Help
Topic: SMSgateway - Compose Reply TO field doesnt accept +
Replies: 5
Views: 2577

SMSgateway - Compose Reply TO field doesnt accept +

Hello, I have a running OTRS setup and recently we have integrated an SMS gateway in our infrastructure. The customer send an sms which is converted into an email and is sent to OTRS. The problem I am facing is that when an agent composes a reply/answer, the TO filed has .e.g +923216345809@smsgatewa...