CMS real-time informix databases 1

[FoneFun]

In the CMS server, does any one know where the tables are for the real time data?

I've found the historical ones, but not the real time ones.

 

[BIS]

They are stored in memory so you will have no chance getting to them through ODBC, dbaccess etc...

 

[telcoguy]

You'd have to grab the data from CLINT,
CLINT is the real-time interface, not very user-friendly, but if you get it to work it's OK.
you can find CLINT in /cms/toolsbin/


Rob

 

[FoneFun]

Thanks telcoguy!
I found the tools, I don't suppose you can point me to a place that documents how to use these tools?

I've found some postings in this forum, but not a complete doc.

 

[Rcotten]

This is what I have been using. I found it from several emails out on the forums.

___________________________________

after much trial and error, here's how I use clint (I expect to see a lot of stars next to my name for posting this!!!)

1. Telnet to your CMS Server (using cms login)
2. At $ prompt, type: cd /cms/toolsbin
3. Type: clint

You'll now see a menu loosely based on the CMS main menu. Now I'm going to show you how to run a real time report based showing logged in agents having skill #1.

4. At the > prompt, type: do menu 0 "rep:rea:spl:skill st"
5. Type: set field 10 "1"
6. Type: set field 20 "10"
7. Type: do "Run"
8. Type: do "Exit"

In step 4, "rep" stands for "reports", "rea" stands for Real-Time", "spl" stands for "Split", and so on. You may have to look at the normal menu to determine the letters to use. Note that you must use as many letters as necessary to be "unique" for that menu item.

In step 5, field 10 is the split number (in this example split "1&quot.

In Step 6, field 20 is the refresh interval (in this example, 10 seconds).

Now, if you are scraping this report using screen capture or something similar, you can script steps 7 and 8 to run over and over. You don't need to retype all the commands in again, just the "Run" and "Exit" command as the previous settings are still active.

You must do the "Exit" command immediately after the "Run" command. If you don't the output (every 10 seconds, or whatever you've set the Refresh rate to) will continue to post to the output buffer, but not be visible on the screen. And then the next Run command will show multiple versions of the report (one for each refresh interval).

You can type &quot;?&quot; plus <Enter> to see the available clint commands. For example, after you type the &quot;do menu ...&quot; command, you can type &quot;list&quot; to see the fields (and the field numbers) for that report.

If you have the # prompt instead of the $ prompt, you need to use a login profile based on the cms account. I'm not a deep Unix user and can't help on this one.

Obviously this is only the start. There's a lot more you can do. For instance, run a custom terminal screen report (but not Report Designer) reports. Or you can show calls waiting for a split.

But I suspect Avaya strongly frowns upon people using this utility. So be careful!

Bill





BHodgins (IS/IT--Manageme) Nov 4, 2002
Also, you type &quot;logout&quot; to exit the clint program.




mcccxi (TechnicalUser) Nov 6, 2002
ok. Thanks a lot BHodgins

I've use this and it works fine !
to do more, i had to export the output every 5 seconds. I give my way to help if necessary :

i've put the command line 4,5,6,7,8 of BHodgins's post in a text file named param.txt
and put this command in the crontab (used to execute every 5 seconds):
cat param.txt | /cms/toolsbin/clint -u cms > output.txt

then another process on another system get the file output.txt, using ftp ...