Queries
Queries enable you to quickly list a subset of assets in the Assets application. For example, you can list all of the approved purchase requests, all of the deployed assets, and so on. Queries are also used to populate result set portlets in a start center. For example, you can specify that the "All deployed assets" query will list all deployed assets in one of your result set portlets.
The following table lists and describes the queries that are available as optional content:
| Query | Description |
|---|---|
| ITAM_APPR_PR | Approved Purchase Requests |
| ITAM APPR POs | List of Approved POs (in PO App) |
| Open SRs for HW Asset Mgr | Open Service Requests for HW Asset Manager |
| Open WO for HW Asset Mgr | Open Work Orders for HW Asset Mgr |
| Open Tasks for HW Asset Mgr | Open Tasks for HW Asset Mgr |
| APPR PO | Approved Purchase Orders |
| Q_APPR_PR | Approved Purchase Requests |
| APPR POs | List of Approved POs (in PO App) |
| ITAMReconResults | Asset Reconciliation Results Summary |
| ITAMDPA | ITAM Deployed Assets |
| Open Tasks for IT Inventory Admin | Open Tasks for IT Inventory Admin |
| ITAMNONREPORT30 | ITAM Deployed Assets not reporting last 30 days |
| Open SRs for SW Asset Mgr | Open Service Requests for SW Asset Manager |
| Open WO for SW Asset Mgr | Open Work Orders for SW Asset Mgr |
| Open Tasks for SW Asset Mgr | Open Tasks for SW Asset Mgr |
| Unreviewed Software | Unreviewed Software |
| My Assets | My Assets |
To view a list of the built-in queries for asset management, open the Assets application, and select View/Manage Queries from the Save Query pull-down menu. The View/Manage Queries window opens to display a list of the queries, with descriptions. Opening a saved query in the list displays the clause for that query. You can create new saved queries, modify the existing queries, and otherwise manage your saved queries in the View/Manage Queries window; click the question mark in the upper right corner for instructions.