A
AnoushG
Hi there,
I have a problem,
I have a gateway that dose voip,
I collect the radius accounting logs with cisco secure in csv file.
I am even geting them by configuring an odbc drive to collecte them in
to a sql server.
everything work fine.
the only problem is that in eah colum I get the name of the colum. for
example. in the colum
"h323-disconnect-time"
I get this
"h323-disconnect-time=01:05:13.983 PARIS Sat Jul 5 2003 "
my question is that , in the colum
"h323-disconnect-time"
can we juste get
"01:05:13.983 PARIS Sat Jul 5 2003"
and not get
"h323-disconnect-time=01:05:13.983 PARIS Sat Jul 5 2003"
to resolve a bit this, I am doing extraction via sql argumet, and it
is working.
now I will have more traffic, and if i make sql work like this, he
will get crazy! and me too !
so dose any one have a solution for this ?
thx in advance
I have a problem,
I have a gateway that dose voip,
I collect the radius accounting logs with cisco secure in csv file.
I am even geting them by configuring an odbc drive to collecte them in
to a sql server.
everything work fine.
the only problem is that in eah colum I get the name of the colum. for
example. in the colum
"h323-disconnect-time"
I get this
"h323-disconnect-time=01:05:13.983 PARIS Sat Jul 5 2003 "
my question is that , in the colum
"h323-disconnect-time"
can we juste get
"01:05:13.983 PARIS Sat Jul 5 2003"
and not get
"h323-disconnect-time=01:05:13.983 PARIS Sat Jul 5 2003"
to resolve a bit this, I am doing extraction via sql argumet, and it
is working.
now I will have more traffic, and if i make sql work like this, he
will get crazy! and me too !
so dose any one have a solution for this ?
thx in advance