DESCRIBEAPP returns textual metadata about Hach WIMS depending on the parameter passed.

SYNTAX:

DESCRIBEAPP(pivot, Optional Arg1, Optional Arg2, Optional Arg3)

A string is always returned by the function.
Supported pivot values are as follows :

pivot	Description	Example return value
1	Full application description, combining application name, version, build, locale, dbms	Hach WIMS 7.4.0 build 5297 [Multi User, English (United States) [en-US], Microsoft SQL Server 2005 Express 4GB]
2	Application Name	Hach WIMS
3	Application Version	7.0.0
4	Application Build	3058
5	Edition Description	Multi-User
6	Edition ID	12987
7	Locale Description	English (United States) [en-US]
8	Locale ID	12987
9	DBMS Description	Oracle 9i
10	DBMS ID	12987
11	Current Facility Database Size in MB units	12
12	Facility Database Size in MB units, for Facility ID provided in Arg1	578
13	ROOT Database Size in MB units	14
21	Licence Max Concurrent Users	8
22	Licence Interface Count	2
23	Licence Max Facility Count	2 (0 is unlimited)
24	Licence Max Lab Cal Facility Count	5 (0 is unlimited)

REMARKS:

Any unsupported pivot passed into DESCRIBEAPP has the same effect as passing DESCRIBEAPP(1)

Certain pivot values require that you provide values for optional parameters Arg1 , Arg2 and/or Arg3

EXAMPLES:

=DESCRIBEAPP(11) returns 675 (current database is 675mb)

=DESCRIBEAPP(12,"OPSJW") returns 7 (OPSJW database is 7mb)

=DESCRIBEAPP(22) returns 2 (WIMS license allows up to 2 interfaces).