Database Schema and Views Reference Guide › About Database Schema and Views › IDM Columns

IDM Columns

Various tables in the database schema contain column names that end with 'IDM', such as SequenceIDM or LoginIDM. Such columns provide an implicit relationship to the machine which generated that row of data.

For example, you can determine from the SequenceIDM column of the Wgn3Event table the machine on which that event was captured. To identify the machine, search the MachineID column in the WgnMachine table to identify the MachineID that matches the entry in the SequenceIDM column. To identify the machine that generated a row with a SequenceIDM column of 1234, use the following query:

SELECT MachineName FROM WgnMachine WHERE MachineID=1234