Heads Up :
The post you are writing will appear in a public forum. Please ensure all content is appropriate for public consumption. Review the employee guidelines for the community here.
There's the query I used to identify templates with "Individual". These templates are created when you modifiy the line appearance on the device. I had 599 templates I needed to delete or change to device type templates.admin:run sql select device.na...
Use Cisco CallManager Real-Time Monitoring Tool (it's a plugin from CallManager and you can install it on your desktop). This will give you stats on H323 Trunks, but the downfall is exporting the data. Have you looked at CAR (aka ART)?
When using the IP phone BAT template, use the "Phones-Users" template. The template will associate the device and the user in the DC directory. Templates are located in C:\CiscoWebs\BAT\Templates
