Rashmi

Tag Value via PI SQL Commander

Discussion created by Rashmi on Aug 5, 2019

Hi,

The value of the tag I see something in SMT. The same value i wanted to see in sql commander as well. But I see somethign else. For example:

Tag value in SMT - 2.21
SQL commander:

SELECT *
FROM [piarchive]..[pisnapshot]
WHERE tag ='Tag Name'

Result set:

Value= -88473602
Status =0

I was expecting to see 2.21 in query window as well, in the place of -88473602

Please advise.

Rashmi

Outcomes