I hope by explaining how I thought about this report, it would make it easier for you to go and tweak the report query to fit your needs, or perhaps to add more information that you might need in your environment. You can skip this section if you want to try the report right away in your environment and enjoy the wonderful results I hope. While most of you want to jump directory and try the report, I want to spend a little time talking about the challenges I faced. Check my configuration manager update size post for more details. Tip:I created a blog post to list all Windows update package size, so that you can have an idea of your patching software update group before downloading them and perhaps congest your network. Usually the ResourceID is the main identifier of resources hosted inside the configuration manager SQL database. I can argue that the best way to get rich queries and information from configuration manager, is by using the SQL report engine and native SQL queries. If you are a beginner in configuration manager, you might be using the SCCM queries (WQL), which is based on WMI name spaces. After that, I would figure out the main records to query, and what columns to use for my filtering and aggregations. To do that, I had to dig deep and understand the schema of configuration manager SQL database and the relationship between tables. The reason why this report is unique, is the way it aggregate information, and help prevent duplicate records and filter orphan devices. This blog post talks about how to create a detailed configuration manager report, that can be considered a unique report in the internet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |