A computer with holographic letters that read "SQL".

If you use ITIM or ISIM, you know how important it is to track the requests processed. A monthly count of these requests, along with successful and failed requests, can provide valuable insights. In this article, we will show you how to get a count of ITIM/ISIM requests by month using a simple SQL query.

This simple SQL query gets a count of requests processed by ITIM by month:

select to_char(trunc(to_date(substr(completed, 1, 10), ‘YYYY-MM-DD’), ‘MM’), ‘MON-YYYY’) “Month”,
count(*) “Total Count”, sum(case RESULT_SUMMARY when ‘SS’ then 1 else 0 end) “Success Count”,
sum(case RESULT_SUMMARY when ‘SF’ then 1 else 0 end) “Failed Count”
From PROCESS
where parent_id = 0
group by trunc(to_date(substr(completed, 1, 10), ‘YYYY-MM-DD’), ‘MM’)

An spreadsheet displaying the Date, Total Count, Success Count and Failed Count.

By running this SQL query, you can get a monthly count of ITIM/ISIM requests, including the total count, success count, and failed count. This data can be used to identify trends and patterns and make informed decisions to improve your system's performance.

How to Get a Count of ITIM/ISIM Requests by Month

Services

Solutions

Pricing

Resources

Events

About Us

Get Started