# ESS_REQUESTINFO_T

This structure contains information that can be used to display information about, or terminate, sessions and requests. A session is the time between login and logout for a user connected to Essbase. A request is a query sent to Essbase by a user or by another process; for example, starting an application, or restructuring a database outline. Each session can process only one request at a time; therefore, sessions and requests have a one-to-one relationship.

    typedef struct ESS_REQUESTINFO_T
    {
       ESS_LOGINID_T   LoginId;              user login identification tag
       ESS_USERNAME_T  UserName;             user name
       ESS_SVRNAME_T   LoginSourceMachine;   Login machine name
       ESS_APPNAME_T   AppName;              connected application
       ESS_DBNAME_T    DbName;               connected database
       ESS_USHORT_T    DbRequestCode;        Request code
       ESS_DESC_T      RequestString;        Request string
       ESS_TIME_T      TimeStarted;          time started (in seconds)
       ESS_REQ_STATE_T State;                current process state
    }  ESS_REQUESTINFO_T, *ESS_PREQUESTINFO_T, **ESS_PPREQUESTINFO_T;

Data Type | Field | Description
ESS_LOGINID_T | LoginId | A unique number assigned to the user when the user logs in.
ESS_USERNAME_T | UserName | The name of the requesting user.
ESS_SVRNAME_T | LoginSourceMachine | Server name from which the session or request is being made
ESS_APPNAME_T | AppName | The active application (if any) for the session or request
ESS_DBNAME_T | DbName | The active database (if any) for the session or request
ESS_USHORT_T | DbRequestCode | A positive integer representing an active session. Example: 774896669
ESS_DESC_T | RequestString | A string representing the type of request. For possible values, see Request Types below.
ESS_TIME_T | TimeStarted | how long the session or request has been in progress (in seconds)
ESS_REQ_STATE_T | State | The state of the current session or request: whether it is processing, terminating, or terminated.

## Request Types

Process xref request | xref test | Validate
Restructure | ClearData | GetStats
GetCurrencyDb | SetCurrencyDb | SetCurrencyType
SetCurrencyType | GetCurrencyType | GetCurrencyRate
Export | ParExport | DataLoad
SQLImport | Import | StreamDataload
SQLRetrieve | CancelUpdate | ClearUserLocks
Report | SpreadsheetOperation | SpreadsheetCellOperation
SQLConnect | SQLListDsn | SQLGetDsn
SQLDatabases | SQLTables | SQLColumns
Calculate | ParseCalcScript | RunDefaultCalcScript
SetDefaultCalcScript | GetDefaultCalcScript | CalcStats
ListCalcFunc | VerifyJavaSpec | UpdateCdfCdm
VerifyFormula | ListUdfs | UdfInfo
LoadAlias | RemoveAlias | ClearAliases
ListAliases | SetAlias | GetAlias
DumpAlias | BuildDimStart | BuildDimension
BuildDimFile | GetDSInfo | GetSelectedMbrInfo
GetMbrInfo | GetMbrCalc | CheckMbrName
TestDriver | GetDimInfo | GetAttributeNameSpecs
GetSmStats | PerfCommand | GetOtlInfo
OtlQueryMbrs | OtlQueryMbrs | OtlQueryUDAs
OtlQueryAttrib | OtlGetUpdateTime | GetAttrInfo
CheckAttribute | PutReplicatedCells | GetReplicatedCells
List location aliases | Create location alias | Delete location alias