Atrium CMDB: Tracking Changes in Class and Attributes CDM

Version 4
    Share This:

    Tracking changes in the Atrium CMDB is sometimes hard, when multiple users are customizing the CDM of the CMDB.

    So I turned on the Audit on the forms OBJSTR:AttributeDefinition and OBJSTR:Class.

    and

     

    for all DB fields (no system fields)

     

    Sample:

    image2019-10-29_8-39-4.png

    here´s the sql to get the list of fields worth tracking:

    select a.name, f.fieldid, f.fieldname from field f, arschema a where a.name = 'OBJSTR:AttributeDefinition' and a.schemaid = f.schemaid and f.foption in (1, 2) and a.overlayGroup = 0 and f.overlayGroup = 0;