AnsweredAssumed Answered

PI SQL commander and SSRS: how to retrieve multiple values with the same timstamp

Question asked by Johan_Van_Acker on Jun 17, 2018
Latest reply on Jun 21, 2018 by vkaufmann

Hello,

 

Any idea how to retrieve all values on a equal certain timestamp?

Here some screenshots:

 

PI Data Archive

4 values with the same timestamp

 

PI SQL Commander

With this query I only get the last value.

 

SSRS

The same with SSRS

 

Somebody has any idea what I should change to get all the values?

 

Thanks

 

Johan

Outcomes