Introduction
An important thing to understand is that the database for Connectwise Automate is MySQL, and in that database lives every computer, every piece of information about that computer, every script, every command, every patching-related thing. It's all in there, somewhere, every single bit of it.
It can be very useful to understand that and know where those things are. Over the years, I've had to gather various pieces of information, and I've been able to create queries that are quite useful to pull some of that information.
Examples would be pulling patching errors, patching statistics, machines that have been offline over a certain amount of time, or various other things -- t's all in there. And of course, you can use the interface for some of this, but sometimes it's helpful to be able to query that stuff straight out. If you have an on-premise server, you can do some really great dynamic reporting that can automatically be sent to you using some of these queries.
Even if you're on the hosting server, there's a tool called SQL Query Analyzer that allows you to run queries straight against the database. So you could even use some of these techniques with that to gather information. Furthermore, if you're a SQL kind of guy, you'll also gather that in my queries. It sheds a lot of light on where stuff is in the database, and that will be very helpful in the future with creating additional queries.
And even beyond that, suppose you were to create a channel with Power BI, where you're querying this stuff straight out of the database. Well, of course, you're going to need to know where stuff is.
That's what this section is for. I've laid out some queries that I've written over the years, and I'm also going to include another course a little bit later on that really gets into that, that explains querying and some of those commands used, etc.
But for now, here are some queries that I've put together for you. They're quite useful, I think. And if you have any ideas for other ones, let me know. I'll be happy to get to work on it. You can find all of this in the course or over in the community.
Happy automating!