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

Object Event Type Reference UI query available
User Login 1 User ID x
User Session expiration 3 User ID x
Asset Delete 10 Asset ID x
Asset Delivery 11 Asset ID  
Asset Preview 12 Asset ID x
Asset Process 13 Asset ID  
Asset Search 14 Asset ID  
Folder Delete 17 Folder ID x
Folder Preview 18 Folder ID x
Asset Import 20 Asset ID x
Asset Import action 21 Asset ID  
Asset Checkin 24 Asset ID x
Asset Checkout 25 Asset ID x
Asset Link 26 Asset ID x
Asset Placed 27 Asset ID x
Asset Review approval 28 Asset ID  
Collection Create 29 Object ID  
Collection View 30 Object ID  
Collection Share 31 Object ID  
Collection Add asset 32 Object ID  
Asset Resync 33 Asset ID  
Asset Reimport 34 Asset ID  
Download approval decision Approved 35 Status x
Download approval decision Rejected 36 Status x
Asset Download approval: approved 37 Asset ID x
Asset Download approval: rejected 38 Asset ID x
Asset Share event 39 Asset ID  
Asset Share original 40 Asset ID x
Asset Share proxy 41 Asset ID  
Asset Share repurpose 42 Asset ID x
Asset Share view 43 Asset ID x
Asset Share contact sheet 44 Asset ID  
Asset Share metadata 45 Asset ID  
Asset Download original 46 Asset ID x
Asset Download proxy 47 Asset ID  
Asset Download repurpose 48 Asset ID  
Asset Download view 49 Asset ID  
Asset Download contact sheet 50 Asset ID  
Asset Download metadata 51 Asset ID  
File Download 52 Asset ID x
File Share 53 Asset ID x
Asset Share 54 Asset ID x
Asset Share version 55 Asset ID  
Asset Download version 56 Asset ID  
Was this article helpful?
0 out of 0 found this helpful