Visualize CMPivot results in Configuration Manager Technical Preview 1809
Published Oct 17 2018 05:34 PM 3,965 Views

Hello everyone! Today we are announcing the release of update 1809 for the Technical Preview Branch of System Center Configuration Manager. This release gives you the ability to visualize your CMPivot results using the Azure Log Analytics render operator. You can now choose from the following types of visualizations: bar chart, column chart, pie chart and time chart. Visualizations help you analyze query results and discover key insights, so you can more quickly answer business questions, troubleshoot issues, and respond to security incidents. 




CMPivot now also includes the ability to query and pivot on hardware inventory class information. This not only significantly enhances what can be queried out-of-the-box, but also enables a standardized way to extend CMPivot by adding new hardware inventory class definitions. Even better, CMPivot will immediately render data from the last hardware inventory scan while simultaneously pulling live data from online clients -- giving you a view across online and offline devices!


Other improvements to CMPivot include support for scalar functions and scalar operators, and a query summary which displays the status of the query on the device where it was executed. Try it out and let us know what you think about it. 


Learn More about the improvements to CMPivot

Download the CMPivot Infographic


This preview release also includes:

Improvements to the product lifecycle dashboard - You can now view information for the Configuration Manger client on the lifecycle dashboard.


Improvements to data warehouse - Based on your UserVoice feedback, you can now synchronize more tables from the site database to the data warehouse. This change allows you to create more reports based on your business requirements.


Improvements to maintenance windows for software updates – you can now configure a client setting to allow clients to use other available maintenance windows to install software updates when the ‘software update’ maintenance window is also available.


Update 1809 for Technical Preview Branch is available in the Configuration Manager Technical Preview console. For new installations please use the 1806 baseline version of Configuration Manager Technical Preview Branch available on TechNet Evaluation Center. Technical Preview Branch releases give you an opportunity to try out new Configuration Manager features in a test environment before they are made generally available.


We would love to hear your thoughts about the latest Technical Preview!  Send us Feedback directly from the console.  You may also use our feedback channels through the Feedback Hub app for product issues, and our UserVoice page for ideas about new features.


The System Center Configuration Manager team


Configuration Manager Resources:

Documentation for System Center Configuration Manager Technical Previews

Try the System Center Configuration Manager Technical Preview Branch

Documentation for System Center Configuration Manager

System Center Configuration Manager Forums

System Center Configuration Manager Support



Version history
Last update:
‎Oct 17 2018 05:34 PM
Updated by: