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

NOTE Please note: that assistance with custom SQL queries is outside of Support, and would require Professional Services.

WARNING 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
);
CODE

While there are a number of 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

ObjectEventTypeService CallObject StringSecondary IDSecondary StringObject Source
AssetCheckin24importAsset, multiAssetCheckin, checkinAssetFile path


AssetCheckout25checkoutAssetFile path


AssetDelete10

deleteAsset


File name


AssetDelivery11

repurposeAssets, Token Link downloads, Cart downloads, Cart repurposing, Public Links (legacy)

RestServlet: ONLY for asset original calls

File name


AssetImport20

importAsset

File path


AssetImport Data22Data import actionFile path


AssetLink26Cart link assetsFile nameRelated Asset IDRelated file name
AssetPlaced27recordAssetPlacedFile pathPlaced Asset IDParent/INDD file nameCart (or bulk cart), Saved Cart, Saved Search, Search
AssetPreview12RestServlet: ONLY for asset preview callsFile name


AssetProcess13

Only repurpose calls (single Assets or via Carts)

File name


AssetReimport34Post import taskFile name


AssetResync33Post import taskFile path


AssetReview Approval28Review completed callbackApproval details


AssetSearch14Any search, including category clicksKeyword/search string


CartCreate16

Create a Cart

User Email


CartAdd Asset15

Add Asset to a Cart

File path


Saved CartAdd Asset32Add asset to a Saved CartCart nameAsset ID

SavedCartCreate29Create a Saved CartCart name


Saved CartShare31Share a Saved CartCart name


Saved CartView30

View a Saved Cart

Cart name


CategoryDelete17Delete a CategoryPath


CategoryPreview18View a Category (list of its Assets)Path


SessionCreate Session2AuthenticatedSessionManagerSession key


UserLogin1
  • AutoLoginServlet
  • PingOne logins
  • RestServlet; login command
  • SSO logins
  • Service; authenticate method
Email