-
1
- #1
Hi all,
I've been tasked with pulling data out of the hsplit table in CMS, to supplement the data coming out of an rt-socket realtime feed. The issue is the rt-socket data keeps going on the fritz due to the client's "interesting" VM infrastructure, not that they'd admit that... and I need a way of "recovering" it back to normal.
I don't have an Avaya, let alone a CMS, and I don't have access to one (the client is 1/2 way around the world, and is a bank - so everything's locked down tighter than the tightest thing you could ever imagine...), otherwise i'd just grab it from them.
Would some kindly soul be willing to post here (or send me) a sample of data from the hsplit table? I'm going to be accessing it via ODBC, I will be pulling out a single day's worth of data (in fact, when the system is running, I'll be pulling only the "next interval", but I need to understand the way the data is formatted and held so I can write that query in a way that won't kill CMS stone dead). If it would be possible to have a single day, single skill, all intervals (or at least a half dozen concurrent intervals), that would be really really appreciated.
As a supplementary question - if there's no activity on a skill for a complete interval, does CMS write a load of zeros? Or does it just not write a record for that skill/interval?
Many thanks in advance!
(PS: I'll take the data in whatever format you've got - csv, Excel, punch card, core memory... )
I've been tasked with pulling data out of the hsplit table in CMS, to supplement the data coming out of an rt-socket realtime feed. The issue is the rt-socket data keeps going on the fritz due to the client's "interesting" VM infrastructure, not that they'd admit that... and I need a way of "recovering" it back to normal.
I don't have an Avaya, let alone a CMS, and I don't have access to one (the client is 1/2 way around the world, and is a bank - so everything's locked down tighter than the tightest thing you could ever imagine...), otherwise i'd just grab it from them.
Would some kindly soul be willing to post here (or send me) a sample of data from the hsplit table? I'm going to be accessing it via ODBC, I will be pulling out a single day's worth of data (in fact, when the system is running, I'll be pulling only the "next interval", but I need to understand the way the data is formatted and held so I can write that query in a way that won't kill CMS stone dead). If it would be possible to have a single day, single skill, all intervals (or at least a half dozen concurrent intervals), that would be really really appreciated.
As a supplementary question - if there's no activity on a skill for a complete interval, does CMS write a load of zeros? Or does it just not write a record for that skill/interval?
Many thanks in advance!
(PS: I'll take the data in whatever format you've got - csv, Excel, punch card, core memory... )