Find the TrendLog ID used by the Vista database for custom SQL reporting

Issue

How can you find the Trend Log ID / GUID of trend logs in the Vista Server for use with custom reporting or querying of the SQL database?

Product Line

TAC Vista

Environment

Vista 5.x.x

Cause

The Vista database uses a Global Unique Identifier (GUID) for trend log storage in the SQL database. This Trend Log ID/GUID is stored in an property not immediately visible in the property window of the Vista Workstation environment.

In Vista 5.1.7 a new database layout was introduced, database  layout version 2.
The version of the layout  for the log database is possible to see from the Vista server setup.
And it is possible to upgrade the database to version 2 with a tool called SQL Database Upgrade tool which is included in the Vista installation from Vista 5.1.7.   
If using the new layout of the SQL database in Vista version 5.1.7 both the name of the trend log and the trendlog GUID is included in the TrendLog table.

Resolution

Single Trend Log

Hold CTRL + SHIFT + right click and select properties of the trend log object. The Trend Log ID is one of the visible properties.

Multiple Trend Logs

  1. Start a new search in Vista Workstation.
  2. Change the object types to Files\Trend Logs.
  3. Change the property to Trend Log ID.
  4. Leave the string as "*" for all trend logs.
  5. Click Search

The results can be printed listing the database path, object name, and trend log id for use by the individual building the SQL reports.

If using the new layout in Vista version 5.1.7 both the name of the trend log and the trendlog GUID is included in the TrendLog table.