FAC report from CUCM 6.1.2

[ayoussef.kamal]

Hi All,

I have CUCM 6.1.2 and I need to export around 3000 FACs.I tried to find a native GUI tool to get this report but I could not find such a tool.Is there a third party tool or sql query from CLI on linux to do that?

Any ideas?

[ayoussef.kamal]

sorry for mis typo, i need to import not export a FAC report from CUCM.

[Jaime Valencia]

Use BAT

Working with Client Matter Codes and Forced Authorization Codes

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/bat/6_1_1/t09cfcin.html

HTH

java

if this helps, please rate

www.cisco.com/go/pdihelpdesk

[ayoussef.kamal]

Hi Jav,

As I know BAT is used to upload prepared .txt or .csv file or download it.

My problem is that all 3000 FACs are added before manually. I need now to collect those FACs from CUCM and download them.What is the idea?

BR,

Ahmed

[Jaime Valencia]

"sorry for mis typo, i need to import not export a FAC report from CUCM."

You said IMPORT, so, that's why I told you to use BAT.

The only option for you is SQL

Not even the import/export has this in 6.1

Import/ Export

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/bat/6_1_1/t13cnftl.html

HTH

java

if this helps, please rate

www.cisco.com/go/pdihelpdesk

[ayoussef.kamal]

hi jav,

thx for your reply.

i got the CLI command which is:

"run sql select name,code,authorizationlevel from facinfo"

BR,