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.



    for all DB fields (no system fields)




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

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