<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="generator" content="HTML Tidy for Windows (vers 25 March 2009), see www.w3.org">
<meta name="Generator" content="MS Exchange Server version 14.03.0162.000">
<title>RE: Managerial reports</title>
</head>
<body>
This isn't necessary as RT search supports relative dates:<br>
https://metacpan.org/pod/Time::ParseDate#Relative-date-formats<br>
<br>
Chris<br>
<br>
<br>
<div><span vlink="#0000ff" link="#0000ff"><font color="#888888" size="2" face="Arial">Christian Loos<br>
Smallworld GIS Operations<br>
_________________________________________________________________________<br>
NETCOLOGNE Gesellschaft für Telekommunikation mbH<br>
Am Coloneum 9 | 50829 Köln<br>
Tel: 0221 2222-276 | Fax: 0221 2222-7276 | Mobil: 0177 8888276<br>
<br>
</font><strong><a href="http://www.netcologne.de/"><font color="#0000ff" size="2" face="Arial">www.netcologne.de</font>
</a></strong><br>
<br>
<table border="0">
<tbody>
<tr>
<th align="left" valign="top" width="80" height="100"><img style="border-left: 0px solid; width: 85px; height: 100px; border-right: 0px solid" id="NetCologneGmbH" title="NetCologneGmbH" border="0" alt="NetCologneGmbH" src="cid:LOGO80.GIF@C9552CF5.0001">
</th>
<th align="left" valign="top" height="100"><font color="#888888" size="1" face="Arial"> Geschäftsführung:<br>
Jost Hermanns<br>
Mario Wilhelm<br>
Vorsitzender des Aufsichtsrates:<br>
Dr. Andreas Cerbe<br>
HRB 25580, AG Köln<br>
</font></th>
</tr>
</tbody>
</table>
<br>
<font color="#888888" size="1" face="Arial">Diese Nachricht (inklusive aller Anhänge) ist vertraulich. Sollten Sie diese Nachricht versehentlich erhalten haben,<br>
bitten wir, den Absender (durch Antwort-E-Mail) hiervon unverzüglich zu informieren und die Nachricht zu löschen.<br>
Die E-Mail darf in diesem Fall weder vervielfältigt noch in anderer Weise verwendet werden.
</font><br>
<br>
<br>
<font color="#888888" size="2" face="Humnst777 BT"></font></span></div>
-----Original Message-----<br>
<b>From: </b>Justin Killen [<a href="mailto:jkillen@allamericanasphalt.com">jkillen@allamericanasphalt.com</a>]<br>
<b>Sent: </b>Wednesday, May 07, 2014 09:42 PM Mitteleuropäische Zeit<br>
<b>To: </b>Loos, Christian; rt-users@lists.bestpractical.com<br>
<b>Subject: </b>RE: Managerial reports<br>
<br>
<!-- Converted from text/plain format -->
<p><font size="2">After thinking about this for a bit, I figured the query is in the database somewhere and it's probably easy enough to update via a script/cron job, so I wrote one (Perl):<br>
<br>
<br>
<br>
<br>
#!/usr/bin/perl<br>
<br>
use strict;<br>
use warnings;<br>
use MIME::Base64;<br>
use DateTime;<br>
use DBI;<br>
<br>
<br>
my $date = DateTime->now();<br>
my $desired_dow = 6;<br>
$date->subtract(days => ($date->day_of_week - $desired_dow) % 7);<br>
<br>
my $to_date_string = $date->ymd;<br>
<br>
$date->subtract(days => 6);<br>
<br>
my $from_date_string = $date->ymd;<br>
<br>
#open(FH, '>', 'attributes.dmp') or die("Unable to open dump file: $!");<br>
#binmode FH;<br>
<br>
my $dbh = DBI->connect("DBI:mysql:database=rt4;", "rt_user", "PASSWORDHERE");<br>
<br>
my $sth = $dbh->prepare("SELECT * FROM Attributes WHERE id = 33");<br>
<br>
my $upSth = $dbh->prepare("UPDATE Attributes SET Content = ? WHERE id = 33");<br>
<br>
$sth->execute;<br>
<br>
while(my $ref = $sth->fetchrow_hashref()) {<br>
my $content = decode_base64($ref->{'Content'});<br>
<br>
# print FH "$content\n\n";<br>
<br>
if($content =~ /(.*Resolved >= ')(\d{1,4}-\d{1,2}-\d{1,2})(' AND Resolved <= ')(\d{1,4}-\d{1,2}-\d{1,2})('.*)/s) {<br>
my ($pre, $date1, $mid, $date2, $post) = ($1, $2, $3, $4, $5);<br>
<br>
if($date1 ne $from_date_string || $date2 ne $to_date_string) {<br>
my $new_content = $pre . $from_date_string . $mid . $to_date_string . $post;<br>
<br>
my $encoded_value = encode_base64($new_content);<br>
<br>
# print FH $encoded_value;<br>
<br>
$upSth->execute($encoded_value);<br>
}<br>
}<br>
}<br>
<br>
close FH;<br>
<br>
<br>
It will update my saved search (id# 33) to always been sun-sat of last week. It'd admittedly a bit of a hack; it would be nice if altering an existing search was an option within the REST API.<br>
<br>
-Justin<br>
> -----Original Message-----<br>
> From: Christian Loos [<a href="mailto:cloos@netcologne.de">mailto:cloos@netcologne.de</a>]<br>
> Sent: Wednesday, May 07, 2014 12:00 AM<br>
> To: Justin Killen; rt-users@lists.bestpractical.com<br>
> Subject: Re: Managerial reports<br>
><br>
> Am 05.05.2014 20:39, schrieb Justin Killen:<br>
> > Often times in IT, issues will come into support staff and resolved<br>
> > without management ever knowing about it. I have been tasked with<br>
> > providing management with a report that would show tickets closed within<br>
> > a certain date range, preferably restricted to a specific user.<br>
> ><br>
> ><br>
> ><br>
> > Are there any existing extensions/reports that would fit this need? I<br>
> > tried Activity Reports, but the Activity Detail report has quite a lot<br>
> > of static in it, and the ticket Title doesn't appear anywhere. I think<br>
> > RTx::Statistics might works as well, but it doesn't seem to be supported<br>
> > within RT 4.2 yet.<br>
> ><br>
> ><br>
> ><br>
> > Any suggestions?<br>
> ><br>
> ><br>
> ><br>
> > -Justin<br>
><br>
><br>
> <a href="http://bestpractical.com/docs/rt/4.2/dashboards.html">http://bestpractical.com/docs/rt/4.2/dashboards.html</a><br>
</font></p>
</body>
</html>