Statistics in the Database

NetX records various events within the exogen_stat_entry table in the database. While NetX provides UI facilities for viewing and downloading some of this data, you may want to create your own reports.  

Note: assistance with custom SQL queries is outside of Support and would require Professional Services.

Warning: all database queries against any NetX table should always be done in a read-only fashion. Never try and update data directly into the database.

Schema

The exogen_stat_entry table has the following schema:

CREATE TABLE exogen_stat_entry (
	stat_id BIGINT IDENTITY(1,1) PRIMARY KEY, 
	user_id BIGINT, 
	type BIGINT, 
	object_id BIGINT, 
	object_string ntext, 
	secondary_id BIGINT, 
	secondary_string VARCHAR(255), 
	object_source VARCHAR(255), 
	session_key VARCHAR(50), 
	site_domain VARCHAR(255), 
	stat_date DATETIME
);

While there are several fields you may want to consider, the following are the most critical:

• stat_id — the primary key for the event record
• user_id — the ID of the calling user; you can perform a join with the exogen_user table to obtain specific user information for a specific stat entry
• type — this defines the event type as an integer (see details below).
• object_id — this is the ID of the specific object type. So if this is an Asset Delivery, for example, then the ID corresponds to the Asset ID.

Types