Kaiser,
I am new to SQL Server 2005. The dates saved in the tables are in the
UNIX format I believe and it only gives the number of seconds elapsed
since 1 Jan 1970 midnight (pls correct me if I'm wrong). So let's say I
want to execute the following
('Create Date:' >= ($TIMESTAMP$ - 2*60*60)) AND (('Create Date:' - 3600)
> 'Date Received'
How do I go about doing it? Any conversion functions to check the dates
in the table versus what SQL SERVER 2005 understands?
Thank you,
Neel Gautam
Accenture - Chicago Delivery Centre
Office: 312-693-7279 Mobile: 630-440-6335
MSN: [EMAIL PROTECTED] AIM: neelgautam
Core Values:
Stewardship
*
Best People
*
Client Value Creation
*
One Global Network
*
Respect for the Individual
*
Integrity
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96
CS/SCCE
Sent: Thursday, April 26, 2007 9:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: Automated search from outside remedy
Why not just query the backend database directly?
Norm
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of SUBSCRIBE arslist Neel
Sent: Thursday, April 26, 2007 8:54 AM
To: arslist@ARSLIST.ORG
Subject: Automated search from outside remedy
Importance: High
Hello everybody,
We have a team on-support that checks for certain things every hour (for
example how many inbound emails in past 30 mins, how many outbound
emails went successfully in past 24 hours, how many emails errored out
in past 24 hours, emails waiting in the queue with status "YES" in past
24 hours, how many users are logged in at the moment etc...)
Is there any way to automate this search from outside the remedy? A
web-service, or a utility app that would execute the searches defined
ever hour or defined time-interval and log it in xml or crate a csv or
excel file? Any ideas?
Thank you,
Neel Gautam
Accenture - Chicago Delivery Centre
Office: 312-693-7279 Mobile: 630-440-6335
MSN: [EMAIL PROTECTED] AIM: neelgautam
Core Values:
Stewardship
*
Best People
*
Client Value Creation
*
One Global Network
*
Respect for the Individual
*
Integrity
This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you have
received it in error, please notify the sender immediately and delete
the original. Any other use of the email by you is prohibited.
__20060125_______________________This posting was submitted with HTML in
it___ __20060125_______________________This posting was submitted with
HTML in it___ __20060125_______________________This posting was
submitted with HTML in it___
This message is for the designated recipient only and may contain privileged,
proprietary, or otherwise private information. If you have received it in
error, please notify the sender immediately and delete the original. Any other
use of the email by you is prohibited.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
