cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
338
Views
0
Helpful
1
Replies
Highlighted
Beginner

EIM 4.3.2 - Case closed

I have EIM 4.3.2 installed. The system has been up for 3 years.

I need to figure out how to find the exact date that a case was closed. I have been using my supervisor login and have been running the report utility. I get the stats but no date that points to when the case was actually closed.

Is there a SQL command or a particular search that would give me this information?

Thanks

Frank

1 REPLY 1
Highlighted
Beginner

Run this query on eGActiveDB by replacing the case id.

select cast(dateadd(ss,event_date/1000,'1/1/1970')as datetime ), *

from egpl_event_hist_case_mgmt_arch where case_id in (XXXX) and object_operation = 610 order by event_id

Content for Community-Ad