SCCM (System Center Configuration Manager) 1806 Step by Step Upgrade Guide

SCCM (System Center Configuration Manager) 1806 Step by Step Upgrade Guide

Microsoft has released new version of in-console update ie 1806 for SCCM Current Branch. You can apply this updated on sites that run  version 1706, 1710 or 1802. Continue reading “SCCM (System Center Configuration Manager) 1806 Step by Step Upgrade Guide”

SCCM (System Center Configuration Manager) 1802 Step by Step Upgrade Guide

This is a Step by Step Upgrade guide for SCCM 1802. Baseline Version Release (For fresh installation of SCCM, you require baseline version): Microsoft has recently released Baseline version of SCCM, ie 1802 version of SCCM. SCCM 2012 can be upgraded using this version of SCCM as you can download the complete source of SCCM 1802 through Volume Licensing Service Center. This also means that if you have to do the fresh setup of SCCM, you can use this Baseline version for installation.
Most recent baseline versions are SCCM 1702 and 1802.

Continue reading “SCCM (System Center Configuration Manager) 1802 Step by Step Upgrade Guide”

Software Metering report – Specific Application not used since last 90 days

Here is a SQL query to build a report showing a specific application not been used for last 90 days. I have used Microsoft Word as an example. You need to make sure the winword.exe is enabled as Software meter rule in your SCCM environment. You may modify based upon your requirement and better to use it with parameter so that you can have a more powerful way to select from list of application:

SELECT vr.name0,
MU.UserName,
vu.full_user_name0,
SF.FileName,
SF.FileVersion,
MAX(MUS.LastUsage) as “LatestDate”,
GETDATE() as “CurrentDate”,
DATEDIFF(day,MAX(MUS.LastUsage),GETDATE())
FROM v_MeteredUser MU
INNER JOIN v_MonthlyUsageSummary MUS ON MU.MeteredUserID = MUS.MeteredUserID
INNER JOIN v_GS_SoftwareFile SF ON MUS.FileID = SF.FileID
INNER JOIN v_r_system vr on mu.username=vr.user_name0
INNER JOIN v_r_user vu on mu.username=vu.user_name0
where sf.filename in (‘Winword.exe’)
group by vr.name0,MU.UserName,vu.full_user_name0, SF.FileName, SF.FileVersion
HAVING (DATEDIFF(day, MAX(MUS.LastUsage), GETDATE()) >90)
ORDER BY vr.name0,MU.UserName,vu.full_user_name0

Understanding / Setting up Heartbeat Discovery & Client Activity

Hi Folks,

Today I am going to discuss about Heartbeat setting, Discovery Data, Other sorts of Discovery impacting Client Activity making client Inactive / Active and how to define the settings. And this is going to impact the discovered data to be deleted using “Delete Aged Discovery Data” maintenance Task.

Continue reading “Understanding / Setting up Heartbeat Discovery & Client Activity”

Bitlocker – Not able to stage Boot Image on Bitlocker Partition

Issue

While working on one of the the issue, we found that Task Sequence was failing with error code (0x80070070).

If you look for the error code, it is equivalent to:
This problem we were facing for existing machines (which were already built previously), any new purchased systems were not causing issue.

Continue reading “Bitlocker – Not able to stage Boot Image on Bitlocker Partition”

SCCM (System Center Configuration Manager) 1710 Step by Step Upgrade Guide

Microsoft has recently released 1710 version of SCCM. Keep in mind this is an In-console update, not a baseline version. You can upgrade to 1710 only from SCCM version 1610,1702,1706. If you have to do a fresh setup of SCCM. Then first you need to install SCCM using Baseline version 1702, once installed – 1710 can be installed as In-Console update.

Continue reading “SCCM (System Center Configuration Manager) 1710 Step by Step Upgrade Guide”

Windows 7: Creating Fully patched Image by Slipstream in the Convenience Rollup and Quality Rollup

Hello guys, today I am going to brief you about creating a perfect Windows 7 image having all latest updates till October’2016 (at the time when I updated and tested the image)

Continue reading “Windows 7: Creating Fully patched Image by Slipstream in the Convenience Rollup and Quality Rollup”