Is there a way to determine how many times a specific request area/category has been used within CA Service Desk Manager (CA SDM) within a given time period?

Document ID : KB000048436
Last Modified Date : 14/02/2018
Show Technical Document Details

A database query could be executed against the MDB to determine how many times a specific request area category has been used within CA Service Desk Manager CA SDM within a given time period.

Firstly, you need to understand that Unix epoch format is used for dates stored in the MDB database.

What is epoch time?

The Unix epoch (or Unix time or POSIX time or Unix timestamp) is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds (in ISO 8601: 1970-01-01T00:00:00Z). Literally speaking the epoch is Unix time 0 (midnight 1/1/1970), but 'epoch' is often used as a synonym for 'Unix time'.

Here are some sample conversions of epoch time:

1 hour 3600 seconds
1 day 86400 seconds
1 week 604800 seconds
1 month (30.44 days) 2629743 seconds
1 year (365.24 days) 31556926 seconds

You can use the online epoch converter (http://www.epochconverter.com) to makes things simpler.

For example, epoch time for January 1st, 2013 would be 1357020000 and for December 31st 2013 would be 1388555999.

Using the two epoch values above, a database query to determine how many times a specific request area category has been used within CA SDM for the 2013 calendar year would look similar to:

select prob_ctg.sym as 'Request Area', count(*) as 'Times used' from call_req, prob_ctg where open_date between 1357020000 and 1388555999 and category = prob_ctg.persid group by prob_ctg.sym