Author: Daniel Belcher

Query Reboot Suppression CM2012…

Laziness is the true mother of necessity I think in IT, and the tedious act of viewing multiple properties pages brought about this one liner.  If you too are setting up diverse deployment sets and need to quickly verify multiple deployments for reboot supression state. Here’s a way to do it in powershell: gwmi -namespace "root\sms\site_<sitecode>" -query "select assignm...

Site Backup Failed on SQL Cluster CM12 SP1…..

Soooo…… After GatherWriterMetadata SMS Writer status = FAILED_AT_PREPARE_BACKUP. SMS_SITE_BACKUP 2/4/2013 3:32:38 PM 8500 (0x2134) Error: VSS_E_WRITERERROR_TIMEOUT. Error Code = 0x80,042,3f2. SMS_SITE_BACKUP 2/4/2013 3:32:38 PM 8500 (0x2134) vssadmin list writers hmmmm, it’s there.  Let me check the sms_site_sql_backup service on the database servers. Ok, lets check our permissio...

WSUS Post Installation Configuration Task Failed…

So this is a quick blog for a frustrating issue, that is actually very easy to resolve. If you are on Windows Server 2012, and you’ve had to reinstall WSUS for any reason and receive the following error in your tmp log after attempting to finalize the installation: 2013-02-20 16:04:17  Creating default subscription. 2013-02-20 16:04:17  Instantiating UpdateServer 2013-02-20 16:04:19  CreateDefault...

Machines with no CM07 client…

Alright, so if you read my previous post for AD to DB then this post will make more sense.  However if you haven’t; then now would be a good time to… go ahead, I’ll wait. Now one of the primary purposes I had for this data was to leverage it against my v_r_system view and determine which active assets are missing their client.  Well that’s fine and good, but I had been in the habit of ta...

SCCM 07 Health Check Logon Framework…

So I had another problem, and one I know I’m not alone in… I’ve got clients that are failing, won’t install, have corrupt wmi repositories, and obviously I can’t deploy a repair solution to them so what do we do? Well like most people in an enterprise environment (or smaller I’m sure) we maintain a logon script, and considering that this script will run come hai...

Quick AD Asset Management Tool…

Alright, so Active Directory Asset Management.  What is it? Well a, not so, unique problem facing every enterprise large or small, is asset management. Now asset management is not a one dimensional issue, there are requirements and facets to it that shift depending on the person you ask.  From an engineering and maintenance standpoint at my company we have needs of tying important information as c...

Logging class object vbs…

Ok, so I’ve not posted anything for a few days and I felt the need to throw a brief technical post up with a code snippet from a current project I’m working on. I’m building a health check logon script and as part of that framework I wanted to build a logging object. Since the target format has to be vbscript for what I’m doing, I’ve built it as such, and in a format ...

Dictionary wrapper object

So similarly to the logging class object I posted back on December 16th; I’m posting a dictionary wrapper object I’ve built to enhance it’s (scripting.dictionary) usage for creating indexed arrays, concatenating strings, etc… As with the Logging class object, it must be instantiated to use, so… Dim Dict Set Dict = New cls_Dict Call Dict.Add("stuff","my message") Wscript.Echo Dict.Key("stuff"...

Failing MP.MSI repair 1603 SCCM 2007…

Ran into this on a failing MP repair in our DMZ.  The error was a 1603, and according to the mp.msi logs it was unable to create the virtual directories for the MP to function.  What was looking like a complete IIS rebuild turned out to be a known issue surrounding BITS; and a far simpler solution then I had originally imagined. The long and short or it; uninstall and reinstall the BITS feature, t...

Select more, cool, stuff from SQL

Alright, so last time I closed out my(sql) post I promised some more advanced queries etc. Well let’s first start by playing around with some basic query syntax. Think back to what I wrote about it being a logical grouping of data like a spreadsheet. So surely we can pull specific data right? Of course, this is where sql shines, and it couldn’t be simpler. select user_id0 from temp.test_users; Pre...

Building custom SQL collections in SCCM

Ok, in a previous post I built multiple collections that determine client inventory health. So the end result is the ability to build collections based off of machines who haven’t reported to one or more inventory types for X number of days and have the script deployed to them auto-magically with the corresponding inventory type. This is one of the areas where SCCM (from the console level) becomes...

Stick to the Script PS C:> PowerShell …

Now, it’s time to evaluate PowerShell.  As of late, PowerShell has become my preferred method for scripting.  PowerShell is built on top of the .NET framework.  It uses cmd-lets (commandlets) to perform the majority of it’s command line actions.  It’s also fully integrated with WMI and the .NET Framework.  It works off of Objects, which we discussed previously with VBScript.  It shares a lot of si...

  • 1
  • 2