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.

Avant de commencer

A saved CMDB query that was built in the CMDB Query Builder must exist.

Role required: cmdb_query_builder

Pourquoi et quand exécuter cette tâche

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).

Procédure

1. Navigate to All > Configuration > CMDB Query Builder and then select a saved query.
2. Select Create Schedule and then fill in the form.

   Tableau 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. Remarque : Configure the form layout to add this field to the form.