As Built Status

Hi,

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.

Parents
  • Hi Andy,

    can you check if by enabling options for Serialized Items in Audit the information you need is stored in the Audit trail (see attachment for example of where you can find this).

    If eB does not log the action there, currently the only way to  report on it will be to write a custom event handler to create an audit record.

                                          

    Address: Bentley | 10052 Mesa Ridge Court Suite
    100 | San Diego | CA | 92121 | USA



  • Hi,

    I tried (with limited success) to interrogate the serial_status table to try and reproduce the as-Is status for a given date. In the end I took a different approach. I created a little plugin that allows users to export the hierarchical As-Configure view to an XML file, this I save to a document which is then associated to serial item in question.

    This allows users to regenerate the As Configured treeview from the data held within these XML files. Thus presenting the historical view. Of course this only works if the users remember to actually take the snapshot – this task can be simply added to the procedure though.

    Regards,

    Andy.

Reply
  • Hi,

    I tried (with limited success) to interrogate the serial_status table to try and reproduce the as-Is status for a given date. In the end I took a different approach. I created a little plugin that allows users to export the hierarchical As-Configure view to an XML file, this I save to a document which is then associated to serial item in question.

    This allows users to regenerate the As Configured treeview from the data held within these XML files. Thus presenting the historical view. Of course this only works if the users remember to actually take the snapshot – this task can be simply added to the procedure though.

    Regards,

    Andy.

Children
No Data