Month: January 2012

MMS 2012 Session Catalog hits 114, more to come

Just a quick, quick update on how the sessions for MMS 2012 are shaping up.  All sessions are currently undergoing community review for pertinence and value.  The session catalog is now up to 144 sessions with many more on the way.  Expect close to 175 sessions (maybe a bit more) once everything is finalized.

Microsoft releases version 2.1 of the WMI Diagnosis Utility

WMIDiag.vbs is a VBScript script designed to help you ascertain the current state of the WMI service on a computer. The download package includes the utility itself, a ReadMe file that discusses how the tool works (and how to best use it), and sample spreadsheets that provide information about the default WMI configuration on various versions of the Microsoft Windows operating system. Download link: Once downloaded, the executable asks for a place to extract 3 files: Best case, just create a new folder for the files so they are easy to find: The 3 files are a Word doc, the VB Script, and an Excel spreadsheet: You run the VB Script at the command-line using the following structure: WMIDiag.vbs starts sifting through your WMI re...

Offline WIM patching with DISM: a more automated method

This is a request that I get fairly often, and one that I’ve been working on for a while.  If you have an existing WIM and just need to update it with the latest patches that you have already deployed, it can be done quickly and easily with DISM.  I have seen several posts about injecting a single patch or downloading and copying patches to a single location, but if you already have them sitting on your ConfigMgr 2007 server, there’s no need to make extra copies.   First of all, you need to set up the folder structure.  I use a base folder named WIMs.  Within that folder, I have one batch file and one subfolder for each operating system type, with a common naming convention.  For this example I’ll use 7x64SP1.   Drop the WIM file in the subfolder with the same name.   Edit t...

Retrieving Dynamic Link Library Version Information From A Remote Machine

Use the following Vbs script to get the file name, manufacturer and version of a .Dll (or any other file for that matter) file from a remote machine. In the example below we are getting the Name, Version and Manufacturer for the C:\Windows\System32\Wbem\WbemCore.Dll. Note: In the script below notice that the path noted above has not one but two forward slashes (\\) to return the absolute path for the file you are querying. Vbs Script: strComputer = InputBox ("Enter Machine Name") Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colFiles = objWMIService.ExecQuery _ ("Select * from CIM_Datafile Where name = ‘C:\\Windows\\System32\\Wbem\\WbemCore.Dll’"...

Windows Live Writer and Mozilla Thunderbird Backing Up

Of the things that irks me when I have to rebuild my machine is having reconfigure Windows Live Writer for my blogs. Another huge pain is configuring Thunderbird for all of my non-work email accounts. I have a lot of folders and message rules setup for the various forums and email distribution lists I participate in and it’s frustrating to have to set those up again. This time around, I was able to find a couple tools to help make this process fairly seamless. Windows Live Writer Backup This tool was pretty straightforward, easy to use and worked like a champ. Windows Live Writer launched right up after restoring my data. Both of my blogs settings and templates were retained. I had to re-enter my passwords, otherwise everything was retained. Thunderbird Backu...

Last chance to vote & to request free SSRS report

VOTE today for either Count of Windows Experience Index or Count of Printers to become February’s free SSRS report give-away. Also, this is the last day to request January’s free SSRS report List of PCs with less than 10% free HD space. Email inf...

What do you do when your brand is failing? You create a Superhero team and an Infographic, of course

I guess we can expect to see more of these from RIM in 2012, as they attempt to grab back some market share and some dignity.

New KB makes a limited OpsMgr 2012 admin feel like a superhero

I read this Microsoft KB Article today and had a bit of a chuckle.  Basically, using the role-based access control with the OpsMgr 2012 and DPM 2012 integration, a restricted admin can submit a DPM job and get a notification of success.  It’s just a notification, though.  The role-based access still restricts the submitted action like it’s supposed to, it just tricks the operator into thinking it completed the restricted task. Funny. I can see this causing a bit of a Abbott and Costello moment in the IT group, but it’s good to know, particularly if the DPM event was supposed to happen. Read the full article:  System Center 2012 Operations Manager incorrectly reports that a restricted System Center 2012 Data Protection Manager action completed successfully

Last chance to vote & to request free SSRS report

VOTE today for either Count of Windows Experience Index or Count of Printers to become February’s free SSRS report give-away. Also, this is the last day to request January’s free SSRS report List of PCs with less than 10% free HD space. Email to get this free report! Here is a sample screenshot:

Creating a Microsoft Excel Spreadsheet With Excel Color Values VB Script

In response to questions I have received about Sending Vbs Results to Microsoft Excel files here is a brief script that will create a numeric list of the colors available for use with the Excel objects Interior and Font Color Indexes. In my previous post examples I have lines that read as follows that sets the color values for the Interior (Background) and Font Colors: After running the Vbs script below a Microsoft Excel workbook will open with the colors available for use with the Excel Object ColorIndex(s) and their associated numeric values. To modify my original posts change the numeric values 19 or 11 with the colors numeric values of your choice. For example if you want the font to appear as yellow (6) and the cells background to appear as a light gray (15) change the script lines ab...

Changing Column Data In SQL Server

There may be times when you need to modify data within a SQL table. This can be a daunting process if you have many renames or other changes to make. You need to use the SQL “Update” command to accomplish this. The basic syntax is as follows: Update <TableName> Set <Column> = ‘<NewDataValue>’ Where <Column> = ‘<ExistingDataValue>’   Using the NorthWind database as an example we can use the “Employees” table to change all occurrences of “Sales Representative” to “Sales Rep” using the query below: Update Employees Set Title = ‘Sales Rep’ Where Title = ‘Sales Representative’   If you have multiple changes to make within the same table the simplest way to accomplish this without writ...

PowerShell script to create AD accounts (II)

In my previous post, I blogged about how to create AD accounts using PowerShell and Quest PowerShell commands for AD. Below is a similar script with some modifications. What happens you get a csv file which doesn’t have a name column but have lastname, firstname etc. You want to create the AD accounts with certain format such as test_lastname. We just need some concatenations. import-csv Users1.csv |%{New-QADUser -ParentContainer ‘OU=abc, DC=xyz, Dc=com’ -name ($_.lastname+ ‘,’ +$_.firstname) -samAccountName(‘test_’ + $_.lastname)}