Home

SmartClient User's Guide

1. Figure 7 12 Column descriptions Id Sequential number lt TAGNAME gt This field is equal to the field s selected when setting up the analysis If more fields were selected more columns would be shown here Response Time between alarm time and acknowledgement time Time Alarm Time Time when the alarm occurred If empty no corresponding alarm was found Time when the alarm was acknowledged If empty no corresponding acknowledge event was found Shows how many times the alarm was repeated before it was acknowledged Acknowledged Repeated Each row in the grid represents an alarm with a corresponding acknowledgement action 7 6 Reaction Time analysis For transmitters and controlling loops the time from a H1 alarm to a H2 alarm can be described as the Operator Reaction Time I e the time from a pre warning before a more serious alarm occur It is important that the H1 alarm comes in time so that the operator has the necessary time to perform relevant corrections and preventive actions The recommended minimum reaction time varies from process to process and from loop to loop For generic analyses it would typically be in the area from 2 to 5 minutes The AM Reaction Time analysis can be used to evaluate the reaction times and help to locate e Tags with identical set points e Tags with high rate of too short reaction times e Tags with scattering alarms in H2 mode In the following figure the Operator R
2. General Analysis Common options Don t copy fetched events to local table This will increase performance but eliminate the possibility to examine the events within the Abl dialog Show Messages tab Unique field s Tagname y Description y lt Not Used y Priority field FEMUA settings Recommended alarm rate alarms 10 mini 3 HA X Cancel Figure 7 20 Common options Don t copy fetched As default a copy of the fetched events will be stored locally in the TEMPDATA alias When working with a large amount of source data this setting can be used to increase performance When enabled the Events view as mentioned earlier will not contain any events Show Messages tab If enabled a Messages tab is shown containing all runtime messages for the analysis This should only be used in case of unexplainable errors in the analysis result Unique field s Default selections for analysis using these kind of fields Priority field 13 The filter name can only be set when creating a new filter It cannot be modified later on like the rest of the information set for that filter SmartChent User s Guide Release 4 0 Page 50 58 Alarm Management Add on Recommended alarm _ This is used for the graphical presentation in the alarm rate rate analysis and shows a red line that should not be exceeded Alarm Management Options O XK General Analysis Frequency Default presentat
3. Events Result Chart Messages 7 H PeriodFrom ___ AlarmCount 15 10 2004 1 15 10 2004 00 10 00 15 10 2004 00 20 00 15 10 2004 00 30 00 15 10 2004 00 40 00 15 10 2004 00 50 00 15 10 2004 01 00 00 15 10 2004 01 10 00 15 10 2004 01 20 00 15 10 2004 01 30 00 Om Mm oO Oo oO Qi Figure 7 3 Each record in the data grid represents the alarm count for one resolution period Graphical presentation Events Result Chart Messages ES lt gt E Alarm Rate analysis for Ut Data 2006 03 01 00 00 00 gt End of table ee a a ed ee aa A a a a a a a a a a a e a a a a ara a a A A A r ra a a a A a HA IA A te T A RA A AAA lr ts A TA Trea wal aa A RARA Alarm Count Llao gt l gt gt gt gt gt h gt gt Ll gt gt Aadl dle 22 Mr b 2 gt Mi 1 EET FF HA gt gt AA gt E gt gt SS gt gt A e ai el La y 1 00 00 02 00 04 00 06 00 08 0 10 00 12 00 14 00 1600 18 00 20 00 22 00 00 00 Chart period 1 day from 2006 03 01 Page 1 31 ae Fixed Y axis Setto J63 lt Figure 7 4 The graphical presentation shows the alarm rate compared to the recommended EEMUA rate which is shown as a thin red line wy According to EEMUA publication 191 the recommended average alarm rate during normal conditions should not exceed 1 alarm per 10 minut
4. ooccccccccconcnaccccncnanna rar rr narrar 58 8 3 WISiNtoO Matos dada 58 SmartChent User s Guide Release 4 0 Page 4 58 Introduction 1 Introduction SmartClient is a generic client tool for use with alarm and event historians like ABB SmartLogger and ABB 800xA Information Manager as well as event historians from other vendors It can in fact be used as front end for any database table but has many features that are custom designed for event handling and alarm management SmartClient has been designed for working with large tables and has a number of performance increasing features that makes it possible to work with millions of records It also uses a Multiple Document Interface MDI which means that multiple tables can be opened simultaneously for viewing comparison and other purposes The table views don t need to come from the same database Several views from different databases and different database types can be opened simultaneously SmartClient i 10 tal x File Edit Table Tools Alarm Management Window Help 0d ar ZA Aoa o E LOGDATA AM_AR_500 aE a S a B e a AS KRT ESDY 55945 shutdown Fuel sas E Te KRT BDW 1124 C Turbine Blowdown 2 Closing ES ALAS 053 Prod Drain Valve 2 Closed DPS PUMP 236 F West Water Pump 12 Failure PLELSL 345b7 Drain Tank r Alarm KRT ESDY 05943 C Shutdown Fuel Gas 2 Closing KRT ESDY 65945 shutdown Fuel Gas 2 Closed Figure 1 1 Menu Please refer to section Menu overview for a
5. 00 0 O Possible identical setpoints H 23 C7116114 00 02 00 3 100 00 00 00 00 00 01 00 00 01 0 0 100 is below recommended reaction time E 23F PT 590503 00 02 00 11 100 00 00 01 00 00 04 00 00 15 2 0 100 is below recommended reaction time 23 F PIT 353242 00 02 00 1 100 00 00 00 00 00 00 00 00 00 D 0 Possible identical setpoints 23F Fiv 570045 00 02 00 14 100 00 00 00 00 00 03 00 00 18 3 5 100 is below recommended reaction time E 23F LT 410002 00 02 00 1 100 00 00 23 00 00 23 00 00 23 6 0 100 is below recommended reaction time H 23 F Z7 353025B 00 02 00 z 100 00 00 00 00 00 00 00 00 00 O O Possible identical setpoints E 23F Z7 3530254 00 02 00 9 100 00 00 00 00 00 00 00 00 00 0 0 Possible identical setpoints E 23F ZT 3530504 00 02 00 9 100 00 00 00 00 00 00 00 00 00 0 0 Possible identical setpoints E 23F ZT 3530506 00 02 00 1 100 00 00 00 00 00 00 00 00 00 0 O Possible identical setpoints E 23 BPT30025 00 02 00 1 100 00 00 00 00 00 00 00 00 00 0 0 Possible identical setpoints 23 BLT35349 00 02 00 19 89 47 00 00 00 00 01 07 00 11 36 25 1 69 is below recommended reaction time Figure 7 15 SmartChent User s Guide Release 4 0 Page 47 58 Alarm Management Add on The summation tab summarizes all alarm pairs for each individual tagname Only completed alarm pairs where both a pre warning and an alarm trip event were found are included in the calculation Column descriptions lt TAGNAME gt This field is equal t
6. Cancel Figure 7 23 In this case we have given the pump XYZ PUMP 1234 the more explanatory object name Export Pump Example Add object by drag n drop An easier way to add objects is to drag two records an ON and an OFF criteria from the table and directly into the Analyze Time dialog When dropped onto the Defined objects list box a new object is automatically created Adding the same object with the same information as specified in the previous example would be performed like this e Select the 2 records that can be used as ON OFF criteria s in the table grid In this case we will use the same records as used in the previous example above e Drag these records to the Analyze Time dialog and drop them onto the list box A dialog as shown in Figure 7 24 should now appear SmartChent User s Guide Release 4 0 Page 53 58 Alarm Management Add on Object name Export Fump Select the record to be used as ON criteria E lt YZ PUMP 1234 f Running C xYZ PUMP 1234 Stopped Figure 7 24 e Specify the object name Export Pump e Select which one of the records that should be used as the ON criteria in this case the one already selected e Press OK It is possible to add an unlimited number of objects to an analysis as long as they all use the same fields I e it is not allowed to have one object using the fields Tagname and EventTexti and another using the fields Tagname and EventText2 Ny
7. Long response times on warnings might be acceptable while long response times on critical alarms can be a serious problem Data limitation Alarm filter Specifies the filter that identifies the alarm on conditions Ack Filter Specifies the filter that identifies the operator acknowledgements Time scope This shows the actual time scope that will be used for the analysis Refer to section Limiting the analysis period for information on changing the analysis period Pressing the Execute button starts the analysis and the final result will we be presented in a data grid and as a graphical presentation as shown below SmartChent User s Guide Release 4 0 Page 44 58 Alarm Management Add on Grid presentation Events Result Chart CEE e el T ne __ ResponceTime Alamitime Acknowledged Repeated A 1 KRT BDY 1124 00 50 10 2004 10 31 17 46 09 2004 10 31 18 36 19 o F 2 KRT BDY 1124 00 41 24 2004 10 31 16 01 25 2004 10 31 16 42 49 1 M 3 AMY ALE 53053 00 35 30 2004 10 31 14 33 10 2004 10 31 15 11 40 4 g 4 KRT BDY 1124 0 00 33 29 2004 10 31 15 40 08 2004 10 31 19 13 37 o F 5 KRT ESDY 35943 00 12 14 2004 10 31 11 06 06 2004 10 31 11 20 20 1 E B RYL 53053 00 08 57 2004 10 31 11 31 35 2004 10 31 11 40 32 a T KRT ESDY 35943 00 07 25 2004 10 31 10 18 12 2004 10 31 10 25 37 o H A YSL 53053 00 06 54 2004 10 31 13 10 16 2004 10 31 13 17 10 o 9 KRT ESDY 05943 00 06 27 2004 10 31 11 23 22 2004 10 31 11 29 49 1
8. The ON OFF criteria s are case sensitive i e an event containing EventTextl Running is not considered the same as EventTexti running 7 8 2 Running an analysis When all objects are defined the template can be saved and the analysis can be executed During execution of the analysis an Execution Status dialog as shown in Figure 7 25 will be presented From this dialog the progress of the analysis can be monitored and the analysis can be stopped at any time by clicking the Stop button The Close button shown in Figure 7 25 will change to a Stop button during the analysis Analyze Time Results for Aniz E Object list ject ls Me Time fava Tire vox Tine Tot Tie We BexpotPump o 00 00 03 00 00 03 E 100 0003 E Eee i Main Export Valve 2 Print Ei Preview 0 00 00 00 00 00 00 00 00 00 00 00 00 View On Ofi Template 4nlz Times l Analysis started at 2000 01 01 21 10 25 amp Print source Alias UGDEMO Source Table ANLATIMIE Analyzing object Export Pump Analyzing object Main Export Valve T Close Analysis finished at 2000 01 01 21 10 25 ios Figure 7 25 The analysis status dialog is divided into two parts SmartChent User s Guide Release 4 0 Page 54 58 Alarm Management Add on At the top you have the object list containing the status for each of the objects configured for the current analysis template At the bottom a
9. different users password this option must be disabled SmartChent User s Guide Release 4 0 Page 24 58 Maintenance Incremental record fetching When a table is opened only one packet of records is fetched from the table instead of all records as normal This significantly shortens the time it takes to open a table When scrolling through the table new packets are fetched from the database when required Unless working with small local tables it is recommended to enable this option as it improves the execution times for sort query and table open operations When incremental record fetching is enabled the number of records shown in the lower left corner of the table window will show Fetched xxx records instead of xxx records This number xxx will then be the number of records fetched so far and not the total number of records in the table 4 1 2 Grid Layout Figure 4 2 Options a 3 x Database Grid layout Export directories Miscellaneous Show milliseconds in Date Time fields Show grid lines Grid color MAMMA Background color Use alternating background color o Color Id fieldnarne Priority Show Color ld field in table grid Y Dontuse shared colors Show text in memo fields not just MEMOJ Color Setup Grid Layout Show milliseconds Show grid lines Grid color Background color Use alternating Use Color Id mapping Color Id fieldname Sho
10. part as shown in Figure 5 3 is common for all database types The lower part contains individual settings for a specific database driver and is described later in this section Database Alias Manager X Database alias LIGOEMO Driver type STANDARD Figure 5 3 2 Only filters that match the table structure in the first chosen table will be shown 19 If for example merging twelve month tables into one year table then the January table should be placed at top of the list box then the February table etc That way the records in the new merged table will be listed in the correct date time order Only Paradox databases are supported as destination table 12 To use this functionality the number of fields in the source tables must be less than the maximum number of allowed fields SmartChent User s Guide Release 4 0 Page 31 58 Utilities Alias Manager controls Database alias Lists all aliases supported by the Alias Manager Driver type Lists all database drivers available Ny It is recommended to always use the STANDARD Paradox driver unless it is explicitly required to use another database driver 5 3 1 Database driver settings Paradox 7 STANDARD driver Paradox 7 Database path JF SmartLog Tables Bs Figure 5 4 Paradox 7 settings Database path Defines the location directory where the tables are stored Oracle 8 ORACLE driver Oracle 6 Met Service name Table list cache t
11. queries an additional filtering can be applied from the analysis dialog This filter is optional except for the Operator Response Time analysis where the filters are used to determine the event types All filter controls have a New Filter and a Modify Filter button as shown in Figure 7 18 Data limitation Alarm Filter Figure 7 18 When pressing either one of the two buttons the filter dialog will be shown Modify filter a x Filter definition name Valve Open Description Demo filter for presentation Filter criteria list OR Pseudo code Tagname Mo xv AND PropA Dpen Delete Delete all X Cancel Figure 7 19 SmartChent User s Guide Release 4 0 Page 49 58 Alarm Management Add on New Filter or Modify Filter Filter definition Filter name name Description Optional information about the filter Filter criteria list Pseudo code Lists the query definition in pseudo code Each line represents a filter criterion All filter criteria are OR ed together in the final SQL statement Edit button Opens the standard SQL Query dialog for editing query definitions as described in section SQL Query Delete button Deletes the selected OR criteria from the pseudo code list Delete all button Deletes all criteria 7 7 3 AM Options By pressing the options icon on the AM toolbar options as shown in Figure 7 20 can be set Alarm Management Options a 4 x
12. report The panel can also be used for specifying the DateTime field used for misc time operations as explained in section Supported tables This is relevant when a table contains more than one DateTime field W Fields can be dragged and dropped from the table grid to the panel and the other way around Export Selected All Records This feature is basically the same as the Table Export feature described in section 5 1 except that e Only the selected records are exported if Export selected is chosen e TAB characters are always used as field separators for the Text export e To select more than one record do one of the following e Press and hold down the SHIFT key while pressing the up down key e Press and hold down the CTRL key while selecting records with the mouse e Select a record with the mouse hold down the SHIFT key and select another record All records in between these two selections will now be selected SmartChent User s Guide Release 4 0 Page 35 58 Quick Access Funktionality 6 4 Print Preview Selected All This feature is basically the same as the Print feature described in section 3 4 6 5 Grouping Mode This feature allows all the data in the table grid to be grouped by any field specified by the user as shown in Figure 6 2 When grouping mode is activated a grouping panel becomes visible just above the table grid To group by any field simply drag the column header to this panel To remo
13. section Limiting the analysis period for information on changing the analysis period Pressing the Execute button starts the analysis and the final result will we be presented in a data as shown below SmartChent User s Guide Release 4 0 Page 46 58 Alarm Management Add on Grid presentation alarm pairs Alarm pairs Summation Histogram E rm EA Ea me 2ICWTSST 6 5 23BPT30162 207 23 F T1E 353511 274 135 23 F TE 353511 260 23F TE 353511 30 23 F TE 35551 1 205 23CATS 400 204 23BPT30162 400 23BLT35349 193 256 ATso19 234 23BPT38162 220 236 ATs019 12 256 ATso1g 166 25 F LIT 351501 24 23 F PI1 353119 09 49 26 02 50 19 01 39 38 01 05 17 00 55 11 00 33 58 00 28 20 00 22 43 00 19 02 00 12 10 00 11 36 00 11 00 00 10 58 00 09 00 00 08 59 00 08 54 00 07 00 2 29 03 2006 18 14 24 O 02 03 2006 10 53 03 0 01 03 2006 03 02 39 O 24 03 2006 00 57 56 10 24 03 2006 00 16 46 A 17 03 2006 10 27 44 O 23 03 2006 10 44 35 0 03 03 2006 07 52 12 0 23 03 2006 12 50 19 3 23 03 2006 12 52 10 1 31 03 2006 13 16 19 0 23 03 2006 10 47 53 O 23 03 2006 16 33 51 1 23 03 2006 15 20 46 1 01 03 2006 13 20 24 1 19 03 2006 14 32 41 3 02 03 2006 11 10 56 30 03 2006 04 03 50 02 03 2006 13 43 22 01 03 2006 04 42 15 24 03 2006 02 03 13 24 03 2006 01 11 59 17 03 2006 19 01 42 23 03 2006 19 12 55 03 03 2006 02 15 01 23 03 2006 13 17 22 23 03 2006 13 04 21 31 03 2006 13 27 55 23 03 2006 10 50 53 2
14. the SQL Query dialog refer to section SQL Query SmartChent User s Guide Release 4 0 Page 37 58 Alarm Management Add on 7 Alarm Management Add on The Alarm Management module if part of the Analyze Tools add on and is not included in the basic SmartClient package The following descriptions only apply if this add on has been purchased and registered on your system 7 1 Before using the alarm management analysis The different AM analyses have many configuration possibilities and can be used for many purposes To obtain both flexibility and usability a number of advanced settings are auto configured as default It is therefore important to read this section carefully in order to understand the behaviour of the analyses and to explore the full potential Take the Alarm Frequency analysis as an example This analysis may seem quite straight forward but can in fact be used for many different analyses like e Alarm Event frequency Top 10 Top 20 etc e Alarm frequency calculated per object one object can generate many different alarms e Alarm type frequency position errors feedback error etc e Alarm distribution between process areas In general an analysis will analyze what is seen in the table view This means that any filtering or time scope set for the table view is automatically applied to the analysis This can be one or all of the following e BaseTime SQL set when opening the table view e Time View limi
15. the clipboard or saved to a file Search type Substring Whole word Starts with Wildcard match Find the search string anywhere in the field Only find fields where a stand alone word matches the search string Only find fields that start with the search string Use this type if wildcards are to be used in the search Multiple character wildcard is and single character wildcard is Wildcards can be combined like Com s which will find Compose Compass but not Composition Note that although the Find dialog stays on top when you switch between the different tables the Find dialog remembers the settings specified for each table This means that the search settings do not have to be re entered when switching between the opened tables The Find settings are only remembered as long as the table is open 3 8 SQL Sort With the sort function it is possible to sort the records in the table The Sort Table dialog can be opened by selecting the menu item Table Sort SmartChent User s Guide Release 4 0 Page 22 58 Basic Operations Sort Table E Fields to sort A Y LogD ate Tagname Property Court Sort orde f Ascending C Descending Figure 3 15 Sort Records Available fields Contains a list of all available fields Fields to sort Lists the fields to be used for the sort operation in descending priority Sort order Choose ascending or descending sort order for the sort ope
16. uranio 34 6 QUICK ACCESS Funktionality rinini ana 35 Oi CODY UO CAPO io 35 6 2 Fleld Customisation Panel imriss ladies savant a 35 6 3 Export Selected All RECOMGS ari Mo rhanalew a a eaa 35 6 4 Print Preview Selected Allan a aid 36 139 GPOUDIAG Mode ciales 36 6 07 QUICK SONG MOdSi aaa tds 36 O7 QUICK FMO ao 37 7 Alarm Management CAdd ON liinda 38 7 1 Before using the alarm management analysis cc cece eect eee eeeeeeeeee eee eeneeeeeenegs 38 SmartChent User s Guide Release 4 0 Page 3 58 Z1 Evaluating the analysis FesUlltiuisainadii e a Aa a aa 38 A2 Ala Rate analys Seenaa asa 39 Lao Alarm Prority Distribution analysis pa 40 TB Alar Frequency ANAIVSIS is A AS 42 7 5 Operator Response Time ORT analySiS cococcccccccoccccnccnnnannrnrrn rr rr rr 44 Ab REACTION IME ana SIS rr a 45 J COMMON AMOO es 48 KT LIMIT CAC a alYSiS Period ia daa sa 48 Ald Cmn tHe a na SIS datar is 49 IES TAMOS e td Gat oe e de de de to 50 AS Analyze UME ene tee SA Sa 51 o Designing anally SIS eri 52 1 82 RUNING andan SIS bead et tewtncalnasd et iantabel Gewese athaatens 54 Td VEX DOPENNG resul aa ads ada 56 7 8 4 Loading an analysis RESUUE Sir RADAR 56 SB A PENdIK ocrni 57 S Grd MOG SS rana daa a 57 Sled NORM MOG Cs do 57 St EOAdAlNRecoras MOQ isitin AE a 57 8 2 Desktop versus Server databases namie a aed ea ae 57 8 2 1 Desktop databases Parado O iii O 57 8 2 2 Server databases Oracle or MS SQL Serve
17. well e Object alarm frequency analysis see below e Alarm distribution in selected areas process sections event severities event types etc An alarm analysis typically looks at unique alarms But some objects like PID regulators might generate many different alarms and these alarms might not be found in a standard analysis By analysing only on the object name tagname another pattern could be found The following shows a typical set up for an alarm frequency analysis OE Analysis settings Data limitation Unique field s Tagname y Alarm Filter ABB Alarms ln A EventType y Time scope 2004 1 2 30 00 00 00 gt End of table lt Not Lised gt y Figure 7 8 Analysis settings Unique fields Determines the fields to be analyzed Data limitation Alarm filter Specifies the filter to be used on the data sources If no filter is selected the complete data source is analyzed Refer to section Limiting the analysis data for creating or modifying filters SmartChent User s Guide Release 4 0 Page 42 58 Alarm Management Add on Time scope This shows the actual time scope that will be used for the analysis Refer to section Limiting the analysis period for information on changing the analysis period Pressing the Execute button starts the analysis and the final result will we be presented in a data grid and as a graphical presentation as shown below Grid presentation Result Cha
18. 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 I I I I I 1 1 1 1 1 I I 1 I 1 1 1 1 1 A e o O es onsen O es phase aco Lair y ais ico papas E OFB_ 4130197 Page 1 2 Figure 7 16 7 7 Common AM Options 7 7 1 Limiting the analysis period The selected time scope for the analysis is shown on the analysis dialog SmartChent User s Guide Release 4 0 Page 48 58 Alarm Management Add on Alarm Rate analysis for PORT2_20050400 E Ey gt 2 Analyze settings Data limitation Resolution fi 0 minutes y Alarm Filter OY Time scope 005 04 26 00 00 00 gt 2005 04 26 23 59 59 Figure 7 17 To change it go to the table view and change the current Time View for the table view In some cases the time scope shown on the analysis dialog will be slightly different than the Time View settings This is due to the auto scale functionality that will try to find the best time scope according to the selected resolution An adjustment will typically happen if the selected time scope starts or stops at an odd time like for example a start time at 00 11 53 The auto scale function will then change the start time to 00 00 00 Auto scaling can be enabled disabled on the analysis toolbar 7 7 2 Limiting the analysis data Any SQL queries applied to the data source will be automatically applied to the analysis To change a query go back to the table view and change the SQL Query settings refer to section SQL Query In addition to the standard
19. 1100 A 3 2 4 Advanced Options For server based databases it is possible to be more specific about which tables that Should be listed in the table list Depending on the chosen list type tables belonging to the listed users will be included or excluded SmartChent User s Guide Release 4 0 Page 11 58 Basic Operations Advanced Options Shown in the table list i Tables views owned by current user only if Tables iv jews Short table names Filter tables views owned by these users Filter type C Include Exclude Llsername Add Excluded users Delete INFORMATION SCHEMA dbo wf DK X Cancel Figure 3 2 Advanced Options Tables views If checked only the tables owned by the user currently logged in owned is shown Otherwise all tables available to the current user is Shown in the form lt Table owner gt lt Table name gt Tables If checked available tables are shown Views If checked available table views are shown Short table If checked only the string after the last in the full table name is names shown I e if a table is called MYUSER SYSTEM VALVESTAT only the name VALVESTAT is shown in the table list Filter Include Only tables and views owned by the specified users will tables views be shown in the table list Exclude All tables and views owned by the specified users will not be shown in the table list 3 3 Save View As The Save View As dialog can be opened fro
20. 3 03 2006 16 44 49 23 03 2006 15 37 46 01 03 2006 13 37 26 19 03 2006 14 41 35 02 03 2006 11 17 56 23B_AI30197 Figure 7 14 Column descriptions Id Sequential number lt TAGNAME gt This field is equal to the field s selected when setting up the analysis If more fields were selected more columns would be shown here Time between pre warning time and trip alarm time If more pre warnings were found time is calculated from the latest pre warning Number of pre warnings occurred before alarm trip occurred Time when the pre warning occurred If empty no corresponding pre warning was found Time when the alarm trip occurred If empty no corresponding alarm was found Reaction Time Repeats TS PreWarning TS Alarm Grid presentation summation Alarm pairs Summation Histogram iu EAS E pet a eoun Jooseen Jumo arenge veamun Jwenn Tanereas 29F FT 35020 00 02 00 100 00 00 00 00 00 0 7 A 1 100 is below recommended reaction time T 23F XT 353013 00 02 00 E 100 00 00 05 00 00 05 00 00 06 1 D 100 i is below recommended reaction time E 23F TE 353027 00 02 00 2 100 00 00 00 00 00 00 00 00 00 0 0 Possible identical setpoints E 23F LT 500202 00 02 00 1 100 00 01 08 00 01 08 00 01 08 0 0 100 is below recommended reaction time 23F LT 500302 00 02 00 27 100 00 00 01 00 00 05 00 00 50 2 7 100 is below recommended reaction time E 23AFT45051 00 02 00 1 100 00 00 00 00 00 00 00 00
21. 7 07 01 723 50 08 040 EYLOG2 COMPRESSOR ALARM 1997 07 01 23 49 23 008 EVLOG2 COMPRESSOR ALARM 1997 07 01 23 4838 062 EVLOG2 COMPRESSOR ALARM 1997 07 01 23 495 08 066 EVLOG2 COMPRESSOR ALARE e Fetched 199 Records Query Active me Figure 6 3 To sort by more than one field hold down the lt SHIFT gt button on the keyboard and click on additional field headers with the mouse To remove the sorting of a field hold down the lt CTRL gt button on the keyboard and click on field header that should be removed from the sorting Even though all sorting is removed the data in the grid doesn t revert back to the state it had before the sorting began To show the data in the order it was before the sorting began press the Refresh button in the toolbar W Quick Sorting requires the grid to be in LoadAllRecords mode refer to section LoadAllRecords Mode 6 7 Quick Filter This feature allows the user to quickly filter data based on a specific field value without opening the SQL Query dialog The default filter values are set equal to the corresponding field values of the current selected record Quick Filter o x Fielgwalue Tagname MA Text wildcards Single char Multiple chars 213 Que Cancel Py Fieldname Figure 6 4 When changing the fieldname the default field value will be changed accordingly The filter will be added to any existing SQL filter and must be modified removed via
22. C the criteria should be KKS ZSC Y A wildcard is only valid for character fields Adding multiple criteria s OR To add another criteria to this query click on the Add to list button and the AND criteria just specified will be added to the criteria list In this example we now specify another criterion which singles out the events where Tagname equals EEF P 7075 and with PropertyBCount less than 15 The query should now look like shown in Figure 3 12 SmartChent User s Guide Release 4 0 Page 19 58 Basic Operations Query Definition Criteria AND Tagname Ej EEF P7075 Add to list PropertyBCount E 15 Update NotUsed H PO Reset All Test wildcards 2 Multiple chars 5 ingle char Criteria list DR Pseudo code Tagname H45 0 W 12244 AND Property Count 50 AND Descriptio Case sensitive query x Cancel Figure 3 12 When the Query button is pushed the SQL query statement will be composed by the statements in the list and the criteria in the AND section In this example the logical query will look like this Tagname HAS OV 12244 AND PropertyACount gt 50 AND Description Flare OR Tagname EEF P 7075 AND PropertyBCount lt 15 Wildcards single characters For all databases the _ underscore character is used as single character wildcard I e if you want to locate all Tagnames starting with HA T and HA S but want to exclude Tagnames star
23. Include field names as first line f Custom Destination file F1SmariLogiClientySCdatel Export Text SCexport td Em Export X Cancel The character used as separator for each field value in the exported text If Space aligned is chosen every field will be padded with spaces so that the length of the text always corresponds to the size of the field I e if the field size is 10 and contains the data Alarm the exported text would be Alarm 5 spaces added to the text The delimiter surrounding each field value If the Custom button is selected it is possible to specify any character If checked the first line in the export file will contain the field names This line will be formatted the same way as the record lines Select the browse button at the right of the control to specify the location and name of the export file SmartChent User s Guide Release 4 0 Page 29 58 Utilities 5 1 2 HTML Export The records are exported to one HTML file containing a table with all records 5 1 3 MS Excel Export The records are exported to an MS Excel worksheet The layout of the worksheet will be the same as shown in the SmartClient table grid I e the order of the fields the field alignment and the size of each field will be as shown in the table grid The file can be read by all MS Excel versions from 4 0 and up 5 1 4 XML Export The records are exported to a XML XSL file 5 2 Table Merge With t
24. SmartChent User s Guide Release 4 0 The information in this document is subject to change without notice and does not represent a commitment on the part of ABB A S ABB A S does not accept any responsibility for any errors that may appear in this document The software described in this document is furnished under a license and may be used only in accordance with the terms of such license The copyright of this work is vested in ABB A S and the documentation is issued in confidence for the purposes only for which it is supplied It must not be reproduced in whole or in part or used for tendering or manufacturing purposes except under an agreement or with the consent in writing of ABB A S and then only on the condition that this notice is included in any such reproduction No information as to the contents or subject matter of this document or any part thereof arising directly or indirectly therefrom shall be given orally or in writing or communicated in any manner whatsoever to any third party being an individual firm or company or any employee thereof without the prior consent in writing of ABB A S Use of this product is subject to acceptance of the SmartLogger license agreement included in this package ABB A S reserves the right without notice to make changes to its products as circumstances may warrant Other registered trademarks and trademarks used throughout this publication are the property of their respective owners Produ
25. analysis Filename Description ________________________ lt Name gt azt The analysis template The analysis log lt Name gt _RES db The results of the analysis database table lt Name gt _ALL db All ON OFF pairs of the analysis database table lt Name gt is the name of the template The template file is located in the lt Programpath gt AnalyzeTime directory while the other files are located in the directory specified by the ANLZTIME alias As default the ANLZTIME alias points to the lt Programpath gt AnalyzeTime Data directory W Do not edit modify or delete any of these files by yourself All configurations must be done with the SmartClient s Analyze Time tool SmartChent User s Guide Release 4 0 Page 55 58 Alarm Management Add on 7 8 3 Exporting results By right clicking with the mouse anywhere in the result grid it is possible to export some or all of the results to another format The results can be copied to the clipboard or exported to Text MS Excel HTML or XML files 7 8 4 Loading an analysis result It is possible to load view and or print an analysis performed earlier If the menu item Analyze Time Load Result is selected an Analyze Time result file can be re opened The same actions can be performed with this old analysis as with an analysis just executed The result table can also be opened and viewed like any other table The result table will like other SmartLogger tables c
26. ations will be performed on the local table This feature is especially useful when requesting data via slow networks Sort Toggles the sort order between ascending descending for the descending table views listed Single column Enables disables the use of multiple columns in the table list list Tables Lists all available tables for the selected alias that matches the specified filter Initial query settings Initial Instead of retrieving all records in a table it is possible to limit the query number of records initially returned All subsequent operations will be controls performed on this limited set of data However it is possible for the user to clear or modify this query after the initial opening of the table The dropdown list with fieldnames and the edit field for the query criteria is known as the initial query controls This button is only visible for aliases connected to server based databases like Oracle or MS SQL Server SmartChent User s Guide Release 4 0 Page 10 58 Basic Operations Advanced The same as the initial query except that a more advanced query can be query specified For information about the query builder refer to section SQL button Query BaseTime SQL settings Use Check to limit the time scope when the table is initially opened BaseTime SQL BaseTime Only visible if Use BaseTime SQL is enabled Refer to the description in SQL section BaseTime SQL settings 3 2 1 Supported ta
27. bles The SmartClient can be used against any table and not only the ones created by the Smart applications However there are a few limitations e Features like BaseTime SQL and Time View will only be available if a DateTime field is present in the table SmartClient will use the first DateTime field found unless otherwise specified by the user as described in section Field Customisation Panel e The maximum allowed fields in a table is 30 3 2 2 BaseTime SQL The BaseTime SQL is used to limit the number of records fetched from the table when it is initially opened When BaseTime SQL is not applied all records are fetched from the table when it is opened When BaseTime SQL is applied only records that fall within the specified time scope are fetched from the table Any further data manipulation like queries and analysis will only be performed on these records 3 2 3 Filter The filter is used to reduce the number of tables shown in the table list When working with Oracle tables the filter has an extra feature If the filter control is cleared and the Refresh button is pressed then all tables available to the current user will be shown not just the tables owned by the current user Tables owned by other users will be shown as lt user name gt lt table name gt in the table list and can be opened like any other SmartLogger table Filter example A filter with the value ESD will list the tables ESD_PROD19990200 and ESD1998
28. cremental fetching is enabled the total number of LoadAllRecords records in the dataset is unknown If this option is enabled a warning is issued when LoadAllRecords mode is about to be activated This is to inform the user that a lot of records might be loaded if the user continues Always open When enabled all table windows are maximized when opened table Show button for If checked there will be an extra button on the toolbar in the table windows This is used for detailed information about the current table and the SQL statements used to get data SmartChent User s Guide Release 4 0 Page 28 58 Utilities 5 1 Table Export The export utility makes it possible to export an entire table or part of it to another format than a database table SmartClient supports four different formats as explained in the following W The export utility operates on current the table view i e only records matching the active query sort and time view settings are exported 5 1 1 Text Export From the export dialog the text format can be customised to match any user requirements The Text Export dialog can be opened by selecting the menu item File Export Figure 5 1 Table Export Field separator Field delimiter Custom sep delim Include field names Destination file Field delimiter Nothing a Commas C Semi colons C Space aligned C Custom Custom separator Custom delimiter
29. ct rights 1998 2010 ABB A S All rights reserved Printed and manufactured in Denmark SmartChent User s Guide Release 4 0 Page 2 58 Contents E TMEFOGU CE ON isiianvecsssacaccntssncscraraccdsstraccuataacearantacecsasaeckeruesssnanneeracadneseesenssarsnareerssscees 5 Lrt Conventions and delito Sarria A 5 2 Installation ANG Set UD isis 7 21 SYSTEM requirements candidata dci A a coda 7 2 2 AMS lO Manada 7 2 5 Produce regiStracON antaras isis 7 3 Basic OPerFaION Sin AA 9 Sil MENU OVEVICW iriiria iiare a aaa a aa a didnt eaa aaa a aunts 9 J2 OPENING a tal risa AAA AAAA E AAA 9 ld SUPPONE la DIGS aa 11 S202 Basetime Ola ds 11 S225 PE ROPA PC o E EN 11 BeA Advanced OPUS arde 11 Or BWE VICW AS o do dl a E 12 SE PMsn ros 13 SE Page Seti dto titres 14 tez Report DESIG raisto rita dia 15 ao PVEM ora 16 So SO DUB oi 17 or QUS EXAMES ua 18 2O EA 0 O corde 20 GL A A O O 21 30 SUE SO Ea uta 22 5 9 Copy Selected record S urraca A 23 4 Maltenance rios 24 O A AO 24 Akk DataDasernsiasia ads adds 24 Az GRA LAVO cs anna 25 Alea COME SECU Das 26 A UA EXPORTAN eS ad ss 27 Ato Miscellaneous AAA AAA 27 Y DUNE A E 29 Sl TDI EXPO dicos 29 Jl TOXE EXPO iris AAA AA A E NEE ER 29 Sa TEM EDO Eat a asas 30 SiS IMSS EXC EXPONE a boca 30 So AMI EXDOFE A AS AA AO 30 Se ADS Medea 30 53 Database Alias Manager seiak aaa 31 Donk Database diver send Sita 32 5 5 2 Standard allas OPperatiONS ira 33 Srs Remote allas
30. e Open Table dialog can be opened from the menu item File Open or the associated toolbar button Only available if SmartLogger is installed on the same PC Only visible if the SmartClient is the special version for Windows Terminal Services and Citrix Only available if you have purchased and registered the Analyze Tools Add on Only visible if SmartClient is unregistered SmartChent User s Guide Release 4 0 Page 9 58 Basic Operations Database allas Table list filter LOGDATA y i E Tables ev __ _ ___ ________________ ___ Cache data to CACHEDDATA alias Single column list Sortdescending LOCAL KT 7 LOCALZO05vvEe0 PORT 20050300 PORT 20050400 PORT 20050500 ofa TEMLOG Initial query settings Tagname y rksxo Advanced 243 Base Time SQL settings Y Use BaseTime SQL Scope Previous hour y E Trace mode From 19 08 2005 20 00 00 E to 19 06 2005 y 20 59 59 X Cancel Figure 3 1 Open Table Database alias Contains all available aliases A button Advanced options Please refer to section Advanced Options Table list filter Filter input control used to restrict the number of tables shown in the table list Standard wildcards like and are accepted Refresh button Refreshes the list of tables Tables Views Cache data When checked all table records are cached to a local table before this table is opened All subsequent oper
31. e data source is analyzed Refer to section Limiting the analysis data for creating or modifying filters Time scope This shows the actual time scope that will be used for the analysis Refer to section Limiting the analysis period for information on changing the analysis period Pressing the Execute button starts the analysis and the final result will be presented in a data grid and as a graphical presentation as shown below Grid presentation Events Result Chart Messages Pe mi fs DGETI 7 BM TE 15 03 2005 4456 a 15 03 2005 aanne 440 E 15 03 2005 HI 3614 Figure 7 6 Column descriptions Period From Indicates the analysis period Only relevant if a resolution has been selected Priority The priority value from the data source Count Alarm count for this period and priority Graphical presentation SmartChent User s Guide Release 4 0 Page 41 58 Alarm Management Add on Events Result Chart Messages Ea lt lt gt D 0 i Priority distribution analysis for MERGED 2005 03 15 00 00 00 gt End of table Chart period 2005 03 15 00 00 00 gt End of table Page 1 1 Figure 7 7 The graphical presentation shows the different priorities in overview 7 4 Alarm Frequency analysis The alarm frequency analysis is usually used to locate the top most alarms within any specified time period Depending on the initial settings it can be used for other purposes as
32. e following must be specified 1 The fields to include in the analysis in order to make an event unique 2 Whether the analysis should be performed on the entire table or only on the records limited by any query or time view settings If the analysis must be performed on the entire table the checkbox labelled Apply query and time limitations must be unchecked 3 Any number of objects with corresponding ON and OFF criteria s SmartChent User s Guide Release 4 0 Page 52 58 Alarm Management Add on Example Add object manually In the table below there are 4 events each with different properties in the fields Tagname EventTexti and EventText2 EventText1 EventText2 XYZ PUMP 1234 Running XYZ PUMP 1234 XYZ PUMP 1234 XYZ PUMP 1234 Stopped If you for example want to analyze the time that the pump has been running the time between Running and Stopped in EventText1 then you must configure the analysis for using both the Tagname and the EventTextl1 fields It would not be enough just to use one field Tagname in the analysis as this would also inadvertently include the Fa ure events You will then have to add an object to the analysis as shown in Figure 7 23 Add analysis object x Object name Export Pump OM criterias OFF criterials Taqname Tagharme Y 2 PUMP 1 34 KY Z PUMP 1 23d Event Text Event Text Running stopped HOT USED HOT SEDO X
33. e name SMARTLOG Figure 5 6 SQL Server The registered name of the SQL Server where the database is name running Using the MS SQL Server Enterprise Manager this registration can be performed Default user The default user name that is used if automatic database login is name disabled Database name The name of the database containing the SmartLogger tables Table open list Defines how long the table list is cached in memory A new table list cache time is not fetched from the database server before the cache time expires AutoCommit If enabled the BDE automatically commit records to the table after enabled each post If disabled the application decides when to commit the records Please note that this setting is only relevant for applications that actually write to the database like SmartLogger or SmartTranslator Possible cache time values The table list is cached as long as the program is running This should only be used for static databases where no tables are added after the program is started The table list is never cached This will increase network traffic as the table list is fetched directly from the database server every time it is requested The table list is cached the number of minutes specified 5 3 2 Standard alias operations Create an alias The following describes the procedure for creating a new standard alias 1 Press the New button 2 Type in the name for the new alias Smar
34. eaction time is shown as delta t at SmartChent User s Guide Release 4 0 Page 45 58 Alarm Management Add on At In order to execute the Reaction Time analysis a pre warning filter and an Alarm Trip filter must be defined rer Analysis settings Date limitation Unique field s Ig Fre warning Filter H1 warnings y ki if lt Not Lised gt y Alarm Trip Filter H2 Alarms y Ol Extra field lt Not Used gt y Time scope 2004 10 15 00 00 00 gt End of table Figure 7 13 Analysis settings Unique The analysis must pair together records returned from the two selected fields filters For that purpose one or more reference fields that makes the event unique is needed Many system vendors have a Tagname or Objectname reference that will be sufficient but in some cases additional selections are required Extra field This setting is not required for the analysis but might add valuable information to the result lists If for example a Description field is available then this field can be chosen and informative texts will be added to the tagname references Data limitation Pre warning Specifies the filter that identifies the pre warning alarms typical H1 Hi filter or L1 Lo alarms Alarm Trip Specifies the filter that identifies the trip alarms typical H2 HiHi or filter L2 LoLo alarms Time scope This shows the actual time scope that will be used for the analysis Refer to
35. entrifuge Pump BY Run 30 12 2004 23 50 27 KRT ESDV 85943 0 Shutdown Fuel Gas Opening 30 12 2004 23 51 27 OAM PUMP 24576 R Mezz Oil Pump 30 12 2004 23 52 27 AJEYT KWS XCV 53053 Prod Drain Valve FF 30Open 30 12 2004 23 53 27 WUL P 6002 Centrifuge Pump Running 30 12 2004 23 54 27 BJEVT KRT BDV 1124 Turbine Blowdown Opening 30 12 2004 23 55 27 OAM PUMP 24576 Mezz Oil Pump P12 G0 Rumning 30 12 2004 23 56 27 BJEYT KRT BDW 1124 0 Turbine Blowdown 30 12 2004 23 57 27 ET OPS PUMP 236 R West Water Pump P12 BOfRun 30 12 2004 23 58 27 KRT ESDV 85943 Shutdown Fuel Gas 2 9fOpen 30 12 2004 23 59 27 KRT BDW 1124 C Turbine Blowdown 100 31 12 2004 00 00 07 1QEVT KWS XCV 53053 Prod Drain Valve 110 Closed 1 12 2004 00 01 27 IB ALM OPS PUMP 236 F West Water Pump Failure 31 12 2004 00 02 27 14AM o PLI LSL 34567 130 Alarm 31 12 2004 00 03 27 1 KRT ESDV 85943 C Shutdown Fuel Gas Closing 31 12 2004 00 04 27 1EVT KRT ESDV 85943 Shutdown Fuel Gas 150 Closed 1 12 2004 00 05 27 WEVT KRT BDW 1124 Turbine Blowdown Closed 31 12 2004 00 06 27 18 EVT PLI LSL 34567 170 Mormal 31 12 2004 00 07 27 HJO TAHH 1122 Surge Level 180 Alarm H2 31 12 2004 00 08 27 201 4LM WSA TAL 32177 L1 Production Slow Tank 15 190l Alarm L a 4 Page 1 of 20 Pages Paper Size 210 mm x 297 mm Status Ready 7 Figure 3 7 3 5 SQL Query A query is a powerful tool for extracting useful information from tables It can for example be used t
36. er footer grid bands e Colours grid header footer e All fonts used e Behaviours 3D effects graphics The report designer can be opened from the Preview dialog refer to section Preview SmartChent User s Guide Release 4 0 Page 15 58 Basic Operations Report Designer aa le x Options Colors Fonts Behaviors Show ee Ee E Bands Axisymmetric shape Iv Headers I Footers Y a Group Footers e Preview Y Auto Calculate Preview Lines Preview Line Count f1 Grid Iv Grid BY odes re Group Footers Grid Simple extrusion surface Miscellaneous A fv Flat CheckMarks Display CheckMarks as Text Draw Mode Strict Title Properties Cancel Apply Figure 3 6 3 4 3 Preview Shows how the actual report will look when printed All print set up dialogs can be accessed from the preview dialog including a few additional like the page background configuration W Holding down the CTRL button and spinning the mouse wheel will zoom the print preview in out SmartChent User s Guide Release 4 0 Page 16 58 Basic Operations E Print Preview A E SEE File View Format Go 4460 48 S20 B B amp 100 es H oe Margins Left 20mm Top 20mm _ Right 15mm Bottom 20mm deader 10mm Footer 10 mm A i SmartClient Table Report Source Table LOGDATA AM_AR_500 lLogDate ld EventType Tagname Description ProcSec PropACount 30 12 2004 23 49 27 WUL P 6002 R C
37. er s Guide Release 4 0 Page 13 58 Basic Operations Printer Name BY HP LaserJet 1200 Series PCL gt e sae Ready Network Type HP LaserJet 1200 Series PCL Where IP 192 168 1 109 Comment Print to Elle y Browse Copies Fage range a Al Number of Pages Current Page Number of Copies Pages Collate Copies Enter page number and or page ranges separated by commas For example 1 3 5 12 Print Styles Preview Cancel Figure 3 4 Ny Printing requires the grid to be in LoadAllRecords mode refer to section LoadAllRecords Mode 3 4 1 Page Setup Determines the layout of everything outside the data area like e Page sizes print orientation print order e All margins e Header footer texts e Report scaling SmartChent User s Guide Release 4 0 Page 14 58 Basic Operations EN Page Setup SmartClient Standard o no x Style Name Emartcient Standard Page Margins Header Footer Scaling Orientation Paper a Portrait C Landscape 57 Kal Envelope DL Dimension Print Order width 210 00 mm y C Down then over Height 297 00 mm H a Over then down Paper source s Automatically Select gt Print using gray shading Figure 3 5 W To exclude fields from a report please refer to section Field Customisation Panel 3 4 2 Report Design Determines the layout of the report data like e What to show head
38. es 7 3 Alarm Priority Distribution analysis The alarm priority distribution analysis is used to benchmark or verify the alarm distribution for the available priority levels EEMUA recommend a 80 15 5 distribution which means that the alarm distribution should be about 80 warnings 15 alarms and 5 critical alarms As for the other analysis types this analysis can be used for other purposes as well depending on the initial set up This could be SmartChent User s Guide Release 4 0 Page 40 58 Alarm Management Add on e Alarm distribution between plant sections e Alarm distribution within specific modules or type circuits by filtering on module and analysing on alarm type The following shows a typical set up for an alarm priority distribution analysis Priority distribution analysis for 12520041015 eee Analysis settings Data limitation Resolution lt None gt y Alarm filter ABB_Alarms 2 Ol A Priority field Priority Time scope 004 1075 00 00 00 gt End of table Figure 7 5 Analysis settings Resolution The analysis can be divided into time periods like a day based analysis for a complete month When specified the graphical presentation will have a corresponding number of pages Priority field Specifies the field in the table containing the priority identification Data limitation Alarm filter Specifies the filter to be used on the data sources If no filter is selected then the complet
39. etup 4 1 3 Color Setup Customize Colors x jootetalseicen cor Pr Coles 1 Background Bee sonora 2 e screen Color Print Color Screen Color Print Color nee Sich a A Print Color d Screen Color Print Color a gt E 5 screen Color Print Color Grid color E screen Color Print olor P Frint Color a Print Color g screen Color Print Color X Cancel Figure 4 3 For each of the color Id s from 1 16 it is possible to specify which color should be used for the matching record on screen an on a printout To change a color simply select a Color Id in the grid and set the desired color It is possible to select from a number of standard colors but a user defined color can also be composed selected as shown in Figure 4 4 SCreen Print l QOM DANNA OMO DORA MA CAMA COM US eee EUS DONA UN mom Custom Colors Custom Colors O Figure 4 4 SmartChent User s Guide Release 4 0 Page 26 58 Maintenance 4 1 4 Export directories Database Grid layout Export directories Miscellaneous HTML export directory PAsmartLog Client SClatay Export H TWIL Fyomarnlog Client sCDatas Exporte Figure 4 5 Export directories Text export Default destination directory for Text exports MS Excel export Default destination directory for MS Excel exports HTML export Default destination directory for HTML exports XML export Default destination directory fo
40. formed a start stop cycle SmartChent User s Guide Release 4 0 Page 51 58 Alarm Management Add on How many times a certain valve has gone from open to close The total running time for a pump The min avg max running time for a pump The min avg max travel time for the valve In addition to this the Analyze Time module will detect signal flicker if one of the analyzed objects has this problem Signal flicker can occur if there for example is a bad connection in a valve s closing switch so that the switch generates two events every time valve is closed The Analyze Time configuration dialog shown in Figure 7 22 can be opened by choosing Analyze Time Config Run from the menu A configured analysis can be saved to disk The file saved is called an Analyze Ny Time template and describes all objects pumps valves etc and analysis settings for one analysis Analyze Time A4nlzTimellsg Ed UGDEMO ANLZ TIME Open Hse O New Save As Analysis fields 1st field Tagname end feld EventText1 y 3rd field MOT USED y M Apply query and time limitations Defined objects Add Modify Delete DN criteriats OFF criterias Tagname Tagname xYZ PUMP 34 xYZ PUMP 234 Event Text Event Text Running stopped Main Export Valve NOT USED NOTUSED EU Analyze X Cancel Figure 7 22 7 8 1 Designing an analysis In order to perform an analysis th
41. ger supplier to obtain a new license file SmartChent User s Guide Release 4 0 Page 8 58 Basic Operations 3 Basic Operations 3 1 Menu overview File Opens the Opening a table dialog Open current SL Opens the currently active SmartLogger table tables Closes the active table Close All Closes all active tables and disconnects from all databases Opens the Save View As dialog Export Sub menu for exporting the active table to a Text Excel HTML or XML file Exit program Opens the SOL Sort dialog Opens the Time View dialog Tools Opens the Database Alias Manager tool Opens the Table Merge dialog Opens the Options dialog WTS Information Shows miscellaneous information about the current WTS settings Refer to section WTS Information Alarm Gives access to the different alarm management Mat functionality as explained in section Alarm Management Add on Window Tile Horizontal Tiles all open tables horizontally Edit Copies selected record s to the clipboard Opens the Find Record dialog Tile Vertical Tiles all open tables vertically SQL Query Opens the SQL Query dialog Cascade all open tables Minimized main window Quick access to all currently opened tables If a table is minimized it will automatically be maximized Shows this User s Guide in PDF format 4 Registration Opens the Product registration dialog Shows the credits and the release version 3 2 Opening a table Th
42. he Table Merge function it is possible to merge multiple tables with the same structure into one table This is useful if for example data is stored in monthly tables but an analysis covering the entire year is needed In order to perform a merge all source tables must have exactly the same table structure This means equal number of fields identical field names identical field sizes etc An exception is character fields where different field sizes are allowed The Table Merge dialog can be opened by selecting the menu item Tools Table Merge Table Merge Source database alias Merge filter USERDATA No filters Available ValvesLevell ValvesLevels ValvesLevelS ValvesLevelb Destination table Table name USEROAT A Prodlevely alves Add source table name as last field Open destination table after successful merge Figure 5 2 Table Merge Source Database Alias Specifies the location of the source tables SmartChent User s Guide Release 4 0 Page 30 58 Utilities Merge filter Optional filter that can be applied to each table before it is merged Thereby only specific records will be included in the merged table Refer to section SQL Query for a description of how to specify filters Available Lists all available tables for the selected alias Chosen Lists all tables selected for merge Up Down arrows Use these arrows to change the merge order The tables are merged in the li
43. hed or a new dataset is fetched with for example SQL Query or SQL Sort Due to the loading time it is highly recommended to limit the number of records to max 30000 using queries and or Time View before the LoadAllRecords mode is activated 8 2 Desktop versus Server databases This section describes some important differences between the two types of databases 8 2 1 Desktop databases Paradox Desktop databases do not have a real SQL engine supplying remote clients with data matching specific SQL queries The client therefore has to retrieve all records from the remote Desktop database and then parse the records locally This means that all records are transferred over the network from the database to the client even though maybe only 1 record matches the query For Desktop databases the network speed is crucial to how fast a query executes Desktop database restrictions It is recommended that tables are kept relatively small i e less than 150 000 entries This ensures reasonably performance for the SmartClient when executing sorting and querying operations SmartChent User s Guide Release 4 0 Page 57 58 Appendix For speed considerations it is also recommended to enable incremental fetching refer to section Database 8 2 2 Server databases Oracle or MS SQL Server Server databases contain a real SQL engine which enables them to process SQL queries locally and then only send the query result set to the cl
44. ient For Server databases the network speed will be of less importance since it is possible for the client to limit the number of records actually sent over the network 8 3 WTS Information The WTS information dialog can be opened from the menu item Tools WTS Information Please note that this menu item is only available if the SmartClient is the special WTS version The information shown in Figure 8 2 is the current user s individual WTS settings ta WTS Information Aliases CC WINZOOO Smartclient UserData CACHEDDATA Ci1WINZ0004 dmartClient CachedData ANLETIFME C WINZ0001SmartClienttAnalyzeTime Data ANLAFREG C WINZOOO dmartClient AnalyzeFreg Other information WTS homedirectory C 1WINZ000 SmartClient Figure 8 2 SmartChent User s Guide Release 4 0 Page 58 58
45. ime min Maggie 0 Default user name scott FT AutoCornrnitenabled Figure 5 5 Oracle 8 settings Net8 Service Defines the Oracle Net8 service name Must be defined in advance name by using the appropriate Oracle tool Default user The default user name that is used if automatic database login is name disabled AutoCommit If enabled the BDE automatically commit records to the table after enabled each post If disabled the application decides when to commit the records Please note that this setting is only relevant for applications that actually write to the database like SmartLogger or SmartTranslator Table open list Defines how long the table list is cached in memory A new table list cache time is not fetched from the database server until the cache time expires Possible cache time values SmartChent User s Guide Release 4 0 Page 32 58 Utilities The table list is cached as long as the program is running This should only be used for static databases where no tables are added after the program is started The table list is never cached This will increase network traffic as the table list is fetched directly from the database server every time it is requested The table list is cached the number of minutes specified MS SQL Server 7 2000 MSSQL driver MS SOL Server SOL Server name Table list cache time min flocsrvd1 i Detault username nancy M AutoCommit enabled Databas
46. ion interval Top 50 y Detault graph orientation Horizontal y E Alarm rate Detault resolution 2 hours y Operator response time limultiple alarms calculate time fram first alarm Recommended maximum response time 00 05 00 an Reaction time limultiple pre warnings calculate time from last pre warning Recommended minimum reaction time 00 02 00 ES Figure 7 21 Frequency amp Alarm rate Default Default selections used when the corresponding analysis is opened Operator Response Time If multiple Should normally be checked alarms Recommended For future use maximum Reaction Time If multiple pre Determines which pre warning to use in case of multiple pre warnings warnings Should normally be checked Recommended Used for alarm summation calculations Alarm pairs with reaction minimum times less than recommended minimum reaction time are included in the Below value Refer to section Reaction Time analysis for more details 7 8 Analyze Time Analyze Time is a tool for calculating elapsed time between two specific events and is a part of the Analyze Tools add on In the SmartClient terminology the two events used for calculating elapsed W times are called an ON criterion and an OFF criterion In the process industry this Analyze Time function can be used for many different purposes like calculating e How many times a certain pump has per
47. ll the runtime messages that the analysis generates are listed Object list section The object list grid has the following fields Object The name of the analysis object Match The number of ON OFF pairs found for the specified object Min Time The shortest time found between any ON OFF pair Avg Time Average time between all ON OFF pairs Max Time The longest time found between any ON OFF pair Tot Time The accumulated time for all ON OFF pairs Warnings The number of warnings generated for the object Status Pending waiting for calculation Calculating currently calculating times Done analysis for this object is finished The results can be printed using the Print or the Print Preview button to the right of the grid During the analysis the SmartClient creates a separate table that contains all ON OFF pairs This table is named lt Analysis name gt _ALL and can be opened just like any other SmartLogger table Pressing the View On Off button will open the table and at the same time minimize the Execution Status dialog Runtime messages section All relevant status information warnings and errors are listed in the message window The information is written to an analysis log when the analysis is finished The log file is named lt Analysis name gt atr The runtime messages can be printed using the Print button located to the right of the message window Analysis files The following files are generated during an
48. m the menu item File Save View As or from the associated toolbar button SmartChent User s Guide Release 4 0 Page 12 58 Basic Operations Table Save As Paradox only x Database allas Table name JUGDEMO y NEWTABLE Currenttables DEMO 19990309 Esb_PRO I9990200 Fa _LEWEL 19990922 FG_PO19981015 PRODUCTION S 90311 PRODOCTON19990501 PRODUCTIONT 9990512 ESTISs 70701 Figure 3 3 Save View As Database alias Specifies the destination database alias Note that only Paradox aliases are listed here Table name Specifies the name of the new table Current tables Contains all available tables for the selected database alias The Save View As feature will save the active table view to a new Paradox table This means that only the records matching the active table s current sort query and time view settings will be saved to the new table This feature can be used to make subsequent analysis much faster since it is possible to store the relevant events in a separate table and perform the analysis on this new and reduced table instead 3 4 Print SmartClient uses an advanced printing system with a lot of advanced features This User s Guide only describes the use of the most essential parts on the printing system but the user is encouraged to experiment with all the other features it offers The Print dialog can be opened from the menu item File Print or from the associated toolbar button SmartChent Us
49. n overview of the menu layout Toolbar left Toolbuttons for fast access to the most common functions Toolbar right Table navigator for moving around the active table and On Off buttons for the Query Sort and Time View functions Table area View area for open tables Status bar Shows the status for the auto refresh function 1 1 Conventions and definitions W Important note Alias Database alias specifying database parameters like path and database driver SmartChent User s Guide Release 4 0 Page 5 58 Introduction AM BDE Control Dataset Dialog Event Field MDI PDF Record SQL WTS Alarm Management Borland Database Engine A set of DLLs and support files that allow programs to access databases The term control is used when describing the user interface A control is a common name for edit boxes push buttons and other items on a dialog A collection of records fetched from the database server or the local database A dialog is a window designed for user input A common name used in the process industry for an occurrence which is reported to an operator and or a printer An event in the SmartLogger terminology means a sequence of characters normally sent to the printer followed by a carriage return A field corresponds to a column in a database table Multiple Documents Interface Adobe Portable Document Format This is the format used for the online User s Guide A reco
50. ng must also be ensured e The client computer must have full access to the network destination I e the directory specified in the destination path must not be write protected e All BDE programs SmartLogger SmartClient must use the same NET DIR path This setting can be changed verified from Control Panel BDE Administrator Configuration tab sheet Drivers Native Paradox SmartChent User s Guide Release 4 0 Page 34 58 Quick Access Funktionality 6 Quick Access Funktionality 6 1 The quick access functionality is a menu that pops up when right clicking with the mouse anywhere in the table grid Copy to clipboard The same functionality as described in section Copy selected records 6 2 Field Customisation Panel 6 3 When selected a panel is shown to the left of the table grid LogDate 30 12 2004 23 49 27 Id 30 12 2004 23 50 27 Event ype E 30 12 2004 23 51 27 Tagname 30 12 2004 23 52 27 Description 30 12 2004 23 53 27 ie EMP BEYT Dae cou y ro een e PRA 20 12 2004 23 56 27 POPEL a unit 30 12 2004 23 57 27 ene 30 12 2004 23 58 27 PropCEount 30 12 2004 23 59 27 31 12 2004 00 00 07 31 12 2004 00 01 27 Date Time field LogDate y 500 Records az Figure 6 1 The Field Customisation Panel can be used to hide show or rearrange the fields in the grid This is especially useful when irrelevant fields should be excluded from a printed
51. o Exclude irrelevant records Find out how often certain items have performed a specific action Find out how many times a specific entry occurs Locate a specific event The query dialog is used to set up the query definition and can be opened by selecting the menu item Table Query SmartChent User s Guide Release 4 0 Page 17 58 Basic Operations Query Definition Criteria AND Taoname E EPka eto st PropetyBCount P IS Update Property ns Beet IE 0 Text wildcards lt tmMultiple chars Single char Criteria list OF Pseudo code Tagname EPH 215 1 304 Tagname 4E5 EP 1304 AND Propertp Count 00 Tagname 54 1 PUMP 1 2 Delete Delete all Case sensitive query M Cancel Figure 3 8 Criteria One AND criteria is composed by up to 4 field criteria s AND ed AND together This AND criteria can be added to the criteria list Criteria list The criteria list holds a number of AND criteria s that at the time the OR query executes are combined to one SQL statement Criteria If a field is a numeric field a small criteria button will be visible buttons between the field name and the edit box This button can be used to specify a range of numerical values When it is pushed it toggles between lt gt and lt gt Case If checked only text that exactly matches the query criteria is sensitive accepted e Pump Control does not match PUMP CONTROL query L
52. o 12 hour clock AM PM 2 3 Product registration When SmartClient is started for the first time after installation the registration dialog will appear Active license file Select license file owystem code 173 00 00 29 2A B2 B8 License status Unable to locate the license file Expected location NO LICENSE Fvsmartlog smartshared To register this product you must send an e mail containing a license request file to your local SmartLogger supplier The location of the license request file is shown below Fsmanlog smartshared sLlicenseRequestslr A few days later you will receive a valid license file which must be placed in the same directory as the request file Figure 2 1 SmartChent User s Guide Release 4 0 Page 7 58 Installation and Set up The dialog can also be shown by selecting Help Registration from the menu If a license file is available this can be applied by pressing the Select license button If no license file is available you must send the icense request file to your local SmartLogger supplier for registration The license file is hardware dependent It is therefore very important to generate the license request file on the computer intended for running the SmartClient application When a valid license file is registered the Registration dialog can no longer be called up from the menu If you wish to purchase add on s like Analyze Tools later on you have to contact your local SmartLog
53. o the field s selected when setting up the analysis If more fields were selected more columns would be Shown here Recommended Shows the Recommended minimum reaction time used for this analysis The value can be changed from the analysis options dialog refer to section AM Options Count Number of alarms pairs found for this tag Below Number of alarm pairs in percentage where the reaction time was below the recommended minimum time Minimum The minimum reaction time found Average The average reaction time for all alarm pairs Maximum The maximum reaction time found W repeats The total number of pre warnings found A low W Repeats Count ratio indicates improper alarm set points A repeats Number of alarms in Alarm Trip mode repeating H2 alarms A high A repeats Count ratio indicates scattering alarm in Alarm Trip mode Comment Supplementary auto generated descriptions about possible bad actors Histogram for selected tag Pressing the Histogram ll button a graphical presentation of the reaction times for the selected tag is shown Alarm pairs Summation Histogram By Gb lt K lt gt If Reaction Time analysis for UG Sample Data 2006 03 01 00 00 00 gt End of table 1 1 1 1 1 1 1 1 I 1 1 1 1 1 1 1 1 1 1 A l 1 1 I 1 I 1 1 I 1 I I I I I 1 i i 00 10 ast A A A A eerie A ig tae a 0 eka pl canis gitar ish ahs e a ane ve jes wear Li er aaa a TA oma eA a Cine eat a ance eee Dearie 1 1 1
54. oad Load a previously saved query definition Save Save the current query definition to a file 3 5 1 Query examples Exact match If you want to see all records where the Tagname field contains the exact string HAS OV 12222 you simply enter Query Definition x Criteria AND om y Has Ov 12244 Add to list Figure 3 9 Will be disabled if the database does not support case sensitivity A query can only be loaded if field names types used in this saved query matches the table structure of the current table SmartChent User s Guide Release 4 0 Page 18 58 Basic Operations Combined AND criteria If you in addition to the Tagname criteria only want to look at records where PropertyACount is greater than 50 then you additionally enter Query Definition x Criteria ANID Tagname y HAS O v 12244 Add to list PropertyACount Y gt 50 Update Figure 3 10 Using multiple character wildcards If you in addition to the criteria s above only want to look at records where Description starts with Flare then you must enter Query Definition x Criteria AND Tagname y Has Ow cedd Add to list PropertyACount y gt 50 Undete Description x Flares Beset All Figure 3 11 It is also possible to use multiple wildcards in a single criterion If you for example want to extract all records where the Tagname starts with KKS and contains the characters ZS
55. ontain a LogDate field For all entries in the result table the LogDate field will contain the Date Time when the analysis was started SmartChent User s Guide Release 4 0 Page 56 58 Appendix 8 Appendix 8 1 Grid modes The table grid works in two different modes dependent of the operation chosen by the user The different modes are described in this section 8 1 1 Normal Mode This is the default mode of the grid when a table is initially opened Only the records visible in the grid are loaded into memory When scrolling through the table the records that become out of sight are removed from memory and new ones are loaded 8 1 2 LoadAllRecords Mode Some of the more advanced features like Print Grouping Mode and Quick Sorting Mode require that all records in the current dataset are loaded into memory When needed SmartClient automatically shifts to this LoadAllRecords mode LoadAllRecords mode overrides the use of incremental fetch which means that all records matching the current query or Time View settings will be fetched As this mode is slower than the normal grid mode it is only activated when required by one of the features mentioned above When SmartClient activates this mode the message shown in Figure 8 1 will be displayed while the records are being loaded Activating Load llHecords mode Pleaze wait Ela E Figure 8 1 SmartClient will stay in LoadAllRecords mode until a table is refres
56. r XML exports 4 1 5 Miscellaneous Options Database Grid layout Export directories Miscellaneous T able refresh Enable automatic refresh NA iW Go to last record after refresh Other Include field names in copy to clipboard LoadallRecords records warning limit 20000 7 iw Always show Load llRecords warning when incremental fetch is enabled Always open table in maximized window i Show button for detailed SQL and database information Figure 4 6 Miscellaneous Table refresh Automatic refresh When enabled all tables currently opened will be automatically Refresh int refreshed using the interval specified in Refresh interval Go to last If checked the table cursor is moved to the last record after a refresh manual or automatic has been executed This operation Should be used carefully when viewing large tables as it may SmartChent User s Guide Release 4 0 Page 27 58 Maintenance take some time to perform Miscellaneous Other Include field When this option is checked the first line in the copy will contain names the field names LoadAllRecords Some functionality requires the grid to be in LoadAllRecords records warning mode refer to section LoadAllRecords Mode Switching to this mode may take a while if the dataset contains many records If the number of records exceeds the limit specified here the user is given a warning Always show When in
57. ration Up Down arrows Use these arrows to change the sort order Fields can be moved between the list boxes by double clicking on the field name or by using the move buttons in the centre of the window To reset the sort order remove all fields from the Fields to sort list box and click OK Although the records are re fetched from the database server the records are W only sorted in the table grid I e the underlying source table is not affected 3 9 Copy selected records This feature can be accessed from the menu item Edit Copy To select more than one record do one of the following e Press and hold down the SHIFT key while pressing the up down key e Press and hold down the CTRL key while selecting records with the mouse e Select a record with the mouse hold down the SHIFT key and select another record All records in between these two selections will now be selected To copy the selected records to the clipboard use one of the following methods e Select the menu item Edit Copy e Right click in the table grid to bring up a small copy export menu SmartChent User s Guide Release 4 0 Page 23 58 Maintenance 4 Maintenance 4 1 Options The Options dialog can be opened by selecting the menu item Tools Options 4 1 1 Database Figure 4 1 Database Database auto login Limit number of records Incremental record fetching Default alias Table caching ES x Database Grid layo
58. rd is one row of data one event in a database table Structured Query Language Standard language for accessing databases Windows Terminal Services Used in connection with the SmartClient version supporting WTS and Citrix servers SmartChent User s Guide Release 4 0 Page 6 58 Installation and Set up 2 Installation and Set up 2 1 System requirements Computer A 100 IBM PC compatible computer with a Pentium III 500 MHz processor and 128 MB RAM 256 MB or more recommended Supports a screen resolution of 800x600 but 1024x768 or higher is recommended Operating system Windows 2000 2003 XP Disk space 30 MB free space for system files and additional space for log tables 2 2 Installation 1 Place the SmartClient CD in the CD ROM drive 2 If autorun is activated on the PC the installation will automatically start If it does not start run Setup substitute with your CD drive letter 3 Follow the instructions on the screen Online User s Guide The online User s Guide is available from the menu item Help User s Guide To view this User s Guide you must have Adobe Acrobat reader 6 0 or higher installed on your system The Acrobat Reader software can be downloaded from http www adobe com Adobe Acrobat reader is copyright of Adobe Systems Incorporated Windows time format Regardless of the Windows time settings the SmartClient always uses 24 hour clock even though Windows might be set up t
59. rent Number of different alarms found Top 10 Alarm load in percent from top 10 alarms Top 20 Alarm load in percent from top 20 alarms Top 50 Alarm load in percent from top 50 alarms 7 5 Operator Response Time ORT analysis The operator response time is defined as the time from an alarm arises until the operator performs an acknowledgement The Operator Response Time analysis measures the response times for all alarms over a certain period of time If there are many situations where the operator has too long response times this indicates a potential alarm management problem In order to execute the ORT analysis an alarm filter and an acknowledgement filter must be defined Operator Response Time analysis for AM_Samples al Analysis settings Data limitation Unique field s TAGNAME Alarm Filter Critical alarms k f lt Not Used Ack Filter Critical_ack Dg Priority field lt Not Used Time scope 2004 10 31 10 70 00 gt 2004 10 31 23 09 59 Figure 7 11 Unique fields The analysis must pair together records returned from the two selected filters For that purpose one or more reference fields that makes the event unique is needed Many system vendors have a Tagname or Objectname reference that will be sufficient but in some cases additional selections are required Priority A priority field is not needed for the analysis but can be useful information when looking at the analysis result
60. rm per 10 minutes under normal conditions Although this is an alarm rate analysis tool it can also be used for other purposes as well Depending on the initial settings it can be used for e Alarm Event rate analysis e Alarm peek detection e Alarm rate analysis for specific process areas or process units The following shows a typical set up for an alarm rate analysis where the results can be compared to the EEMUA recommendation re Analysis settings Data limitation Resolution fio minutes y Alarm Filter ABB Alarms SN Bl Time scope 2004 10 15 00 00 00 gt End of table Figure 7 2 Analysis settings Resolution Specifies the alarm count resolution If a 10 minutes resolution is selected then the number of alarms for each 10 minute interval is reported Data limitation Alarm filter Specifies the filter to be used on the data sources If no filter is selected the complete data source is analyzed Refer to section Limiting the analysis data for creating or modifying filters Time scope This shows the actual time scope that will be used for the analysis Refer to section Limiting the analysis period for information on changing the analysis period Pressing the Execute button starts the analysis and the final result will we be presented in a data grid and as a graphical presentation as shown below Grid presentation SmartChent User s Guide Release 4 0 Page 39 58 Alarm Management Add on
61. rt Messages a Fei Rect Tagname oom 1 Percentage 2 poz 173 5 64 EL 30120091 173 5 64 El 40147034 148 4 82 El 5 FIT41276 102 3 32 El 5147041 97 3 16 7 LIC10004 51 2 64 8 FIT105045 TA 241 9142716 70 2 28 B 10142707 60 1 95 11 PITa1219 48 156 Figure 7 9 Each row in the result grid represents one unique alarm or alarm type depending on the analysis settings For each row the total number of occurrences count and the percentage load from this item is shown The percentage load is calculated as Count divided by Total alarms 100 Graphical presentation Result Chart Messages lt lt gt gt MEA E E ll gt Frequency analysis for 125 20041015 2004 10 15 00 00 00 gt End of table Total 3070 Different 336 Top 10 30 Top 20 50 Top 50 65 127 3 4 5 6 86 9 1011 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 lt Click on barto see field values gt Page 1 12 Figure 7 10 The graphical presentation shows the chosen Top XX alarms The number of bars to be shown per page can be selected from the drop down control on the toolbar Clicking on a bar will show the object the bar represents The textbox to the right shows a number of benchmark figures SmartChent User s Guide Release 4 0 Page 43 58 Alarm Management Add on Total The total number of alarms found in the data source Diffe
62. sted order meaning that events in the first table will be positioned at the top of the destination table Destination table Table name Name of the new table to be created Pressing the small button to the right of the table name will call up the Table Save As dialog t Add source table name as If checked the Merge operation will add an extra field to last field the destination table This field will for each record contain the name of the source table Open destination If checked the Merge dialog is closed and the new table is opened immediately after successful merging 5 3 Database Alias Manager A database alias is needed in order to access a database It defines the database driver connection parameters and the destination path database type The Alias Manager can be used to add modify and delete aliases with the restriction that only the basic settings like database driver destination path database default user etc can be changed Normally the user only needs to access the basic settings as the Alias Manager automatically configures all advanced settings If it is required to access the more advanced alias settings the BDE Administrator tool has to be used The BDE Administrator can be started by selecting Settings Control Panel BDE Administrator from the Windows start menu The Alias Manager dialog is opened from the menu item Tools Alias Manager and it is divided into two sections The upper
63. t different from the Windows settings as shown in the table below Windows setting SmartClient forced format 12 hour clock AM PM 24 hour clock 2 digit year 00 99 4 digit year Space as time separator Space as date separator as date separator The Time View can be enabled disabled from the on off tool button located next to the table navigator on the toolbar in the main window 3 7 Find Record In addition to the query function there is a faster way to locate a specific field value The Find Record function can locate information found in any one of the table fields It supports search facilities like Starts with Whole word only Substring case sensitivity and wildcards The Find Record dialog can be opened by selecting the menu item Edit Find SmartChent User s Guide Release 4 0 Page 21 58 Basic Operations Figure 3 14 Find Record Search field Find what Match case Keep selections Find Record 19980804SCADA X search field search type Tagname ad C Substring GA MOTO PR A123 C Starts with T Match case e Wildcard match and Y Keep selections x cance Specifies the field to search Enter your search criteria If wildcards are to be used the Wildcard match search type must be enabled Only locate records where the case matches If checked each record found during the search is marked At the end of the search all marked records can then be copied to
64. tChent User s Guide Release 4 0 Page 33 58 Utilities 3 Set driver type to STANDARD 4 Select the database path using the controls browse button 5 Save the alias Modify an alias To modify an alias select the desired alias and change the settings applicable to that driver type To store the changes press the save button If the settings are disabled it is because the alias is currently in use and can therefore not be modified This can also be verified by looking above the database alias where a red text with Active appears If the database driver has to be changed you will have to create a new alias and delete the old one Delete an alias To delete an alias select the alias and press the delete button If the delete button is disabled it is because the alias is in use and can therefore not be deleted W Aliases that are currently in use cannot be modified or deleted 5 3 3 Remote aliases It is possible to let aliases point to locations on other computers in a network and thereby accessing databases located on remote computers This feature is especially useful in configurations where multiple users SmartClients must access the same event tables generated by the SmartLogger SmartTranslator The procedure for creating a remote alias is the same as for creating a local one Just use the browse button to specify a network path instead of a local path When using remote aliases with Paradox databases the followi
65. tations e SQL Query limitations If either Time View or SQL query settings are changed while the analysis dialog is open this change will automatically be applied to the analysis when it is run the next time 7 1 1 Evaluating the analysis result The analysis result view has up to four different views tab sheets Events Resut Cha E ro F 1 lt lt hs Ps ae Alarm Rate analysis for 1 5 20041015 2004 10 15 00 00 00 gt End of table Alarm Count 50 11 30 13 10 14 50 16 30 18 10 19 50 21 30 23 10 Chart period 1 day from 2004 10 15 art perio ay from Page 1 1 Figure 7 1 SmartChent User s Guide Release 4 0 Page 38 58 Alarm Management Add on e Events view Shows the events extracted from the data source and used for the analysis This view can be used to document the data that the result is based on e Result view Shows the result of the analysis This data can be used for subsequent examination export to Excel or similar e Chart Graphical presentation of the analysis result e Messages Trace messages and warnings related to the analysis This can be used for fault tracing and examination of unexpected results 7 2 Alarm Rate analysis The alarm rate analysis is used to give an overview of the overall alarm rate compared to the EEMUA recommendation of 1 ala
66. ting with HA DX the criteria should be HA _ When using the wildcards as literal characters a backslash must be placed in Ny front of the wildcard I e to locate all Tagnames starting with HA_ the criteria should be HA _ 3 6 Time View The Time View function is used for setting up a view for a desired time period While active only records matching the Time View settings will be shown in the table window The Time View dialog can be opened by selecting the menu item Table Time View SmartChent User s Guide Release 4 0 Page 20 58 Basic Operations DO Adjustta scope attertable refresh Start date stop date 30 1 e 2004 v 30 1 e 2004 v Start time stop time 00 00 00 EN 23 59 59 X conc Figure 3 13 Time View Predefined time Offers a number of pre defined time scopes scope Adjust to If checked the date time settings will be adjusted every time a scope table is refreshed I e the date time settings will be adjusted to the current date time of the PC Refresh button Is only available when the time scope differs from User defined When pushed the date time settings are adjusted to match the current time scope setting Start Date Time Specifies the start date and start time of the desired time scope Stop Date Time Specifies the stop date and stop time of the desired time scope Please note that under certain circumstances the SmartClient may force a date time forma
67. ut Export directories Miscellaneous Database auto login Enable Username Password Limit number of records fetched from server Mo SQL Enable Maximum number of records E 000 WA Show warning when limitis reached Incremental record fetching Enable Record packet size 50000 WA Default alias tor Table Open eee Y Enable Default alias JLOGDATA Table caching Cache alias CACHEDDATA 7 Enable caching as default on Table Open dialog If enabled SmartClient will attempt to log on to a database with the specified user name and password This can be used to avoid a user name password dialog every time a table is opened If enabled record sets from the SQL server will be limited to the number of records specified This feature only works for MS SQL Server databases If enabled SmartClient uses a technique where only a specified number of records are fetched upon request record packet size See also description below If specified then this alias will always be initially selected when the Table Open dialog is opened Otherwise the previously selected alias will be used This alias specifies where the cached tables should be placed Table caching is explained in section Opening a table Enable caching specifies if table caching should be chosen as the default option when opening a table from the Table Open dialog When using different databases with
68. ve a field from the grouping panel simply drag the header back to the table grid fa LOGDATA AM_AR_500 aa lt O gt ja marn Eventlype Jlogoate fia Tagname Description _ PropAcount E Hj Procsec 6 p EventType ALM E Procsec 12 E Eventiype ALM E EventType EWT E jProcoec 15 E EventType ALM E 20 WSATALIZI77 L1 Production Slop Tank P 53 WSATALS2177 L1 Production Slop Tank i rodustion Slop Tank cf 119 WSA TALS2177 L1 Production Slop Tank E 1 12 2004 02 20 27 152 Production Slop Tank i i S A Sa ca Figure 6 2 W Grouping requires the grid to be in LoadAllRecords mode refer to section LoadAllRecords Mode 6 6 Quick Sorting Mode This feature allows the user to sort the data in the grid without having to perform a SQL statement against the database server By clicking on the field headers data in that field is sorted in ascending order Clicking again reverses the sort order to descending When a field is sorted a small up down arrow appears to the right of the text in the field header as shown in Figure 6 3 SmartChent User s Guide Release 4 0 Page 36 58 Quick Access Funktionality Pipa ELS ER A A A E FS 1997 07 01 23 56 55 052 EVLOGI LOW LEVEL SLUG CA Or E 1997 07 01 23 57 15 048 EVLOGI LOW LEVEL SLUG CA Of E 1997 07 01 223 57 35 029 EVLOGI LOW LEVEL SLUG CA Of Ree 1997 07 01 23 57 55 023 EVLOGI LOW LEVEL SLUG CA Off O 199
69. w Color Id field Don t use shared colors Toggles the millisecond presentation on off in time fields Toggles the table grid lines on off Color of the grid lines Color of the background behind the records If checked every second record in the grid has a different color that can be specified here This option is especially useful when there are no grid lines shown If enabled SmartClient uses a technique called Color Id mapping See also description below When Color Id mapping is enabled it must be specified which field in the table that should be used for Color Id mapping Specifies if the table field used for Color Id mapping should be shown in the table grid Normally SmartClient shares the color definitions with the SmartLogger application If this option is checked the colors set up in SmartClient will not SmartChent User s Guide Release 4 0 Page 25 58 Maintenance affect the SmartLogger and the other way around Show text in Normally the content of memo fields are not shown in the table memo fields grid since the columns then would have to be very wide If this setting is enabled the content will be shown Color Id mapping This technique can be used when there is an integer field in the table containing values between 1 16 Each value is associated with a color thereby making it possible to show print records with individual colors How to set up the colors is explained in section Color S

SmartClient User's Guide

Contents

Download Pdf Manuals

Related Search

Related Contents