System Center 2012 R2 Preview Highlights

This was announced at TechEd 2013 yesterday and they are anticipating a release by the end of the year. This release will be the successor to System Center 2012 SP1.

System Center 2012 R2 Preview: http://www.microsoft.com/en-us/server-cloud/system-center/system-center-2012-r2.aspx

White Paper: http://download.microsoft.com/download/7/7/2/7721670F-DEF0-40D3-9771-43146DED5132/System_Center_2012%20R2_Overview_White_Paper.pdf

System Center 2012 R2 Configuration Manager: http://www.microsoft.com/en-us/server-cloud/system-center/system-center-2012-r2-configuration-manager.aspx

System Center 2012 R2 Configuration Manager Highlights:

  • Support for Windows 8.1
  • Support for Windows Server 2012 R2
  • Maintenance Windows exclusively for Software Updates
  • UI Improvements
  • Automatic Deployment Rules (ADR) improvements for software updates
  • Clearer summary messages
  • Enhanced DP data usage reports
  • Creation, modification and offline servicing of VHDs and the uploading of VHDs to System Center 2012 R2 Virtual Machine Manager

System Center 2012 R2 Operations Manager Highlights:

  • Availability and performance metrics across storage, network, and compute for the datacenter administrator
  • New dashboard includes health metrics on a variety of resources, such as load balancers, IIS pools, storage LUNs, hosts, storage pools, file servers, VMs, VMM servers and host clusters.
  • System Center Advisor (Best practice workload configuration) accessibility in the Operations Manager console
  • Hybrid view of on-premise and cloud hosted components
  • Code level issue traceability – for .NET and Java applications
  • Java APM (Application Performance Monitoring) including Java Tomcat and other Java web services
  • Unified monitoring agent between System Center and Visual Studio to further simplify issue debugging and collaboration.

Windows Server 2012 R2: http://www.microsoft.com/en-us/server-cloud/windows-server/windows-server-2012-r2.aspx & http://technet.microsoft.com/en-US/windows/dn140266.aspx

Windows 8.1:  http://technet.microsoft.com/en-US/windows/dn140266.aspx

Microsoft, System Center 2012 , , , , Leave a comment

Configuration Manager 2012: SQL XPATH Query for Deployment Type

Below is an example of how to write a SQL XPATH query to extract details from a deployment type CI contained in an XML data type. In this query we are returning columns for deployment type Title, SDMPackageDigets (XML), Technology (MSI, Script, etc.), Content Location, and Install and Uninstall strings. I basically found an example in this link http://gallery.technet.microsoft.com/scriptcenter/Count-of-EP-Definition-59c06ea2 and added Install and Uninstall columns.

 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
