Yes, CCALLS gives you the total number of SDCCH attempts for all transactions( call setup, location update, SMS, etc).
The total number of SDCCH attempts for SMS is: CSMSDWN+CSMSUP.
SDCCHs for Location updates are counted by CLUMSESTAB. However, you will only get this counter if your BSC software version is 08 or after.
With the BSC SW version in my network (06A), there are NO counters that show the purpose for which an SDCCH was seized( loc. update, call establisment, SMS, etc). I raised a CSR with ericsson about this, but they said it’s only possible if we upgrade our BSC software. Thnx anyways.