Printer FriendlyEmail Article Link

Spirent TestCenter: How to get Asymmetric Throughput Port Side Results from .db file with script?

Objective/Summary
  • This article is a duplicate of what is seen in the Spirent Forums.
    • searching the Knowledge Base also shows Spirent Forums, so you may see both in your search.
  • Original question was asking about HLTAPI.
    • I'm working on Tcl based automation for RFC 2544 test.
    • I have the end of test results in .db file.
    • I'm particularly interested in the data in the "Asymmetric Throughput Port Side Results" table.
    • I tried to use ResultsReporterCLI.bat, but I get empty tables no matter what template I use.
    • The HltApi command sth::rfc2544_asymmetric_stats does provide me with data, but it's not exactly what I need. Are there any other options I can explore?
Environment/Versions
  • API
Procedure
  • Try “ExportDbResults” or “QueryResult”.
  • This (below) seems to work :

    • set databasefilename {2544-Tput-Summary_2021-10-20_07-18-30.db}
          array set aQueryInfo [stc::perform QueryResult -DatabaseConnectionString $databasefilename  \
              -Resultpath AsymmetricThroughputPortSideResults  ]

         puts ""
         puts " AsymmetricThroughputPortSideResults"
         puts ""
         parray aQueryInfo

  • Output below:

    • aQueryInfo(-Active)                   = true
      aQueryInfo(-AttributeList)            =
      aQueryInfo(-Columns)                  = GroupType GroupName FrameSize Trial Result LoadResult OfferedLoad(%) RxFrameCount TxFrameCount RxFrameRate(fps) TxFrameRate(fps) TxBitRate(Mbps) FrameLoss PercentLoss
      aQueryInfo(-Count)                    = 4294967295
      aQueryInfo(-DatabaseConnectionString) = C:/Users/seilersen/Documents/Adtran/NewCrash/Crash-10-20-21/2544-Tput-Summary_2021-10-20_07-18-30.db
      aQueryInfo(-ElapsedTime)              = 46
      aQueryInfo(-EndTime)                  = 1634826212.65485
      aQueryInfo(-Filter)                   =
      aQueryInfo(-Name)                     = QueryResultCommand 2
      aQueryInfo(-Offset)                   = 0
      aQueryInfo(-Output)                   = {{Port Side} Downstream 128 1 Passed Passed 100.0 2533783784 2533783784 84459459 84459459 86486.486 0 0.0} {{Port Side} Downstream 256 1 Passed Passed 100.0 1358695653 1358695653 45289855 45289855 92753.623 0 0.0} {{Port Side} Upstream 128 1 Passed Passed 100.0 2533783784 2533783784 84459459 84459459 86486.486 0 0.0} {{Port Side} Upstream 256 1 Passed Passed 100.0 1358695653 1358695653 45289855 45289855 92753.623 0 0.0}
      aQueryInfo(-ProgressCancelled)        = false
      aQueryInfo(-ProgressCurrentStep)      = 1
      aQueryInfo(-ProgressCurrentStepName)  =
      aQueryInfo(-ProgressCurrentValue)     = 0
      aQueryInfo(-ProgressDisplayCounter)   = true
      aQueryInfo(-ProgressMaxValue)         = 0
      aQueryInfo(-ProgressStepsCount)       = 1
      aQueryInfo(-ResultPath)               = AsymmetricThroughputPortSideResults
      aQueryInfo(-ResultType)               =
      aQueryInfo(-StartTime)                = 1634826212.60901
      aQueryInfo(-State)                    = COMPLETED
      aQueryInfo(-Status)                   =
      aQueryInfo(-parent)                   = system1
       

Notes
Comparison of API output and the Results Reporter
  • {{Port Side} Downstream 128 1 Passed Passed 100.0 2533783784 2533783784 84459459 84459459 86486.486 0 0.0}
  • {{Port Side} Downstream 256 1 Passed Passed 100.0 1358695653 1358695653 45289855 45289855 92753.623 0 0.0}
  • {{Port Side} Upstream 128 1 Passed Passed 100.0 2533783784 2533783784 84459459 84459459 86486.486 0 0.0}
  • {{Port Side} Upstream 256 1 Passed Passed 100.0 1358695653 1358695653 45289855 45289855 92753.623 0 0.0}


Same can be done with the other tables:
  • Asymmetric Throughput Port Results  
  • Asymmetric Throughput Stream Block Results.

Product : API,RFC 2544