Enterprise Architecture uses CMDB Query Builder to query on a list of configuration items used in Enterprise Architecture and visualize them as reports.

Before you begin

Role required: sn_apm.apm_user

About this task

Enterprise Architecture takes advantage of CMDB Query Builder to build complex queries and retrieve data from CMDB CI classes, Enterprise Architecture tables, and configuration items that are associated to each other by different CMDB CI relationships.

Before launching the reports that fetch data from the tables and CMDB CI classes, you must run the respective scheduled jobs. These jobs are set as active with frequency as On Demand. However, update the frequency as per your requirement to daily, weekly, monthly, periodically, once, on demand, Business Calendar – entry start, or entry end, based on how often the data for the report should be updated. Set the frequency of these scheduled jobs accordingly. For more information, see Run scheduled jobs for CMDB Query Builder reports.

Note: Ensure to run these scheduled jobs from Global scope only. Only a system administrator can run these scheduled jobs from global scope. However, as an Enterprise Architecture user you can view the reports.

Procedure

  1. Navigate to All > Enterprise Architecture > CMDB Query Builder.
    All reports that the base system offers are provided as menu options in the application navigator under CMDB Query Builder.
  2. Click the relevant CMDB query builder name for which you want to view the report.

    The report opens in a new tab and is rendered as a bar chart, by default. You can view and save the report for future use.

    Note: The data displayed on the report is retrieved from the latest execution of the scheduled job run on demand.
  3. Click each option to view the respective report.
    Note: You must activate the PPM Standard plugin to generate Projects on a Business Application CMDB query builder report.

    Enterprise Architecture base system provides the following list of queries to generate Enterprise Architecture reports:

    Business Capabilities provided by Business Application
    Figure 1. Report showing business capabilities provided by business application
    Business capabilities provided by business application report
    Application Services consumed by Business Application
    Figure 2. Report showing application services consumed by business application
    Application services consumed by business application report
    Business Applications providing a Business Capability
    Figure 3. Report showing business applications providing a business capability
    Business applications providing a business capability report
    Business Services provided by a Business Capability
    Figure 4. Report showing business services provided by a business capability
    Business services provided by a business capability report
    Business Applications using an Information Object
    Figure 5. Report showing business applications using an information object
    Business applications using an information object report
    Information Objects used by a Business Application
    Figure 6. Report showing information objects used by a business application
    Information objects used by a business application report
    Demands on a Business Application
    Figure 7. Report showing demands on a business application
    Demands on a business application report
    Projects on a Business Application
    Figure 8. Report showing projects on a business application
    Projects on a business application report