Select a Query Begin Date from the Calendar, leave Hours, Minutes, and seconds at zero.Open LGH File Inspector and click New from the Home Tab Start by building the LGH File Inspector query with the levels tags we want in our report. A second worksheet called Report presents the formatted results using Excel formulas that refer to the data on the Query Data worksheet.Ĭlick here to download the Levels_rpt.xlsx Excel workbook to see how the formulas on the Report worksheet refer to the data on the Query Data worksheet.
The results of the query will update the Query Data worksheet in a Microsoft Excel workbook called: Levels_rpt.xlxs.
So how do I build reports without Historian?įollow the steps here to learn how to build Wonderware InTouch reports using the advanced features of LGH File Inspector queries.įor this example,we will build an LGH File Inspector query that retrieves level data for several historically logged level tags in an InTouch SCADA/HMI application. Choose one of three output destinations: screen, CSV File, or Excel workbook.Drag and drop tags of interest into the query and select the time and frequency of data you want.After installation, LGH File Inspector will ask you to browse to the folder containing your application’s LGH files. LGH File Inspector installs in just minutes. So whether you need regularly scheduled reports or just need to get historical data quickly and easily into a spreadsheet or CSV file, LGH File Inspector is the right tool for the job! How does it work? In addition, LGH File Inspector can be used to perform ad hoc queries and analysis. The concept is very simple, every LGH File Inspector query includes advanced settings that can be configured to initialize the query beginning date and time and then update an Excel worksheet and present the results in Excel or just to perform the work silently in the background. Historical LGH files are accessed through an easy and intuitive user interface and includes the ability to update CSV files and Excel workbooks on a regularly scheduled interval. LGH File Inspector is a must have query and reporting tool for anyone with a Wonderware InTouch SCADA/HMI application that logs historical data using the classic method of storing history to Wonderware InTouch LGH files.
So how can you take advantage of the built in historical logging available in InTouch and still gain easy access to data and provide reports as if you had a full blown historian? Consider using WorkSmart’s LGH File Inspector as your all in one query and reporting solution. InTouch logs historical data right out of the box to its native LGH file format. In fact, InTouch does a very nice job of logging historical data all on its own. Wonderware InTouch Reports without HistorianĮver wonder how to build Wonderware InTouch reports without Historian? Not every Wonderware InTouch SCADA/HMI application warrants a full blown historian system–perhaps yours is one of them.