Objective
This SOP outlines the steps to effectively use Power Query for running SQL queries on synced endpoints.
Key Steps
Accessing Power Query 0:00
Open the Power Query tab in your application.
Ensure the necessary endpoints are synced and ONLINE for real-time data access.
Running SQL Queries 0:18
Identify the SQL query you want to run.
Example: Use queries related to installed patches or running processes.
Handling Query Results 0:31
Review the results displayed in the desktop application.
Note: The limit on displayed results will affect response time and may lead to errors.
Saving Queries for Later 0:43
If you need to save results, cut the output and store it for later use.
Executing the Query 0:53
Run the desired SQL query.
Be aware that results are not stored.