3.42.5. VoipAcctSQLStatement Previous topic Parent topic Child topic Next topic

VoipAcctSQLStatement This optional parameter defines the SQL query that will be used to insert VOIP accounting details into the Rodopi database. May contain special characters. If CiscoVoip is enabled, then any Accounting-Request containing a the ‘cisco-h323-conf-id’ attribute will be authenticated with VoipAcctSQLStatement. Defaults to:
exec Interface_VircomDetails2 
%0, '%1', %2, %3, %4, %5, %6, %7, %8, %9,
%10, %11, %12, %13, %14, %15, %16, %17, %18, %19,
%20, %21, %22, %23, %24, %25, %26, %27, %28, %29, %30, %31, %32
Arguments %0 to %20 inclusive are replaced the same was as specified in AcctSQLStatement. For more information, see Section 3.42.2. AcctSQLStatement.
  • %21 is replaced by cisco-h323-gw-id
  • %22 is replaced by cisco-h323- conf-id
  • %23 is replaced by cisco-h323-call-origin
  • %24 is replaced by cisco-h323-calltype
  • %25 is replaced by cisco-h323-setup-time
  • %26 is replaced by cisco-h323-connect- time
  • %27 is replaced by cisco-h323-disconnect-time
  • %28 is replaced by ciscoh323- disconnect-cause
  • %29 is replaced by cisco-h323-voice-quality
  • %30 is replaced by cisco-h323-remote-address
  • %31 is replaced by cisco-h323-ivr-out
  • %32 is replaced by cisco-h323-call-treatment