LVSESSION Function
Using the LVSESSION function, you can query various session properties for the system to which you are currently connected to a worksheet cell. You can use the LVSESSION function in the following ways:
- Type the function syntax into a worksheet cell.
- Complete the function parameters in the Function Arguments dialog.
LVSESSION syntax
In the worksheet cell, type:
=LVSESSION(“property”)
where:
- property is the property you wish to retrieve. Specify one of the following values:
Field Description Group
The current user group is returned.
Host
The current name of the host application server is returned.
HttpProtocol
The http protocol for the current system is returned.
Identifier
The current Identifier for the system is returned.
IsLongviewSession
Returns a boolean indicating whether the connection is a Longview connection to a Longview data source.
IsTidemarkSession
Returns a boolean indicating whether the connection is a Tidemark connection to a Tidemark data source.
IsValid
Returns a boolean indicating that the session object has been initialized.
Port
The current port for the application server is returned.
RDBMS
The current RDBMS for the system is returned.
SessionID
The current session id is returned.
UserID
The current user id is returned.
WebBridge
The web bridge for the current system is returned.
WebBridgePath
The web bridge path for the current system is returned.
WebServer
The web server for the current system is returned.
For example:
=LVSESSION(“SessionID”)
Querying Session Properties using the Function Arguments dialog
You can query the current Session Properties by completing the function parameters in the Function Arguments dialog.
To query the current Session Properties:
- Click the Longview tab.
- In the Formulas group, click Longview Functions, and click LVSESSION. The Function Arguments dialog opens.
- Complete the following fields:
Field Description property
Specify the property to retrieve.
- Click OK. The query data appears in the worksheet.