Doug,
If you're on SQL Server, you can try a variant of this:
select
year(dateadd(s, submit_date, '1/1/1970')) AS [Year Created],
month(dateadd(s, submit_date, '1/1/1970')) AS [Month Created],
count(*) AS [Ticket Count]
from hpd_help_desk
where submit_date > datediff(s, '1/1/1970', '1/1/2010')
group by year(dateadd(s, submit_date, '1/1/1970')), month(dateadd(s,
submit_date, '1/1/1970'))
order by 1, 2
Then you can take the monthly counts and average them out...
:-)
Enjoy,
Matt
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Doug Blair
Sent: Thursday, April 28, 2011 8:29 AM
To: [email protected]
Subject: Re: Fun: how big?
**
John,
We upgraded from 7.0 to 7.6 during the time frame specified by your challenge,
and incremented the NEXTID for HPD:HelpDesk by a few millions just to be sure
they would not overlap.
Out of respect for my ARSLIST colleagues I will not do the math, but in this
case you can buy me a beer for judicious use of professional restraint!
Doug
--
Doug Blair
+1 224-558-5462
Sent from my iPad2
Any typographic errors or misspellings are Steve Jobs' fault :-)
On Apr 27, 2011, at 11:15 AM, "Hyunkel v2.0" <[email protected]> wrote:
** Woohooo I got 13174.65
Hugo Ruesga
Software Development Advisor
US 972.577.7000 x 332.3868
MX +52 (33) 3332.3868
P Please consider the environment before printing this email
The information contained in and transferred with this electronic message is
intended only for the recipient(s) designated above, it is protected by law and
it may contain information which is privileged and confidential. If you are not
the intended recipient, please do not read, copy, or use it, and do not
disclose it to others. Please notify the sender of the delivery error by
replying to this message, and then delete it from your system. Thank you.
> Date: Wed, 27 Apr 2011 08:26:37 -0600
> From: [email protected]
> Subject: Fun: how big?
> To: [email protected]
>
> Query your 'main form'
> (incident,change,service-request,custom???)
>
> Query for first ticket created after 1/1/2010 (get the number)
>
> Query for first ticket created after 1/1/2011 (get the number)
>
> Subtract 2nd-1st / 365
>
> Then publish your daily volume.
>
> I am wondering if anybody is over 100,000 daily.
>
> How many > 10,000 daily???
>
> Anybody under 100 daily on the main form?
>
>
> Also - has anybody passed 1billion total in any form???
>
> I will buy a drink at WWRUG for the person/remedy team with the most :)
>
> -John
>
>
> Sent from my iPhone
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
