How to read SQL Agent logs using Windows PowerShell
Prerequisite: SQL Management Studio needs to be installed. [System.Reflection.Assembly]::LoadWithPartialName(‘Microsoft.SqlServer.Smo’) ...
Recent posts
Powershell Functions do not return single element arrays
I came across an interesting problem today that a function I wrote to return all SCCM primary sites worked at work but did not work at home. the difference b...
How to locate SCCM Collection Object based on the Collection ID
Often, I found it’s hard to locate the Collection object in the SCCM console if you only know the Collection ID. Couple of weeks ago I ran into a situation w...
Hyper-V virtual machines with “Missing” status
I’m currently running Hyper-V R2 on a machine with 24GB of memory at home. It hosts most of my test machines such as SCCM, SCOM, Exchange, etc. System Center...
Incorrect description in SCCM Report License 03B – Computers with a specific license status (Report ID 350)
On the SCCM Report “License 03B – Computers with a specific license status” (Report ID 350, category Asset Intelligence), the description states there are 5 ...