Introduction to Microsoft SCCM 2012
SCCM(System Center Configuration Manager) is Microsoft's software product to manage endpoints(Desktops,Laptops,Tablet,MobilePhones etc.) and widely use by companies from mid size to large enterprises.
Introduction to Microsoft Intune
Intune is Microsoft's MDM(Mobile Device Management) product and its a part of EMS(Enterprise Mobility Suite). Intune can be used as standalone or integrated with SCCM to manage mobile devices.
Introduction to Windows Powershell
Windows Powershell is Microsof't scripting environment comes with Microsoft Operating system. It is widely used scripting language to perform different kind of automation in Windows OS instlaled machines.
Introduction to Microsoft SQL Server
SQL Server is Microsoft Database and widely used a database server in Windows OS installed servers.As a SCCM specialiast, one must know about SQL server from querying database to administration.
Introduction to Windows 10
Windows 10 is Microsoft's latest client operating system and more advance than its previous versions like 8.1,8 and 7. Microsoft introduced lots of features in Windows 10.
Monday, August 31, 2020
What is GRS in Intune ?
Saturday, January 25, 2020
Windows Terminal Preview for SCCM Administrator
How to get Windows Terminal Preview version-
Open Windows Store(in some company, it may be blocked where you cant install it) and search for Windows Terminal or click the link(https://www.microsoft.com/en-us/p/windows-terminal-preview/9n0dx20hk701#activetab=pivot:overviewtab) to directly launch installation page.
1. Open Windows Store
2. Search for Windows Terminal
3. Windows Terminal (preview version) look like below. Since I already installed it, page shows the state and suggests to launch it.
4. Windows Terminal (preview version) looks like below after installation.
5. Azure Cloud Shell requires Azure login and tenant selection for launching it. Windows CMD and Windows Powershell doesnt require any login or condition to launch.
When you try to open Azure shell, it shows below message. Follow the message for launching it.
This code will expire in 15 minutes.
6. When you open all three terminals, they look like below
Windows Powershell is default terminal and every time you try to open Windows Terminal by clicking + signm it opens Windows Powershell. However you can click down arrow to open other two terminal or you can go to Settings and modify JSON file to make any of these three terminal a default terminal. You can also change the color of these terminals.
For more detail of settings, you can access document here https://aka.ms/terminal-documentation (Github page)
Saturday, May 4, 2019
Count of File Created Date Wise - PowerShell
Get-ChildItem "D:\Program Files\Microsoft Configuration Manager\inboxes\auth\ddm.box\regreq" | Where-Object {!$_.PSIsContainer} | Group-Object {$_.CreationTime.ToShortDateString()} -NoElement.
Location of file can be anything based on your requirement.
Hope this will help you.
Sunday, April 14, 2019
How to identify SQL Server job owner

Now in order to identify where the user has create a SQL Server job, you can run below query to get the job details owned by the user. Here we go:
Select Name from msdb.dbo.sysjobs
WHERE owner_sid IN
(
SELECT sid
FROM MASTER.sys.syslogins
WHERE Name = 'kirankr'
)
Once you get the job details, you have to remove the maintenance plan of that job from SQL Server Management Studio > Server Node > Management > Maintenance Plans > Get the plan name> Right click it > Delete . After successful removal of dependent job, you can delete the user from the database.Hope you like this post. If yes, do comment and share the post to those who needs it.
Saturday, April 13, 2019
How to Get Collection Folder Location in SCCM
Friday, January 11, 2019
How to corrupt or malfunction WMI manually
As we know that WMI is heart of OS(Operating System) as well as of SCCM. If it gets corrupted, we need to fix it in order to run OS and depended application smoothly. WMI uses the Common Information Model (CIM) industry standard to represent systems, applications, networks, devices, and other managed components. CIM is developed and maintained by the Distributed Management Task Force(DMTF).
We can corrupt WMI by removing a namespace. CIMv2 is not of the critical namespace of WMI. So, it can delete it, we will get success to corrupt WMI. We can use below Powershell command to delete CIMv2 in order to corrupt WMI.
Get-WmiObject -computername localhost -query "Select * From __Namespace Where Name='CIMV2'" -Namespace "root" | Remove-WmiObject
Hope, this helps those who are looking for intentional corruption of WMI.
Tuesday, November 13, 2018
How to disable a SCCM software update deployment using Powershell
Since Microsoft added Powershell as integral part of System Center Configuration Manager, SCCM admin has now option to use Powershell to apply automation. As a part of this automation, I will show you how to disable a SCCM software update deployment using Powershell command.
With below Powershell script(three lines of code), you can automate software update deployment status. Create a .PS1 file from below and run it(on demand or make a schedule task to run it as per requirement).
Import-Module "D:\Program Files\Microsoft ConfigurationManager\AdminConsole\bin\ConfigurationManager.psd1"
CD CST:
Set-CMSoftwareUpdateDeployment -SoftwareUpdateGroupName Mar18-2012R2 -DeploymentName Mar18-2012R2 -Enable 0
Please note below:
1) Location of SCCM installation may vary. In my case it was D drive. So please change location as per your requirement to get the .psd1 file.
2) CD CST: - CST is site code of my CAS site. It may be different in your case. Please change it as per your requirement
3) Set-CMSoftwareUpdateDeployment -SoftwareUpdateGroupName <name of your target SUG> -DeploymentName <name of you target deployment > -Enable 0
Enable > 0 means to turn off and 1 means to turn on the deployment.
Go back to console and you will find that your target software update deployment has been disabled.
If this post helps you or you like it, kindly leave below your valuable comment. Thanks.













