Twitter
-
Recent Posts
- Configuration Manager 2012: SQL XPATH Query for Deployment Type
- Configuration Manager 2012: Query for the Application Owners and Support Contacts
- Add Adobe Acrobat XI and Reader XI catalogs to SCUP 2011
- SCCM 2012 Poor Console Performance In Software Updates
- Move all your Windows 8 Hyper-V VM’s to SSD with PowerShell
Recent Comments
- Estopa on Because of an error in data encryption, this session will end
- Adding A Basic PowerShell recovery to a Monitor | Living with SCOM on PowerShell Script To Restart Service And Dependents
- Tayyab on Script to fix duplicate SMS/SCCM GUID’s
- Ronald on OperationsManager Database Connectivity Issues After Migration
- Mike on Script to fix duplicate SMS/SCCM GUID’s
Archives
Categories
Meta
Author Archives: Stephen Leuthold
Configuration Manager 2012: SQL XPATH Query for Deployment Type
s
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 [...]
Configuration Manager 2012: Query for the Application Owners and Support Contacts
s
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 [...]
Add Adobe Acrobat XI and Reader XI catalogs to SCUP 2011
s
Adobe Acrobat XI (11): http://armmf.adobe.com/arm-manifests/win/SCUP/Acrobat11_Catalog.cab AdobeReader XI (11): http://armmf.adobe.com/arm-manifests/win/SCUP/Reader11_Catalog.cab Tweet
SCCM 2012 Poor Console Performance In Software Updates
s
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 [...]
Move all your Windows 8 Hyper-V VM’s to SSD with PowerShell
s
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 [...]
Beta Private Cloud exams from MMS not showing on MCP transcript
s
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 [...]
Report on SCOM Alert Notification Subscriptions
s
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 [...]
Enable Windows Authentication for Live Maps on a non-RMS Server
s
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 [...]
Mass reboot servers and workstations with PowerShell
s
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! Tweet
Resetting Logical Disk Fragmentation Monitor via PowerShell
s
I’ve been goog..errr bing’ing trying to look for a solution and most everyone points to the GreenMachine. Although a great and powerful tool that I have used on occasion, for some reason it does not filter for monitors in “Warning” only state and I cannot filter by monitor. In this case I will be resetting [...]