This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal


~Wei Lopgeroverakoi
Jan 16, 2014, 3:10 PM
9 Posts

Number of devices in SQL does not match Traveler web interface

  • Category: Administration
  • Platform: Windows
  • Release: 9.0
  • Role: Administrator
  • Tags: sql,traveler
  • Replies: 0
Environment : 2 Traveler 9.0 servers in HA mode (Windows) with SQL 2008 database

Context : Trying to get statistics on devices, users, ... .

Issue : I've opened a PMR some time ago asking how to draw stats in a HA environment as the web interface is not sufficient and the lotustraveler.nsf not exploitable. So we are making a query directly on the SQL by IBM Support's advice (select count (*) from device). Now I've noticed that the SQL query returns currently 1061 devices whereas the Traveler web interface (lotustraveler.nsf) shows 867 devices.

Which one is correct? Where is this difference coming from? Is SQL holding all ever configured devices (disregarding 30-day pruning setting of Traveler) whereas web interface would only show active devices (last sync < 30 days) ?

Thank you for your insights

Mathieu

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal