Request Aging Analysis

Request Aging Analysis

Has anyone every done aging analysis of the requests in this system? There does not appear to be any fields that track the number of days open for a request. I guess you would need to do some SQL for: today - opened time to get this?

eg. would like reports containing:
1) Open days for current cases (with columns <7days, 7-14 days 14-30 days, >30days etc).
2) Average age of open cases.
2) Number of days to close a case.

Has anyone done this? Would appreciate any advice.






                New to ADSelfService Plus?