5/26/2023 0 Comments Wonderware historian extract dataTo install the procedure just run the script above against your Wonderware Historian’s Runtime database from within MS SQL Server Management Studio 2005 (or MS SQL Server 2000 Enterprise Manager).īelow is an example of how to run the command:ĮXEC HistoryData ‘20081027 21:04:00′,’20081027 21:07:00’, ‘SysTimeSec, SysDateDay’ ![]() ![]() – optional comma separated list of tag – this parameter allows the procedure to be run for different sets of tags SET = + ‘ AND DateTime <= ‘ + CHAR(39) + AS varchar(50)) + CHAR(39) + ‘”)’ EXEC procedure accepts 3 parameters: SET = + ‘FROM WideHistory WHERE wwRetrievalMode = ”Cyclic” AND wwResolution = 1000 AND wwVersion = ”Latest” ‘ SET = + + ‘”SELECT DateTime = convert(nvarchar, DateTime, 21), ‘ + + ‘ ‘ SET = + ‘SELECT * FROM OPENQUERY(INSQL, ‘ –above: is an optional parameter, value after the equal sign is the default value if is omitted Below is an example of a stored procedure that will retrieve wide-history data from Wonderware Historian 9.0 (formerly known as IndustrialSQL Server or InSQL):ĬREATE PROCEDURE varchar(500) = ‘,, ’
0 Comments
Leave a Reply. |