Avaya VoIP Monitoring Manager Reference
78
Par t i ci pant I D uni quei dent i f i er not nul l , / * The par t i ci pant I D f or whi ch t he
QOS sampl es ar e r ecor ded. */
Ti meOf f set i nt not nul l , / * Ti me of f set of t he t r ace r out e
f r om t he sessi on st ar t . */
HopI ndex t i nyi nt , / * Hop count i ndex. * /
HopAddr ess1 t i nyi nt , / * I P Addr ess f or t he net wor k hop
( Oct ect 1) . * /
HopAddr ess2 t i nyi nt , / * I P Addr ess f or t he net wor k hop
( Oct ect 2) . * /
HopAddr ess3 t i nyi nt , / * I P Addr ess f or t he net wor k hop
( Oct ect 3) . * /
HopAddr ess4 t i nyi nt , / * I P Addr ess f or t he net wor k hop
( Oct ect 4) . * /
HopTi me i nt / * Round t r i p del ay t o t he hop
addr ess i n mi l l i seconds. * /
)
/ * * Cr eat e t he Tr aceRout e t abl e i ndexes. */
CREATE CLUSTERED I NDEX Par t i ci pant I D ON Tr aceRout e ( Par t i ci pant I D)
GO
/ * * Dr op t he Conf i gur at i on t abl e i f i t al r eady exi st s. * /
I F EXI STS ( SELECT * FROM sysobj ect s WHERE NAME LI KE ' Conf i gur at i on' )
DROP TABLE Conf i gur at i on
GO
/ * * Cr eat e t he Conf i gur at i on t abl e. * /
CREATE TABLE Conf i gur at i on
(
Dat abaseVer si on var char ( 15) , / * Dat abase ver si on number .
*/
Li censeSer ver Addr ess char ( 15) , / * Addr ess of t he WebLM
l i cense ser ver . * /
Li censeSer ver Por t i nt , / * Por t of t he WebLM l i cense
ser ver . * /
Conf i gur at i onMessageManager Por t i nt / * The conf i g message
manager por t . * /
)
/ * * Add a r ow t o t he conf i gur at i on t abl e wi t h t he dat abase ver si on i n i t . * /
I NSERT I NTO Conf i gur at i on VALUES( ' 3. 1. 0' , NULL, NULL, NULL) ;
/ * * Dr op t he Li censeSt at e t abl e i f i t al r eady exi st s. */
I F EXI STS ( SELECT * FROM sysobj ect s WHERE NAME LI KE ' Li censeSt at e' )
DROP TABLE Li censeSt at e
GO
/ * * Cr eat e t he Li censeSt at e t abl e. */
CREATE TABLE Li censeSt at e
Komentáře k této Příručce