Creating custom queries on the ePO - On-prem server is easy, plus you can duplicate and change existing queries to suit your needs.
You create custom queries using the Query Builder wizard. To access the Query Builder wizard, select Menu → Reporting → Queries and Reporting, then click New Query.
You can approach custom queries two ways:
You can determine exactly which kind of query that you want to create before you create it.
You can explore the Query Builder wizard and try different variables to see the different types of available queries.
Both approaches are valid and can yield interesting data about your environment. If you are new to the query system, try exploring different variables to see the types of data that ePO - On-prem can return.
Once you have created your report, you can act on the results. The type of action depends on the type of output created by the report. You can do anything that you could do in the System Tree for example, you can wake up systems, update them, delete them, or move them to another group. The wake-up action is useful when running reports on systems that:
Have not communicated with the ePO - On-prem server recently
Are suspected of not working properly when you try to wake them up
Need a new agent deployed to them directly from ePO - On-prem