Hunt Group Login and Logout report CUCM CLI Command

This command will help us to find hunt group login details.


run sql select lg.name as LineGroup,n.dnorpattern,dhd.hlog from linegroup as lg inner join linegroupnumplanmap as lgmap on lgmap.fklinegroup=lg.pkid inner join numplan as n on lgmap.fknumplan = n.pkid inner join devicenumplanmap as dmap on dmap.fknumplan = n.pkid inner join device as d on dmap.fkdevice=d.pkid inner join devicehlogdynamic as dhd on dhd.fkdevice=d.pkid order by lg.name

Searching CDR from CUCM CIL for Calling and called Number

This is for Ext calls
run sql car select call_type,callingpartynumber, originalcalledpartynumber, datetimestamporigination, duration from car:tbl_billing_data where originalcalledpartynumber in ("9911")

This from Calling party (PSTN Number)
run sql car select call_type,callingpartynumber, originalcalledpartynumber, datetimestamporigination, duration from car:tbl_billing_data where callingpartynumber in ("8104292829")