Tag 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

Query SQL database from PowerShell

I’ve been working on a larger script where I needed to query a database to see if a value was present or not, something I thought was pretty much straight forward. However, this turned out to be a bit harder … Continue reading

Posted in Powershell | Tagged , , , , , , | 1 Comment

Install SQL Server PowerShell Module (SQLPS)

When installing SQL server, the PowerShell modules are installed by default, but if you wan’t to run scripts or commands from a computer/server that hasn’t got an installation of SQL, you need to install these manually.

Posted in Powershell | Tagged , , , , , | 2 Comments

SMS Despooler failed to merge delta to the compressed package

A few weeks back, a customer contacted me with an interesting problem, something that should be easily solved at first glance. The customer had tried to update the boot-wim with new drivers, distributed it again, but when everything stopped working, … Continue reading

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