Tag Archives: SQL

Update ConfigMgr packages with Hotfix-information

When you install a hotfix and/or a cumulative update in ConfigMgr you can select the option to let the installer create some packages. But, those packages are missing some info… For instance Manufacturer and Version. A quick and dirty SQL … Continue reading

Posted in ConfigMgr, SQL Server | Tagged , , , | Comments Off on Update ConfigMgr packages with Hotfix-information

SQL in Powershell without cmdlets

I am currently playing around with ConfigMgr 2012 cmdlets… and they only run in X86 (*doh*). Anyway, I need to query a database with information about some collections and other stuff I need to create… and running SQL Server cmdlets … Continue reading

Posted in PowerShell, SQL Server | Tagged , , , | Comments Off on SQL in Powershell without cmdlets

Update ConfigMgr Site Description

I did an install of a secondary site and accidently put in the wrong description… Anyway, easy to fix with some SQL commands. If you use this you can see the current sitenames and descriptions (change CM_XYZ to your database … Continue reading

Posted in ConfigMgr, SQL Server | Tagged , , | 1 Comment

OpsMgrDW Grooming

After a while my demo environment with OpsMgr data warehouse (and loads of other stuff) needed some more space. I haven’t looked in to grooming of the DW before. So as usual Google is a nice friend. 🙂 Stefan Stranger … Continue reading

Posted in OpsMgr | Tagged , , | Comments Off on OpsMgrDW Grooming

SCCM Status Message Query for Advertismet

Made a small combination of a couple of queries, so this will show “Clients That Ran, Received, Rejected or Started a Specific Advertised Program”

Posted in ConfigMgr | Tagged , , | Comments Off on SCCM Status Message Query for Advertismet

Change Collection Refresh Rate

Had some problems with loads of collection refresh taking all of the CPU on the SCCM-server. So first, to get the SCCM-server to calm down I wrote a small (and somewhat ugly, since it uses SQL) hack: This script uncheck … Continue reading

Posted in ConfigMgr, VBScript | Tagged , , | Comments Off on Change Collection Refresh Rate