[Autogenerated] as promised.
I wanted to finish with a little bit of cake.
You well so let's go back to our log analytics workspace and
in there we have an in browser based cakey.
Well client,
you just want to search for logs now we can get two logs
from literally almost anywhere in the Azure portal and what
I'm going to want to do here,
I've created what's called a query pack again you can check the
Pluralsight library for more guidance on how to use K Q L.
But I created what's called a legacy query pack called update
management and I share the file with you in the course files so
don't worry about trying to jot down or worrying about jot down
any of these queries.
The basic structure of a k QL query is that we hit one or more virtual
tables in this case we're interested in the update table and this query is
going to find all Windows updates except anti male,
where definition updates and drivers.
So let me select the query and we get our results back and we can
filter the columns that we want to see either graphically here or we
can add the project keyword to our query,
find newest updates per computer.
This is just meant to give you a flavor,
we can adjust the time range filter up here or you can do where time generated
in your cake SQL query itself and so it just goes through I give you the
reference here online to tim W dot info slash o R.
One.
All of these queries came from a really excellent blog post I
found when I was doing research for this module.
Now you can take these queries and you can save them
and persist them in the portal, you can share them with your colleagues,
you can share an email or slack message a link.
You can generate alert rules based on a query.
You can export your query results to a CSV file or just displayed columns.
If you have a Power BI subscription,
you can use the query to power a Power BI visualization or
you can open the data directly and excel.
I find that this cake ul editor in the portal works really great.
In fact,
I have yet to find honestly a good cake SQL editor outside of the Azure portal.
If you know of one, please let me know. Okay.