We have PIPOINT defined on AF for some of the attributes currently and the data is reading from SMT OK. But when I run the below query, my sql does not fetch me correct archive values.
For F4402T0001H0080, the archive values are shown for 4 columns, but the script output populating as NaN
Again, I placed the same query inside powerhell script, the output values are displaying as NaN for all 3 windtowers.
For the columns, pipoint has defined, should display me Archive values from SMT, and for other columns as NaN as they do not have Tag available. Instead for all 3 windtower , all attributes are populating as NaN.
Please can anyone advise me if any problem with my sql query?