SQL Server Inventory Using ConfigMgr

Here’s a script to gather complete SQL Server inventory information using ConfigMgr. I’ve tested and used it to gather information on SQL Server 2005, 2008, 2008 R2, and 2012. I haven’t tested it on 2014 explicitly, but it should work fine. Note that Sherry already has a series of mof edits posted at Installed SQL05, SQL08, SQL12, SQL14 […]

The post SQL Server Inventory Using ConfigMgr appeared first on ConfigMgrFTW!.

Read More»

Top 10 Software License Optimization Blogs from 2014

By John Emmitt Well, its that time of year again– time to take a look back at the most popular Software License Optimization blogs for 2014. Here are the top 10: Oracle Database License Management in VMware Virtual Environments (Part 1 of 3) Oracle Database License Management in VMware Virtual Environments (Part 2 of 3) Windows Server 2012 Datacenter vs. Stacked Standard Edition Licenses Why a SKU is Important to Software Asset Management Oracle’s Magic Ratio Microsoft SQL Server Licensing Showdown — Core versus Server + CAL Oracle Database License Management in VMware Virtual Environments (Part 3 of 3) SAP–…

Read More»

Microsoft Second Shot Exams are Back

Between January 5 and May 31, 2015, take any Microsoft Certified Professional (MCP) or Microsoft Dynamics exam, and get a free Second Shot if you fail the first take. With our full transition to Pearson VUE as our sole exam delivery provider this year, there’s a slight difference in the Second Shot process. Please note: You must complete a Microsoft...

Read More»

ConfigMgr 2012: Quick Model Count in SQL

Posted in CM2012ConfigMgrSQL

Here is just a quick SQL query you can use to show how many of each model you have in your environment.  I’ve got a Manufacturer filter on it, but you could remove that or modify as necessary.   1: SELECT 2: C.Model0, 3: COUNT(*) AS ‘Count’ 4: FROM 5: dbo.v_gs_computer_system C 6: WHERE 7: […]

Read More»

SCCM 2012 – Powershell for Creating iOS Store Apps

Hi All, Have you ever need an application/dt based on an iTunes link? if yes, you know how time consuming it is and the experience is not great. Based on this, i’ve created this powershell that will, from a itunes link, identify the name of the application, publisher, category and create a new application (if needed) as well as a new deployment type called iOS, also if needed. to use this powershell, you need to pass the sdkserver and the sitecode as well as a text file with the iTunes links (1 per line) the text file should look like the following: https://itunes.apple.com/gb/app/microsoft-word/id586447913?mt=8 https://itunes.apple.com/gb/app/microsoft-powerpoint/id586449534?mt=8 https://itunes.apple.com/gb/app/microsoft-excel/id586683407?mt=8 the command line would look like: .\ImportiTunesApplication.ps1 -sdkserver “SRV0007″ -sitecode “CLC” -filename “c:\temp\ituneslist.txt” at the end, you’ll see all apps being created [crayon-54afae865b366193407282/]  

Read the complete blog: http://thedesktopteam.com/blog/raphael/sccm-2012-powershell-for-creating-ios-store-apps/

Read More»

Breaking News! The Release of CMMap 2.0!

By Garth Jones To start the New Year off in a great way, Jeff Tondt released an update to SMSMap and renamed it CMMap! http://www.tondtware.com/default.htm CMMap is a freeware Configuration Manager 2012 / 2007 / SMS 2003 hierarchy drawing tool. It is an all-in-one solution for creating Visio drawings of any combination of ConfigMgr 2012 / 2007 and SMS 2003...

Read More»

Webinar Q&A: Installation Best Practices—Tips for Building Upgrades, Updates and Patches

For every upgrade, update or patch you create, you have a second chance to create a great first impression with your end users. In “Installation Best Practices: Tips for Building Upgrades, Updates and Patches,” webinar attendees were eager to learn best practices to follow when creating and deploying an update-friendly Windows Installer (MSI) installation. Here are the top questions and answers from the webinar. 1. Q: When do I use a major upgrade versus a patch? A: First, ask yourself how it will impact your business development needs. If you don’t have time to do thorough testing and QA, then…

Read More»

Microsoft Intune App-layer – Microsoft Intune App Wrapping Tool

In the first blog about the Microsoft Intune App-layer protection, one of the supported features is that you are able to wrap your own applications with the Microsoft Intune App Wrapping Tool for iOS so that you are able to manage those applications with the Mobile Application Management policies. In this second blog in the series, we will have a...

Read More»

What is Microsoft Intune App-layer protection?

One of the many many new features of Microsoft Intune releases the last couple of months is the Intune App-Layer protection. In short, with Intune App-layer protection you are able to protect your corporate data with managed apps, in other words Mobile Application Management support is added to Microsoft Intune. But how do we manage apps with Microsoft Intune and...

Read More»

Great start For #SysCTR in 2015

We are just 8 days into 2015 and already there has been a lot of great things happening in the space. First off DPM has just received a highly anticipated feature. DPM now has Deduplication of the DPM Storage. The storage savings is anywhere from 50% to 90%! This is a huge improvement for DPM. […]

Read More»

Help Choose Enhansoft’s Next Free SQL Server Reporting Services (SSRS) Report for the Month of February

The report choices in January’s poll are: Computer Adobe Details OR Count of PCs by Wakeup Types. VOTE HERE! a) In the Computer Adobe Details report you will see information about the Adobe SKU and license type installed on a specific PC. In the full-feature set, this is the final drill through report from List of PCs by Adobe License...

Read More»