As Built Status


When using the serial item list / positional structure is there a reliable way to query the database to return when a serial item was removed from the position.

The table serial_status records in a field called log_date when a serial item was inserted into a position but removing it only changes the field is_current to ‘N’ – no changes are made to log_date.

Therefore whilst it’s relatively easy to report was the As-Is config is, is proving harder to answer question ‘What was my config on this day?’

Any suggestions as to how I can resolve this appreciated.