A number of pre-defined system variables exist in five groups: - Last result - Local - Execution statistics - Invantive application - Invantive database connection - System of device ## Last Result Name starts with 'outcome:', followed by a 0-based row and column number separated by comma. The variable 'outcome:0,0' will expand to the string value of the first row and column in the result of the last SQL executed. ## Local Local statement executions: name starts with local:'. Available are: - `hoststdout`: regular output of the last (successful) host statement. - `hoststderr`: error output of the last (successful) host statement. - `hostexitcode`: exit code of the last (successful) host statement. ## Execution statistics Execution statistics: name starts with `stat:`. Pre-defined list of: - `errorcountignore`: number of errors fully ignored. - `errorcountdefault`: number of errors during default setting. - `errorcountcontinue`: number of errors ignored, but memorized for exit code. - `statementcount`: number of statements executed. ## Application The following variables exist in the Invantive application group: - `application:applicationfolder`: location of the application folder. - `application:cachedirectory`: location of the cache folder. - `application:centralsettingdirectory`: location of the central settings folder. - `application:connectionname`: full name of the currently connected database. - `application:containertitle`: title of the containing Windows form. - `application:copyright`: copyright text of the application. - `application:currentversion`: version of the application. - `application:currentversionshort`: short version of the application. - `application:datadirectory`: location of the data folder. - `application:expirationdate`: date at which the hard coded license ends. - `application:globalfirstuse`: date/time (UTC) of first use of any Invantive application. - `application:globalnumberofapplicationstarts`: number of starts of any Invantive application. - `application:globalusersettingsfile`: file name and path of the global user settings. - `application:invantivetempdirectory`: location of the Invantive-specific temporary folder. - `application:iscurrentusersystemuser`: whether the user is a system user. - `application:isloggedon`: whether the user is connected to an Invantive database. - `application:lastavailablebandwidth`: last measured bandwidth to Invantive Producer. - `application:lastavailablelatency`: last measured latency to Invantive Producer. - `application:lastlanguage`: last used language code for the user interface. - `application:loggingfile`: file name and path of logging file. - `application:multicorejitprofilefile`: file name and path of multi-core JIT profile file (obsoleted). - `application:name`: name of the application - `application:nameversion`: name and version of the application. - `application:numberofconnectionsmade`: number of times a connection was established to an Invantive database. - `application:optimizationdirectory`: location of the folder used for .NET framework assembly optimizations. - `application:productinstallationfirstuse`: date/time (UTC) of first use of the application. - `application:productinstallationnumberofapplicationstarts`: number of starts of the current Invantive application installation. - `application:productinstallationusersettingsfile`: file name and path of the production installation user settings file. - `application:productnumberofapplicationstarts`: number of starts of the current Invantive application. - `application:productusersettingsfile`: file name and path of the product user settings file. - `application:querytoolcentraldirectory`: location of the central settings folder of the Invantive Query Tool. - `application:serverlicenseexists`: whether a server license exists for Invantive Producer or Invantive Estate. - `application:serverprefixurl`: Invantive Producer server prefix (URL). - `application:starterdirectory`: location of VSTO application starters folder. - `application:supportemail`: email address of Invantive support. - `application:supportwebsite`: URL of the Invantive support website. - `application:tempdirectory`: temporary data folder. - `application:urllobcache`: name of the URL LOB cache file. - `application:userlayoutdirectory`: location of user layouts folder. ## Database The following variables exist in the Invantive database group: - `database:connection`: full name of the database. - `database:datacontainerid`: data container ID. - `database:partitions`: comma-separated list of code of partitions in database. - `database:ultimateprovider`: name of data provider. - `database:useremailaddress`: email address of the Invantive database user. - `database:userfullname`: full name of the currently Invantive database user. - `database:userldapusername`: LDAP of the Invantive database user. - `database:userlogincode`: login code of the Invantive database user. - `database:version`: version of the database. # System The following variables exist in the system group: - `system:antivirusinfo`: description of the anti-virus product in use. - `system:clipboardtext`: current contents of the Windows clipboard. - `system:clrversion:build`: build of the Common Language Runtime. - `system:clrversion:major`: major version of the Common Language Runtime. - `system:clrversion:majorrevision`: major revision of the Common Language Runtime. - `system:clrversion:minor`: minor version of the Common Language Runtime. - `system:clrversion:minorrevision`: minor revision of the Common Language Runtime. - `system:clrversion`: full version of the Common Language Runtime. - `system:clrversion`: version of the common language runtime (CLR). - `system:commandline`: command line for this process. - `system:currentdirectory`: path of the current working directory. - `system:date`: date of the workstation. - `system:datetime`: date and time of the workstation. - `system:datetimeutc`: date and time (UTC) of the workstation. - `system:dateutc`: date (UTC) of the workstation. - `system:directoryseparator`: OS-specific separator for directory. - `system:directoryseparatoralt`: alternative OS-specific separator for directory. - `system:environmentvariable:NAME`: value of the operating system environment variable with the name 'NAME'. - `system:hasteamviewer`: whether TeamViewer in version 10 is present. - `system:ipaddress`: primary IP-address of the workstation on the internal network. - `system:ipaddressexternal`: primary IP-address of the workstation on the Internet. - `system:is64bitoperatingysystem`: whether the operating system runs in 64-bit mode. - `system:is64bitprocess`: whether the current process runs in 64-bit mode. - `system:isvirtualmachine`: whether the workstation is a virtual machine. - `system:logicalcorecount`: number of logical cores of the workstation. - `system:machinename`: NetBIOS name of the workstation. - `system:now`: date and time of the workstation in the format YYYYMMDDHH24MISS. - `system:nowutc`: date and time (UTC) of the workstation in the format YYYYMMDDHH24MISS. - `system:os`: current platform version number. - `system:osname`: human-friendly name of the operating system. - `system:pathseparator`: OS-specific separator for path. - `system:physicalcorecount`: number of physical cores in the workstation. - `system:physicalmemoryinbytes`: number of bytes in the physical memory of the workstation. - `system:processorcount`: number of physical processors in the workstation. - `system:processorid`: ID of the processor. - `system:sid`: security identifier. - `system:stacktrace`: stack trace of the program. - `system:systemdirectory`: fully qualified path of the system directory. - `system:systempagesize`: number of bytes in the system memory page. - `system:time`: time of the workstation. - `system:timeutc`: time (UTC) of the workstation. - `system:user`: user of the workstation. - `system:userdesktopdirectory`: fully qualified path of the desktop directory of the current user. - `system:userdocumentsdirectory`: fully qualified path of the documents directory of the current user. - `system:userdomain`: network domain name associated with the current user. - `system:userfavoritesdirectory`: fully qualified path of the favorites directory of the current user. - `system:userhomedirectory`: fully qualified path of the home directory of the current user. - `system:userinteractive`: whether the current process is running in interactive mode. - `system:userpicturesdirectory`: fully qualified path of the pictures directory of the current user. - `system:userprofiledirectory`: fully qualified path of the profile directory of the current user. - `system:volumeseparator`: OS-specific separator for volume. - `system:workingset`: amount of physical memory mapped to the process context.