Product documentation Docs
    • English
    • Deutsch
    • 日本語
    • 한국어
    • Français
  • More Sites
    • Now Community
    • Developer Site
    • Knowledge Base
    • Product Information
    • ServiceNow.com
    • Training
    • Customer Success Center
    • ServiceNow Support Videos
  • Log in

Product documentation

  • Home
How search works:
  • Punctuation and capital letters are ignored
  • Special characters like underscores (_) are removed
  • Known synonyms are applied
  • The most relevant topics (based on weighting and matching to search terms) are listed first in search results
Topics are ranked in search results by how closely they match your search terms
  • A match on the entire phrase you typed
  • A match on part of the phrase you typed
  • A match on ALL of the terms in the phrase you typed
  • A match on ANY of the terms in the phrase you typed

Note: Matches in titles are always highly ranked.

  • Release version
    Table of Contents
    • Now Platform capabilities
Table of Contents
Choose your release version
    Home Orlando Now Platform Capabilities Now Platform capabilities Configuration Management Database Querying the CMDB Create reports in CMDB Query Builder

    Create reports in CMDB Query Builder

    • Save as PDF Selected topic Topic & subtopics All topics in contents
    • Unsubscribe Log in to subscribe to topics and get notified when content changes.
    • Share this page

    Create reports in CMDB Query Builder

    Use CMDB Query Builder reports to show the results of a CMDB query or a Service Mapping query. Create a basic report, or a dynamic report that automatically updates when the results of the associated saved query change.

    Create a dynamic report

    After running a saved query in the CMDB Query Builder, create a dynamic report that continuously updates to show the latest query results. You can use a dynamic report as any other report created using Reporting and you can add it to Performance Analytics dashboards.

    Before you begin

    Ensure that the query that you want to create a dynamic report for is a saved query, and that there is a specified schedule for the query. Also, run the saved query and ensure that all query results are visible.

    Role required:
    • To create: cmdb_query_builder and report_user
    • To view: Reporting role requirements might apply, see Administering reports for Reporting role requirements.
    In a base system, the cmdb_query_builder role is contained in the itil and asset roles.

    About this task

    The Create Report button in CMDB Query Builder which is used to create a dynamic report, is activated only if:
    • The query is saved
    • The query has a schedule
    • The entire set of query results is present after a query run

    The initial dynamic report that you create, is based on the results from the initial run of the saved query. Then, on every subsequent run of the saved query, the associated report automatically updates with the latest query results.

    However, if you change the query definition itself, the query and the report are no longer in sync and you must create a new report.

    Procedure

    1. Navigate to Configuration > CMDB Query Builder.
    2. In the Saved Queries tab, select the saved query for which you want to create a report.
      Ensure that the query has a specified schedule.
    3. Click Run and ensure that all query results appear. Click Load All Results if available, to load all results.
      The Create Report button is enabled only if all query results are showing.
    4. Click Create Report.
      If the CMDB Query Builder displays the query results in a new tab, then after the new tab opens with the query results, return to the CMDB Query Builder window.
    5. In the Report Designer, click Next or Back to view and configure the new report in the Data, Type, Configure, and Style tabs.
      The report is pre-populated with the CMDB query results and a few other report details.
      • Report name is set to the name of the saved query.
      • Source type is set to Data source.
      • Data source is set to the table in which the query results are stored.
      • Query Sys ID is the ID of the latest run of the query.

      For more details about Reporting and about configuring a report in the Report Designer, see Reporting, Creating reports.

    6. Click Save or Run.

    Result

    CMDB Query Builder creates a report source which you can attach to a report and use with dashboards. For more details about report sources, see Report sources.

    What to do next

    Use either of the following steps to view the new report source. The name of the new report source is set to the name of the CMDB query it was created from, and cannot be changed.
    • In Query Builder, click Saved Queries. In the Saved Queries window, click the Query Information icon in the tile of the saved query. Scroll to the bottom of the information list and then click the link under Report source.
    • Navigate to Reports > Administration > Report Sources and locate the new report source.

    Create a basic report

    After running a query in the CMDB Query Builder, you can create a basic report that is scoped to the query execution.

    Before you begin

    The UI16 plugin (com.glide.ui.ui16) must be activated.

    Role required:
    • View report: cmdb_query_builder or cmdb_query_builder_read
    • Create report: cmdb_query_builder or cmdb_query_builder_read, and report_user
    In a base system, the cmdb_query_builder role is contained in the itil and asset roles.

    Procedure

    1. Navigate to Configuration and click CMDB Query Builder.
    2. Build a query.
    3. In the query results pane, click the list context menu and select Bar Chart or Pie Chart.

    Result

    The Reports application creates a basic report, which is scoped to the query execution and is static.
    Related tasks
    • Build a CMDB query using the CMDB Query Builder
    • Build a Service Mapping query using the CMDB Query Builder
    • Run a partial CMDB query
    Related topics
    • Reporting

    Tags:

    Feedback
    On this page

    Previous topic

    Next topic

    • Contact Us
    • Careers
    • Terms of Use
    • Privacy Statement
    • Sitemap
    • © ServiceNow. All rights reserved.

    Release version
    Choose your release version

      Create reports in CMDB Query Builder

      • Save as PDF Selected topic Topic & subtopics All topics in contents
      • Unsubscribe Log in to subscribe to topics and get notified when content changes.
      • Share this page

      Create reports in CMDB Query Builder

      Use CMDB Query Builder reports to show the results of a CMDB query or a Service Mapping query. Create a basic report, or a dynamic report that automatically updates when the results of the associated saved query change.

      Create a dynamic report

      After running a saved query in the CMDB Query Builder, create a dynamic report that continuously updates to show the latest query results. You can use a dynamic report as any other report created using Reporting and you can add it to Performance Analytics dashboards.

      Before you begin

      Ensure that the query that you want to create a dynamic report for is a saved query, and that there is a specified schedule for the query. Also, run the saved query and ensure that all query results are visible.

      Role required:
      • To create: cmdb_query_builder and report_user
      • To view: Reporting role requirements might apply, see Administering reports for Reporting role requirements.
      In a base system, the cmdb_query_builder role is contained in the itil and asset roles.

      About this task

      The Create Report button in CMDB Query Builder which is used to create a dynamic report, is activated only if:
      • The query is saved
      • The query has a schedule
      • The entire set of query results is present after a query run

      The initial dynamic report that you create, is based on the results from the initial run of the saved query. Then, on every subsequent run of the saved query, the associated report automatically updates with the latest query results.

      However, if you change the query definition itself, the query and the report are no longer in sync and you must create a new report.

      Procedure

      1. Navigate to Configuration > CMDB Query Builder.
      2. In the Saved Queries tab, select the saved query for which you want to create a report.
        Ensure that the query has a specified schedule.
      3. Click Run and ensure that all query results appear. Click Load All Results if available, to load all results.
        The Create Report button is enabled only if all query results are showing.
      4. Click Create Report.
        If the CMDB Query Builder displays the query results in a new tab, then after the new tab opens with the query results, return to the CMDB Query Builder window.
      5. In the Report Designer, click Next or Back to view and configure the new report in the Data, Type, Configure, and Style tabs.
        The report is pre-populated with the CMDB query results and a few other report details.
        • Report name is set to the name of the saved query.
        • Source type is set to Data source.
        • Data source is set to the table in which the query results are stored.
        • Query Sys ID is the ID of the latest run of the query.

        For more details about Reporting and about configuring a report in the Report Designer, see Reporting, Creating reports.

      6. Click Save or Run.

      Result

      CMDB Query Builder creates a report source which you can attach to a report and use with dashboards. For more details about report sources, see Report sources.

      What to do next

      Use either of the following steps to view the new report source. The name of the new report source is set to the name of the CMDB query it was created from, and cannot be changed.
      • In Query Builder, click Saved Queries. In the Saved Queries window, click the Query Information icon in the tile of the saved query. Scroll to the bottom of the information list and then click the link under Report source.
      • Navigate to Reports > Administration > Report Sources and locate the new report source.

      Create a basic report

      After running a query in the CMDB Query Builder, you can create a basic report that is scoped to the query execution.

      Before you begin

      The UI16 plugin (com.glide.ui.ui16) must be activated.

      Role required:
      • View report: cmdb_query_builder or cmdb_query_builder_read
      • Create report: cmdb_query_builder or cmdb_query_builder_read, and report_user
      In a base system, the cmdb_query_builder role is contained in the itil and asset roles.

      Procedure

      1. Navigate to Configuration and click CMDB Query Builder.
      2. Build a query.
      3. In the query results pane, click the list context menu and select Bar Chart or Pie Chart.

      Result

      The Reports application creates a basic report, which is scoped to the query execution and is static.
      Related tasks
      • Build a CMDB query using the CMDB Query Builder
      • Build a Service Mapping query using the CMDB Query Builder
      • Run a partial CMDB query
      Related topics
      • Reporting

      Tags:

      Feedback

          Share this page

          Got it! Feel free to add a comment
          To share your product suggestions, visit the Idea Portal.
          Please let us know how to improve this content

          Check any that apply

          To share your product suggestions, visit the Idea Portal.
          Confirm

          We were unable to find "Coaching" in Jakarta. Would you like to search instead?

          No Yes
          • Contact Us
          • Careers
          • Terms of Use
          • Privacy Statement
          • Sitemap
          • © ServiceNow. All rights reserved.

          Subscribe Subscribed Unsubscribe Last updated: Tags: January February March April May June July August September October November December No Results Found Versions Search preferences successfully updated My release version successfully updated My release version successfully deleted An error has occurred. Please try again later. You have been unsubscribed from all topics. You are now subscribed to and will receive notifications if any changes are made to this page. You have been unsubscribed from this content Thank you for your feedback. Form temporarily unavailable. Please try again or contact  docfeedback@servicenow.com  to submit your comments. The topic you requested does not exist in the release. You were redirected to a related topic instead. The available release versions for this topic are listed There is no specific version for this documentation. Explore products Click to go to the page. Release notes and upgrades Click to open the dropdown menu. Delete Remove No selected version Reset This field is required You are already subscribed to this topic Attach screenshot The file you uploaded exceeds the allowed file size of 20MB. Please try again with a smaller file. Please complete the reCAPTCHA step to attach a screenshot
          Log in to personalize your search results and subscribe to topics
          No, thanks Login