Database object audit

Is anybody aware of the optimal way to get a list of DB related objects e.g. entities; cubes etc.

Likewise for capsules and their associated objects e.g. db's; screens; screen triggers; procedures etc.

Tagged:

Answers

  • Dietmar Jeschkeit
    Dietmar Jeschkeit Active Partner
    Fourth Anniversary 100 Comments 25 Up Votes 25 Likes
    edited March 2020

    Hi Eric Walker,

     

    for versions before 11 you can extract the metadata from the database and the capsules (see screenshot). This export generates files like "cubes.txt", "entites.txt" etc. which you can analyze. Also XML-files are generated.

    In Version 11 and above you see related figures like when you select a cube you can see the entitties, screens and so on. Screenshot  2 is from 11.1.

     

    BR

    Dietmar

    image

     

    image