Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ideas please

Status
Not open for further replies.

BlurredVision

Technical User
Aug 6, 2001
326
GB
Just looking for some ideas...

I have the following information to report from.. It will verify from record to record.

ENTRY_TYPE Count datetime GROUP_ID
New Problem 1.00 7:21:32AM IT SHIFT OPS
Problem Transfer 2.00 7:21:33AM IT SHIFT OPS
Add Work History 0.00 8:18:21AM NTS
Problem resumed by 0.00 10:16:47AM NTS
Problem Resume Canc 0.00 10:16:57AM NTS
Status Changed 0.00 12:42:02PM NTS
Quick Solution 0.00 12:42:02PM NTS
Problem resumed by 0.00 12:47:21PM NTS
Add Work History 0.00 12:47:58PM NTS
Problem Closed 13:41:39PM NTS

The above is a problem management record. Each line is a entry from the history table(audit trail). I need to find a way check to see if the group 'IT SHIFT OPS' had updated the problem every 30 mins until the problem was closed.

Kinda thinking of doing a 1/2 hour grouping and seach for the group_id 'IT SHIFT OPS' Am I heading in the right direction?

Thanks for any help given..

-Brian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top