You can use charting software or other tools to further analyze usage report data. The tables in this topic describe the fields and data types, as well as provide additional comments that might be helpful if you would like to set up your own data analysis system.
To access a SQL Server site usage database (eRoom_eRoomSiteUsage), use the same credentials (username and password) that were supplied to eRoom for accessing the SQL Server that houses this database (usually but not necessarily the same database server that houses the site database).
To access a Sybase site usage database (eRoomSiteUsage.db), use the following credentials (without the quotation marks): 'dba' and 'sql'. This is the built-in administrative account that every Sybase Adaptive Server database comes equipped with and is the same account that eRoom uses.
Field |
Type |
Description/Comment |
|
StartTime |
SmallDateTime |
Date of first entry in any log table. |
|
EndTime |
SmallDateTime |
Date of last entry in any log table. |
Field |
Type |
Description/Comment |
|
DayDate |
SmallDateTIme |
Day of operation. Indexed (DayDate, HourOfDay). |
|
HourOfDay |
TinyInt |
Hour of operation (0-23). Indexed (DayDate, HourOfDay). |
|
Members |
Integer |
Number of unique members during that hour. |
|
SessionsStarted |
Integer |
Total number of sessions began in that hour. |
|
SessionActive |
Integer |
Total number of sessions active in that hour. |
|
Requests |
Integer |
Total number of requests for that hour. Authenticated HTTP requests to all eRoom virtual roots across entire site. |
Field |
Type |
Description/Comment |
|
DayDate |
SmallDateTime |
Day of operation. |
|
Members |
Integer |
Number of unique members that visited site that day. |
|
SessionsStarted |
Integer |
Total number of sessions began in that day. |
|
SessionActive |
Integer |
Total number of sessions active in that day. |
|
Requests |
Integer |
Total number of requests for that day. Authenticated HTTP requests to all eRoom virtual roots across entire site. |
|
PeakSessionCount |
Integer |
Peak number of active sessions per hour |
|
PeakSessionHour |
Integer |
Hour of peak session count (0-23). |
|
LowSessionCount |
Integer |
Low number of active sessions per hour. |
|
LowSessionHour |
Integer |
Hour of low session count (0-23). |
|
AverageSessionCount |
Integer |
Average number of sessions per hour. |
Field |
Type |
Description/Comment |
|
ServerID |
Integer |
ID of server. Indexed. |
|
DayDate |
SmallDateTime |
Day of operation. Twelve AM on given day. |
|
HourOfDay |
TinyInt |
Hour of operation (0-23). |
|
MinutesActive |
TinyInt |
Minutes logged during hour (0-60). |
|
Members |
Integer |
Number of unique members during that hour. |
|
SessionsStarted |
Integer |
Number of sessions started during hour. |
|
SessionsActive |
Integer |
Number of unique sessions active during hour. |
|
Requests |
Integer |
Number of server requests. |
Field |
Type |
Description/Comment |
|
ServerID |
Integer |
ID of server. Indexed (ServerID, DayDate). |
|
DayDate |
SmallDateTime |
Date of operation. Indexed (ServerID, DayDate) |
|
Members |
Integer |
Number of unique members that visited server that day. |
|
SessionsStarted |
Integer |
Total number of unique sessions for that day. Number of sessions that started during this day. |
|
SessionsActive |
Integer |
Number of sessions that were active over the day. Equals SessionsStarted plus any sessions carried over from previous day. |
|
Requests |
Integer |
Total number of server requests for that day. Authenticated HTTP requests to eRoom virtual roots on server. |
|
PeakSessionCount |
Integer |
Peak number of active sessions per hour. |
|
PeakSessionHour |
Integer |
Hour of peak session count. |
|
LowSessionCount |
Integer |
Low number of active sessions per hour. |
|
LowSessionHour |
Integer |
Hour of low session count. |
|
AverageSessionCount |
Integer |
Average number of sessions per hour. |
Field |
Type |
Description/Comment |
|
MemberID |
Integer |
Indexed. |
|
RoomID |
Integer |
Primary key in Rooms table. Indexed. |
|
FacilityID |
Integer |
Primary key in Facilities table. Indexed. |
|
CommunityID |
Integer |
Primary key in Communities table. Indexed. |
|
ServerID |
Integer |
Primary key in Servers table. Indexed. |
|
WeekDate |
SmallDateTime |
Date of beginning of week. Twelve AM Sunday for the week in question. |
|
ItemsCreated |
Integer |
Number of primary items created. Reflects items created both interactively and non-interactively, including eXQL, SAAPI, and the eRoom Scheduler inbox thread. |
|
ItemsModified |
Integer |
Number of primary items modified. Reflects items modified both interactively and non-interactively, including eXQL, SAAPI, and the eRoom Scheduler inbox thread. |
|
ItemsDeleted |
Integer |
Number of primary items deleted. Reflects items created both interactively and non-interactively, including eXQL, SAAPI and the eRoom Scheduler inbox thread. |
|
Meetings |
Integer |
Number of real time meetings participated in for this room. |
|
MeetingMinutes |
Integer |
Number of real time meeting minutes consumed for this room. |
|
Visits |
Integer |
Number of visits to the room. Number of times interactive user visited the room. A visit starts when item view events are noted in the event log, and continues as long as view events are detected within 15 minutes. After a 15-minute period of no view events, the next view event beings a new visit. This reflects interactive browser use only, not access by eXQL, eRoom Scheduler, or SAAPI program. |
|
LastVisitTime |
SmallDateTime |
Time of last visit. See above for details on visit calculations. |
Field |
Type |
Description/Comment |
|
ServerID |
Integer |
Primary key. Indexed. |
|
StartDate |
SmallDateTime |
Date of beginning of week. |
|
EndDate |
SmallDateTime |
Date and time of last update. Yesterday if scheduled nightly job ran successfully. |
|
Facilities |
Integer |
Number of facilities managed by this server. |
|
Rooms |
Integer |
Number of rooms managed by this server. |
Field |
Type |
Description/Comment |
|
CommunityID |
Integer |
Indexed (CommunityID, StartDate). |
|
StartDate |
SmallDateTime |
Date of beginning of week. Indexed (CommunityID, StartDate). |
|
EndDate |
SmallDateTime |
Date and time of last update. Yesterday if scheduled nightly job ran successfully. |
|
NativeMembers |
Integer |
Number of native members. |
|
LicensesUsed |
Integer |
Number of native members. |
Field |
Type |
Description/Comment |
|
RoomID |
Integer |
Indexed (RoomID, StartDate). |
|
StartDate |
SmallDateTime |
Date of beginning of week. Indexed (RoomID, StartDate). |
|
EndDate |
SmallDateTime |
Date and time of last update. Yesterday if scheduled nightly job ran successfully. |
|
FacilityID |
Integer |
Primary key in Facilities table. Indexed. |
|
CommunityID |
Integer |
Primary key in Communities table. Indexed. |
|
ServerID |
Integer |
Primary key in Servers table. Indexed. |
|
FileSize |
Bigint |
Size of room files in bytes. 64-bit integer |
|
DBSize |
Bigint |
Size of room in facility database in bytes. 64-bit integer. |
|
ObjectCount |
Integer |
Number of objects in room. Useful for scalability testing. |
|
ItemCount |
Integer |
Refers to principal items only. |
|
NoteItemCount |
Integer |
Number of Note items in room. |
|
FolderItemCount |
Integer |
Number of Folder Items in room. |
|
DiscussionItemCount |
Integer |
Number of Discussion items in room. |
|
AttachmentItemCount |
Integer |
Number of Files attached to room. |
|
LinkItemCount |
Integer |
Number of Link items in room. |
|
PollItemCount |
Integer |
Number of Poll Items in room. |
|
VersionedAttachmentItemCount |
Integer |
Number of Versioned File Attachment items in room. |
|
TopicItemCount |
Integer |
Number of Topic items in room. |
|
InboxItemCount |
Integer |
Number of Inbox items in room. |
|
MailMessageItemCount |
Integer |
Number of Mail Message items in room. |
|
DatabaseItemCount |
Integer |
Number of Database items in room. |
|
DatabaseRowItemCount |
Integer |
Number of Database row items in room. |
|
CalendarItemCount |
Integer |
Number of Calendar items in room. |
|
CalendarEventItemCount |
Integer |
Number of Calendar Event items in room. |
|
CalendarEventExceptionItemCount |
Integer |
Number of Calendar Event Exception items in room. |
|
EntDBSummaryItemCount |
Integer |
Number of Enterprise Database Summary items in room. |
|
EntDBInstanceItemCount |
Integer |
Number of Enterprise Database Instance items in room. |
|
WorkflowItemCount |
Integer |
Number of Workflow items in room. |
|
WorkflowPhaseItemCount |
Integer |
Number of Workflow Phase items in room. |
|
ProjectScheduleItemCount |
Integer |
Number of ProjectSchedule items in room. |
|
Members |
Integer |
Number of members in room. |
|
Meetings |
Integer |
Number of meetings. Meetings started for this week. |
|
MeetingMinutes |
Integer |
Number of meeting minutes consumed. Elapsed meeting time. |
|
TotalMemberMeetingMinutes |
Integer |
Total number of member meeting minutes consumed. For a given meeting, this is the sum of the minutes consumed by each member who attended the meeting. |
Field |
Type |
Description/Comment |
|
ServerID |
Integer |
Primary key. Indexed. |
|
ServerName |
Varchar(256) |
Name of server. |
|
ServerType |
Integer |
Type of server. Always one, meaning server is a Room server. |
|
Deleted |
Bit |
Whether server has been deleted. |
Field |
Type |
Description/Comment |
|
RoomID |
Integer |
Primary key. Indexed. |
|
RoomGUID |
Char(40) |
Room identifier used by site database. |
|
RoomName |
Varchar(128) |
Display name of room. |
|
FacilityID |
Integer |
Primary key in Facilities table. |
|
CreationDate |
DateTime |
Creation timestamp. Can be NULL. |
|
Template |
Bit |
Whether room is a template. |
|
Deleted |
Bit |
Whether room has been deleted. |
Field |
Type |
Description/Comment |
|
FacilityID |
Integer |
Primary key. Indexed. |
|
FacilityGUID |
Char(40) |
Facility identifier used by site database. |
|
FacilityName |
Varchar(128) |
Display name of facility. |
|
CommunityID |
Integer |
Primary key in Communities table. Indexed. |
|
ServerID |
Integer |
Site ID of eRoom server. Get server name from Servers table. |
|
Deleted |
Bit |
Whether facility has been deleted. |
Field |
Type |
Description/Comment |
|
CommunityID |
Integer |
Primary key. Indexed. |
|
CommunityGUID |
Char(40) |
Community identifier used by site database. |
|
CommunityName |
Varchar(128) |
Display name of community. |
|
Deleted |
Bit |
Whether community has been deleted. |
Field |
Type |
Description/Comment |
|
MemberID |
Integer |
Primary key. Indexed, never NULL. |
|
CommunityID |
Integer |
Never NULL. |
|
FirstName |
Varchar(128) |
Can be NULL. |
|
MiddleName |
Varchar(128) |
Can be NULL. |
|
LastName |
Varchar(128) |
Can be NULL. |
|
LoginName |
Varchar(128) |
Never NULL. |
|
EmailAddress |
Varchar(128) |
Can be NULL. |
|
CreationDate |
DateTime |
Creation timestamp. Can be NULL. |
|
LastLoginTime |
DateTime |
Last login to site timestamp. Never NULL. |
|
Deleted |
Bit |
Whether member has been deleted. |
With the exception of the Members table, no field in any table is NULL.
All fields of type VARCHAR above are in fact of type NVARCHAR.