Visualize APM reports using CMDB Query Builder

APM uses CMDB Query Builder to query on a list of configuration items used in Application Portfolio Management and visualize them as reports.

Before you begin

Role required: sn_apm.apm_user

About this task

APM takes advantage of CMDB Query Builder to build complex queries and retrieve data from CMDB CI classes, APM 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 APM user you can view the reports.

Procedure

1. Navigate to All > Application Portfolio Management > 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.

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

   Business Capabilities provided by Business Application

   Figure 1. Report showing business capabilities provided by business application

   

   Application Services consumed by Business Application

   Figure 2. Report showing application services consumed by business application

   

   Business Applications providing a Business Capability

   Figure 3. Report showing business applications providing a business capability

   

   Business Services provided by a Business Capability

   Figure 4. Report showing business services provided by a business capability

   

   Business Applications using an Information Object

   Figure 5. Report showing business applications using an information object

   

   Information Objects used by a Business Application

   Figure 6. Report showing information objects used by a business application

   

   Demands on a Business Application

   Figure 7. Report showing demands on a business application

   

   Projects on a Business Application

   Figure 8. Report showing projects on a business application

   

Related tasks

• Run scheduled jobs for CMDB Query Builder reports