SELECT 
	CI_ID,
	CI_UniqueID,
	SDMPackageDigest,
    SDMPackageDigest.VALUE('declare namespace p1="http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest"; 
    (p1:AppMgmtDigest/p1:DeploymentType/p1:Title)[1]', 'nvarchar(max)') AS DTTitle,
    SDMPackageDigest.VALUE('declare namespace p1="http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest"; 
    (p1:AppMgmtDigest/p1:DeploymentType/p1:Installer/@Technology)[1]', 'nvarchar(max)') AS DTTechnology,
    SDMPackageDigest.VALUE('declare namespace p1="http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest"; 
    (p1:AppMgmtDigest/p1:DeploymentType/p1:Installer/p1:Contents/p1:Content/p1:Location)[1]', 'nvarchar(max)') AS DTContentLocation,       
    SDMPackageDigest.VALUE('declare namespace p1="http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest"; 
    (p1:AppMgmtDigest/p1:DeploymentType/p1:Installer/p1:InstallAction/p1:Args/p1:Arg)[1]', 'nvarchar(MAX)') AS Install,
    SDMPackageDigest.VALUE('declare namespace p1="http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest"; 
    (p1:AppMgmtDigest/p1:DeploymentType/p1:Installer/p1:UninstallAction/p1:Args/p1:Arg)[1]', 'nvarchar(MAX)') AS Uninstall
FROM 
	v_ConfigurationItems
WHERE 
	CIType_ID = 21 -- DeploymentType CI's
Configuration Manager, Microsoft, System Center 2012 , , , , , , , , , , Leave a comment

Configuration Manager 2012: Query for the Application Owners and Support Contacts

Below is an example of how to formulate a SQL query to obtain the “first” app owner and support contact on an Application.

 

1
2
3
4
5
6
7
8
9
WITH XMLNAMESPACES ( DEFAULT 'http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest' )
SELECT
SDMPackageDigest.VALUE('(/AppMgmtDigest/Application/Title)[1]', 'nvarchar(MAX)') [Title],
SDMPackageDigest.VALUE('(/AppMgmtDigest/Application/Owners/User/@Id)[1]', 'nvarchar(MAX)') [Owners],
SDMPackageDigest.VALUE('(/AppMgmtDigest/Application/Contacts/User/@Id)[1]', 'nvarchar(MAX)') [Support Contact]
FROM  CI_ConfigurationItems
WHERE
CIType_ID = 10
AND IsLatest = 1
Configuration Manager, Microsoft, System Center 2012 , , , , , , , , Leave a comment

Add Adobe Acrobat XI and Reader XI catalogs to SCUP 2011

Adobe Acrobat XI (11):

http://armmf.adobe.com/arm-manifests/win/SCUP/Acrobat11_Catalog.cab

Acrobat11

AdobeReader XI (11):

http://armmf.adobe.com/arm-manifests/win/SCUP/Reader11_Catalog.cab

Reader11

Configuration Manager, Microsoft, System Center 2012 , , , , , , , , , , Leave a comment

SCCM 2012 Poor Console Performance In Software Updates

UPDATE 5/21/2013: Just heard from the MVP community that some folks are referencing this article to improve performance: http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

From within Microsoft SQL Management Studio, run the query below to check fragmentation:

1
2
3
4
5
6
7
8
9
SELECT a.index_id, name, avg_fragmentation_in_percent FROM
 
sys.dm_db_index_physical_stats (NULL,NULL, NULL, NULL, NULL) AS a JOIN sys.indexes
 
AS b ON a.object_id = b.object_id AND a.index_id = b.index_id WHERE
 
avg_fragmentation_in_percent > 30
 
GO

 

2)    Run this command on the tables:

1
2
3
Exec sp_MSForEachtable 'DBCC DBREINDEX (''?'')'
 
go

 

3)    Once this was done, run the “Rebuild Indexes” task from Site Maintenance of the primary server.

 

4)    Finally run this command back on the SQL Server via SQL Management Studio.

1
2
3
EXEC sp_MSForEachTable "UPDATE STATISTICS ? with fullscan"
 
GO

 

 

Configuration Manager, System Center 2012 , , , , , Leave a comment

Move all your Windows 8 Hyper-V VM’s to SSD with PowerShell

I built a lab on my Windows 8 laptop consisting of System Center 2012 Configuration Manager, Operations Manager, Configuration Manager, a DC, SQL, and SharePoint. Although it runs so-so on my 7200RPM hard drive I decided to join the club and finally get an SSD for a secondary drive. After months of research I ended up with the Intel 330 240GB SSD and purchased it on Amazon for about 180$. This blog post addresses two items. First I had problems with my OS locking up when attempting to format my new SSD. And second moving Hyper-V VM’s to a new drive.

Trouble formatting new *Intel* SSD

I had some difficulty formatting the drive in Computer Management. Every time I attempt to format it, it would lock up my OS. So here are the steps I took to resolve it:

!!!! WARNING: this will destroy all data on the target disk !!!!

  1. Download and install Intel SSD Toolbox
  2. Open an elevated cmd prompt.
  3. Type diskpart.exe and hit enter
  4. list disk
  5. select disk # (the disk you want to clean)
  6. clean all (more info on this command and diskpart http://technet.microsoft.com/en-us/library/cc766465%28v=ws.10%29.aspx )
  7. It will take 10-20 minutes or so but after these steps I was able to format the drive.

Also note that 64K unit allocation size is recommended for drives where VHDX’s will be stored (since they will be large files). This unit size is not recommended for smaller files. You can use the wizard in computer management or run format FS=NTFS LABEL=”L.A.B.” UNIT=64k QUICK in disk part.

Moving your Hyper-V VM’s via PowerShell

After installing my shiny new SSD I sure as heck wasn’t going to move all my VM’s manually, so PowerShell it is!

Here is a good start to become familiar with the Hyper-V PowerShell cmdlets. Just be sure to run the PowerShell ISE is elevated mode! http://social.technet.microsoft.com/wiki/contents/articles/8700.windows-server-8-manage-hyper-v-3-0-with-powershell-en-us.aspx

After you familiarize yourself with some of the cmdlet’s there is some really slick ones for moving VM’s around:

  • Move-VM (Moves the VM to another host)
  • Move-VMStorage (Moves all of the VM’s dependencies to another location)

I’m moving my VM’s to my new SSD on my laptop so Move-VMStorage was the best route!

  1. Start with Get-VM to get a list of VM’s
    Get-VM
  2. Now you will want to copy that to a variable. Let’s say $VMs via
    1
    
    $VMs = Get-VM
  3. Now for each of these $VMs we will want to execute Move-VMStorage to (in my case) D:\.
    1
    2
    3
    4
    5
    6
    7
    
    $DestinationPath = "D:\SCSM Lab"
    ForEach ($VM in $VMs) {
    	$VMName = $VM.Name.toString()
    	Write-Output "Moving $VMName"
    	Move-VMStorage -VMName $VM.Name -DestinationStoragePath "$DestinationPath\$VMName"
    	Write-Output "Finished Moving $VMName"
    }

    A progress bar will appear indicating the move is occurring:
    Move-VMStorage

  4. That’s pretty much it :) . You will also be able to migrate them while they are still running, although it could take longer.

Full script:

1
2
3
4
5
6
7
8
$VMs = Get-VM
$DestinationPath = "D:\SCSM Lab"
ForEach ($VM in $VMs) {
	$VMName = $VM.Name.toString()
	Write-Output "Moving $VMName"
	Move-VMStorage -VMName $VM.Name -DestinationStoragePath "$DestinationPath\$VMName"
	Write-Output "Finished Moving $VMName"
}
Microsoft, PowerShell, Windows 8 , , , Leave a comment

Beta Private Cloud exams from MMS not showing on MCP transcript

A few month ago I came across Kevin Holman’s blog post on checking the status of the Private Cloud beta exams I took at MMS (71-246 Monitoring and Operating a Private Cloud with System Center 2012 & 71-247 Configuring and Deploying a Private Cloud with System Center 2012) and to my excitement I passed both (I was NOT dancing around my house in celebration :D ). All I needed then was an MCSA: Windows Server 2008 and I’d have my MCSE: Private Cloud certification! So I’ve been hitting the books the past few months and taking practice exams in order to prep for my MCSA: Windows Server 2008 exams. (70-640, 70-642, and finally today passing 70-646!) All the hard work, late nights, spousal complaints (love ya dear), and early mornings on my aggressive schedule paid off.

But wait, my two Private Cloud beta exams are still not showing up on the damn MCP site! It’s been over four months! I need support! I don’t really like to call into support (even though sometimes it’s usually faster) and ended up using the MCP site’s chat feature in the support section, see our exchanges below…

Sponsors, article continues below...

Continue reading »

Certification, Microsoft, Private Cloud, SCCM, SCOM , , , , , Leave a comment

Report on SCOM Alert Notification Subscriptions

Trouble tracking down alert notifications? A good word of advice is to be sure to include the notification subscription ID in your alert channel, such as follows…

Sponsors, article continues below...

Alert: Logon Failures – Multiple failures by same User on single Machine
Severity: 2
Source: ADS04.Domain.pvt
Path: ADS04.Domain.pvt
Last modified by: System
Last modified time: 9/22/2011 11:47:49 AM

Alert description: Multiple Logon Failures by user DOMAIN\user01 with logon type 0xffffffffc0000225. See Alert Context for more details.

Alert view link: “http://RMS01:51908/default.aspx?DisplayMode=Pivot&AlertID=%7bdbe48f98-2051-4d83-aecb-664a07c0eb46%7d”
Notification subscription ID generating this message: {BB47B5DE-176C-524C-FC13-2C8576C7000E}

Continue reading »

Microsoft, SCOM , , Leave a comment

Enable Windows Authentication for Live Maps on a non-RMS Server

I’ve wanted to move my Live Maps installation off of my SCOM 2007 R2 RMS for some time now. But until recently I was under the impression that it was not possible to do this with Windows based authentication enabled in Live Maps. I attended MMS 2011 and stopped by the Savision booth in the expo to preview Savision’s new Vital Signs product (A must see!) and got to talking about this issue with Dennis Rietvink of Savision. He said it was very possible and to contact their support. So when I got back from MMS I did and Michiel Rens at Savision support referred me to Kevin Holman’s blog for a possible solution. Kevin goes into quite a bit of detail on the work around. He is providing a solution if you want to run the SCOM console on another server with Windows based authentication, although most of the solution enables the same for Live Maps. Please read Kevin Holman’s blog in detail before continuing. The goal of this post is to communicate what worked for me, in my environment. My environment consists of a Windows 2008 R2 RMS, a Windows 2008 R2 Live Maps server, and Windows 2008 R2 function level AD. All environments vary on operating systems, AD function levels, and security policies. So be sure you know exactly what you are doing before implementing this solution!

Continue reading »

Microsoft, SCOM , , , , , 1 Comment

Mass reboot servers and workstations with PowerShell

We’ve got a bunch of servers stuck in pending reboot state due to SCCM updates. There is no way I’m rebooting 50 servers manually! PowerShell to the rescue!
Continue reading »

Microsoft, PowerShell , , , Leave a comment