Objective
This SOP outlines the steps to create and run custom queries in the iConfig Power Query tab, ensuring team members can efficiently retrieve data as needed.
Key Steps
Step 1: Access the Custom Query Box 0:00
Open Power Query.
Locate the custom query box to enter your query.
Step 2: Modify the Query Limit 0:14
Change the limit in your query to 100 or your desired number.
Ensure that the query is set to retrieve the correct amount of data.
Step 3: Run the Query for Running Processes 0:29
Input the query to check for running processes.
Use the custom query box to execute the query.
Step 4: Refer to Confluence Documentation 0:52
Access the Confluence page for documentation.
Review the pre-tested queries available for use.
Step 5: Copy and Paste Queries 1:03
Select a query from the Confluence page.
Copy the query and paste it into the custom query box.
Step 6: Customize the Query as Needed 1:14
Make any necessary adjustments to the query to fit your specific needs.
Step 7: Execute the Customized Query 1:24
Run the customized query to retrieve the desired information.
Step 8: Example Check for Installed Python Libraries 1:36
If applicable, run the query to check for installed Python libraries on the host.
Step 9: Verify Query Results 2:49
Review the output of the query to ensure it meets your expectations.
Cautionary Notes
Be cautious when modifying queries to avoid errors in data retrieval.
Tips for Efficiency
Familiarize yourself with the common queries listed in the Confluence documentation to save time.
Regularly check the Confluence page for updates on new or improved queries.