Create a schedule for a CMDB query Schedule a CMDB query to run once at a scheduled time or on a recurring schedule, and to email the query results to specified users. Before you beginRole required: cmdb_query_builder (contained for itil and asset)A saved CMDB query that was built in the CMDB Query Builder. About this task The query results are attached to the email as a file in the specified format. By default, the maximum result rows that can be attached is 10,000. This is controlled by a system property. Procedure If need to, navigate to Configuration, click CMDB Query Builder, and then click a saved query. Click Create Schedule and fill out the form. Table 1. Scheduled Email of Query Builder form Field Description Query The query to run. Users Users who should receive query results email. To receive emails, users must have an Email address defined and have Notifications set to Enable in their user records. Groups Groups to email the query results to. Zip output Indicates whether the report should be sent as a zip file. Active Indicates whether to run the query according to the specified schedule. Run Frequency for running the query. Time Time of day to run the query. Conditional Indicates whether to display the Condition field, which allows you to specify conditions under which the query runs. Omit if not records Indicate whether to distribute email if the query returns zero results. Email addresses Email addresses of users who should receive the email but who are not in the system. Subject Text that appears in the subject line of the distribution email. Introductory message Additional message that is delivered with the query results. Condition User-created script that checks for certain conditions to be true before running the query. This field is visible only when Conditional is checked. Type File format to use for the query results.Note: Configure the form layout to add this field to the form.