Reading the last number of Tag Meta Data with UTC timestamp

use cases as tag meta data can be very infrequent and users may not always know the last time stamp, litmus production record database allows to return the last recorded values returning these last tag meta data recorded by litmus production record database through the use of these select statements can be used for example by any visualization platform which allows to integrate with mssql like; grafana powerbi tableau further can these queries be used by any other application which allows for an odbc connection such as excel c# net python r they can also be part of a larger stored procedure developed by users with t sql method run s elect query with function prorec tag getlasttagmetadatalocaltime as from clause note tag meta data are a subset of data which can be stored for a tag and are updated infrequently this can be data such as alarm limits, descriptions or anything usable to further describe a tag input variables variable name datatype description example @tag varchar(50) the tag name if no specific tag name is to be queried or to get a list of tag name's, the value can also be default which will assume the value % pressure default @device varchar(50) the device name for the tag if no specific device is to be queried or to get a list of devices, the value can also be default which will assume the value % asset1 default @item varchar(50) the meta data item of the tag which the value represents if no specific meta data item is to be queried or to get a list of item's, the value can also be default which will assume the value % high high limit default @numberofresults integer how many results are to be returned? if no specific number of results is set, the value can also be default which will assume the value null which is equivalent to 1 2 default how to use to query tag data, execute a select statement from the function prorec tag getlasttagmetadatautc providing all the required inputs below is an example using t sql in sql server management studio select from \[le productionrecord] \[dbo] \[prorec tag getlasttagmetadatautc] ( default ,default ,default ,2); result the function returns a table as result additional options it is possible to reduce the number of columns returned by the select statement below is an example using t sql in sql server management studio select recordtime, item, tagvalue from \[le productionrecord] \[dbo] \[prorec tag getlasttagmetadatautc] ( 'toolctr axis x' ,'toolctr v1 3bsm makino1' ,default ,2); this will reduce the number of columns returned to only the three selected it is possible to sort data based on users requirements returned by the select statement below is an example using t sql in sql server management studio select recordtime, item, tagvalue from \[le productionrecord] \[dbo] \[prorec tag getlasttagmetadatautc] ( 'toolctr axis x' ,'toolctr v1 3bsm makino1' ,default ,default) order by tagvalue asc; the result will be a table, where all rows are sorted by their tagvalue in ascending order