Reading out Tag definitions

use cases reading out the tag definition can be used to verify what tags do exist and what items and meta data are defined this is most useful, when creating a new tag or wanting to modify an existing tag user can do this either by using applications such as microsoft sql server management studio mssql cli this can also be used for building custom solutions based on applications which allow for an odbc connection such as excel c# net python litmus does provide such as custom solution which can be downloaded from our central portal method run s elect query with function prorec tag gettags as from clause note litmus production record database can act similar to an historian and allows to store data for individual defined tags and their meta data input variables 155,141,239,219,133,114 false true false unhandled content type unhandled content type unhandled content type unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type false unhandled content type how to use to read out all or a specific tag definition, execute a select statement from the function prorec prorec gettags providing all the required inputs below is an example using t sql in sql server management studio select from \[le productionrecord] \[dbo] \[ prorec tag gettags ] ( default ,default); 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 tagname, devicename, tagitemname from \[le productionrecord] \[dbo] \[prorec tag gettags] ( default ,'l2 machine1 1 mb'); this will reduce the number of columns returned to only the four 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 tagname, devicename, tagitemname from \[le productionrecord] \[dbo] \[prorec tag gettags] ( default ,'l2 machine1 1 mb') order by tagname asc; the result will be a table, where all rows are sorted by their tag name in ascending order