CMDB Query Builder Table

samuelbingham
Tera Contributor

Hello, I made a query in the CMDB Query Builder and I am trying to figure out how to save this query to my update set. How can I achieve this? 

4 REPLIES 4

SumanKumarM
Tera Contributor

Hello Samuelbingham,

Please refer below link and try to follow the steps,

https://docs.servicenow.com/bundle/xanadu-servicenow-platform/page/product/configuration-management/...

 

Please mark helpful, if it helps you in kick starting.

 

BR,

Suman.

Harsh Vardhan
Giga Patron

Hi @samuelbingham  - You can capture this in update set, Go to the table qb_saved_query list view, search for the query builder which you have created then select it and click on List choice button "Export Query", once you will click on this button it will auto generate the update set and capture those query there. 

Adding screenshot for your reference. 

 

cmdb query builder.JPG

 

Doc link for your reference.

 

Export and import a query as an update set 

 

Thanks,

Harsh

 

Amit Verma
Kilo Patron
Kilo Patron

Hi @samuelbingham 

 

You can export a query definition as an update set by the method suggested by Harsh and retrieve in on the another instance.

 

Thanks and Regards

Amit Verma


Please mark this response as correct and helpful if it assisted you with your question.

Harish Bainsla
Kilo Patron
Kilo Patron

Hi @samuelbingham  follow these steps

Procedure

  1. Export a saved query:
    1. In the Filter navigator, enter qb_saved_query.list.
    2. Select Enter to navigate to the Saved Queries table.
    3. In the Saved Queries list view, select the query that you want to export.
    4. Select Actions on selected rows and then Export query.
    5. Wait for the Query Exporter to complete the export.
  2. Import the exported saved query:
    1. Navigate to System Update Sets > Retrieved Update Sets.
    2. On the Retrieved Update Sets form, select Import Update Sets from XML.
    3. On the Import XML page, select Choose file.
    4. Select the exported XML file.
    5. Select Upload.
    6. Open the new record that was added to the Retrieved Update Sets list view.
    7. On the Retrieved Update Set form, select Preview Update Set Batch.
    8. Close the Batch Update Set Preview dialog box.
    9. Select Commit Update Set Batch.
    10. Close the Commit Update Set Batch dialog box.

If my answer helps you please mark helpful and accept solution