Retrieve summaries using TransposeSummarize Function

SELECT eh.Path + eh.Name Element, ts.*
FROM NuGreen.Asset.ElementTemplate et
INNER JOIN NuGreen.Asset.Element e ON e.ElementTemplateID = et.ID
INNER JOIN NuGreen.Asset.ElementHierarchy eh
ON eh.ElementID = e.ID
CROSS APPLY NuGreen.DataT.TransposeSummarize_Boiler
(
eh.ElementID,
N't' /*StartTime*/,
N'*' /*EndTime*/,
N'1h' /*TimeStep*/,
N'MostRecentTime' /*TimeType*/
) ts
WHERE et.Name = N'Boiler'
OPTION (FORCE ORDER, EMBED ERRORS)

Retrieves summarized data of elements that are inherited from the boiler template. The TransposeSummarize_Boiler is supposed to be created using PI SQL Commander Lite.

Note: For more information about which specific abbreviations can be used to specify PI time, please see PI Server topic PI time abbreviations.