TN Hist225 Historian Client Query Quality Detail Index

Description

When using Historian Client Query, there is a column called QualityDetail that lists different definitions that can be used to troubleshoot the connection to Historian. This article shows you how to query the index to get a list of results to define different QualityDetail values.

• Author: Daniel London
• Published: 08/28/2015
• Applies to: Historian Client Query (All Versions)

Details

In Microsoft SQL server, type the following query to get a list of all QualityDetail definitions. Make sure to have the Runtime database selected.

Select * From QualityMap

Here is an example of the QualityDetail column in Historian Client Query:

Once you have the QualityDetail value, you can then modify the query mentioned earlier to search for a specific definition. For this example, I used the value displayed in the previous Historian Client Query image (65536) and typed the following query in Microsoft SQL Server:

Select * From QualityMap

Where QualityDetail = '65536'