Search found 11 matches

by pizzadood
27 Sep 2012, 06:04
Forum: Help
Topic: Configitem Performance Issues
Replies: 4
Views: 3031

Re: Configitem Performance Issues

Thank you for the response, CSL! I created a backup of the database just in case and deleted the "ITSM::ConfigItem::Archiv" rows. While the overall performance speed did go noticeably fast, I'm still unsure as to what the consequences in deleting those rows are. At any rate, since you ment...
by pizzadood
25 Sep 2012, 03:35
Forum: Help
Topic: Configitem Performance Issues
Replies: 4
Views: 3031

Re: Configitem Performance Issues

Just a bump. I just want to know if this will have a positive effect on our performance and if it will have repurcussions if we do delete the archived versions in the xml_storage table.
by pizzadood
21 Sep 2012, 05:57
Forum: Help
Topic: Configitem Performance Issues
Replies: 4
Views: 3031

Configitem Performance Issues

Hi, our OTRS system is heavily dependent on the information stored in the CMDB database and our current system has a total of almost 3 million records in the xml_storage table... I just want to ask if this is cause for concern when it comes to system performance since our system is a bit on the slow...
by pizzadood
29 Aug 2012, 06:01
Forum: Help
Topic: BCC Outgoing Notifications(Event) Emails?
Replies: 0
Views: 521

BCC Outgoing Notifications(Event) Emails?

Hi, is it possible in OTRS to bcc all email addresses in the 'RecipientEmail' field of Notificaitons(Event) emails?
by pizzadood
03 Aug 2012, 04:19
Forum: Help
Topic: Ticket Number Problem
Replies: 1
Views: 806

Ticket Number Problem

In our current installation of OTRS, tickets that were created through e-mail seem to use a different number generator from tickets made manually. To explain further, when I create a ticket through the "New Phone Ticket" option, the system generates a ticket number using AutoIncrement.pm. ...
by pizzadood
25 Jun 2012, 08:25
Forum: Help
Topic: Statistics - Duration of a Ticket in one Queue
Replies: 5
Views: 2663

Re: Statistics - Duration of a Ticket in one Queue

Again, thank you Cryhtias for the sample query. Is there anyway to apply this to OTRS' statistics module? Or do I have to use an external reporting tool?
by pizzadood
25 Jun 2012, 06:21
Forum: Help
Topic: Statistics - Duration of a Ticket in one Queue
Replies: 5
Views: 2663

Re: Statistics - Duration of a Ticket in one Queue

Thank you for the response, Cryhtias. The report I'm trying to generate is independent from escalation, I think. To be more specific, I'm looking for a way to generate a report that shows how long tickets stay in one queue regardless if it was moved from another queue or if the ticket was originaly ...
by pizzadood
14 Jun 2012, 08:02
Forum: Help
Topic: Statistics - Duration of a Ticket in one Queue
Replies: 5
Views: 2663

Statistics - Duration of a Ticket in one Queue

Is there any way to calculate how long one ticket stays in one queue? Or more specifically, how long does one ticket remain without a response in one queue.
by pizzadood
17 Apr 2012, 12:51
Forum: Howtos
Topic: Show UserFirstName in Dashlets!
Replies: 6
Views: 21502

Re: Show UserFirstName in Dashlets!

Thanks for the info! I don't know if I'm in the right direction but... can you apply this to values from dynamic fields?
by pizzadood
17 Apr 2012, 12:28
Forum: Help
Topic: Showing Dynamic Field Values in Dashboard
Replies: 2
Views: 1351

Showing Dynamic Field Values in Dashboard

I'm running OTRS 3.1.3 with ITSM installed. Can anyone tell me how to show values from dynamic fields in the agent dashboard along with the ticket number, subject, and time? Thanks in advance.