Category Archives: SQL

Analytics Plus – Reports for SCCM

A while back I wrote a post on how to install and configure Analytics Plus from ManageEngine¬†and how to get data from the System Center Configuration Manager database to create reports and dashboards. In this post I will share with … Continue reading

Posted in ManageEngine, SCCM, SQL | Tagged , , , , , , | 1 Comment

Analytics for your System Center Configuration Manager data

The most common question I get from my customers who are using Configuration Manager is without a doubt; “Can I get a report on this?”, “Is there a dashboard for this?” or other analytics. Well, as most of you know, … Continue reading

Posted in ManageEngine, SCCM, SQL | Tagged , , , , , , | Leave a comment

Use multiple IIF in expressions

Sometimes you will need to use multiple IIF in expressions when creating reports in SSRS, Reporting Services. For the past week I’ve been sitting with SSRS, trying to create a report that will show all licensed Microsoft products per client, … Continue reading

Posted in SCCM, SQL | Tagged , , , , , , | Leave a comment