{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/5f0f666d489444a493029db2c79fc2b3\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/5f0f666d489444a493029db2c79fc2b3-1f2b326324775de9.gif","duration":110.059,"title":"Using Power Query for Real Time Results 🚀","description":"In this Loom, I show the Power Query tab where you can run ad hoc SQL queries in real time against endpoints you already synced. I demonstrate results like installed patches and styled software, and how the query text and outputs appear in the desktop. I also show a running processes example with a 50 item limit, then I cut that output for later. For now, we are not storing this kind of answer, and I am checking if there is interest in having it stored."}