Schedule a CMDB query
Schedule a saved 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 begin
A saved CMDB query that was built in the CMDB Query Builder must exist.
Role required: cmdb_query_builder
About this task
The query results are attached to the email as a file in the specified format. The maximum number of result rows that can be attached is determined by the glide.cmdb.query.max_results_limit system property (10,000 by default).
Procedure
Navigate to All > Configuration > CMDB Query Builder and then select a saved query.
Select Create Schedule and then fill in the 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. |