SQL Query for ANI

[Dass Prakash R]

Hi,

Can anyone please let me know what will be the SQL Query to pull out the ANI for the webview Call Error from HDS

Thanks in Advance

Regards,

Dass Prakash

[jpsweeney77]

Not sure I follow but I suspect you're referring to Router Error Codes. You can query Route_Call_Detail but you will need to know which Router Error Codes you are looking for. Link below is the list of Router Error Codes.

http://docwiki.cisco.com/wiki/Router_Error_Codes

Select ANI,RouterErrorCode,* from Route_Call_Detail where RouterErrorCode = xxx