SQL Queries for SCCM

Computers that have 30 days or less hardware information SELECT a.ResourceID, a.Netbios_name0 AS[Name], b.LastHWScan FROM v_R_System a INNER JOIN v_GS_WORKSTATION_STATUS b ON a.ResourceID = b.ResourceID WHERE b.LastHWScan >= Dateadd(day, -30, getdate()) Collection of clients not approved SELECT a.ResourceID, a.Netbios_name0 AS[Name], a.ResourceType, a.SMS_Unique_Identifier0 AS[UniqueID], a.Resource_Domain_OR_Workgr0 AS[Domain], a.Client0, b.IsApproved FROM v_R_System a INNER JOIN v_CM_RES_COLL_SMS00001 b ON … Continue reading SQL Queries for SCCM


Getting email alert when imaging is finished

When Rebooting Is Not The Answer

I wanted to get some details every time a machine was imaged for my own details.  Mostly for asset tracking purposes I set up the below script to run at the end of my task sequence.

It is really nice to get all this info.

PC imaged is PCname with Serial R9ZRLB8 and Make and Model LENOVO 23594LU.  Processor is Intel(R) Core(TM) i5-3230M CPU @ 2.60GHz.  Ram is 8.00 GB.  Operating System is Microsoft Windows 10 Pro 10.0.15063

I suppose this could also be modified so that the tech imaging the machine could also get the email.  Maybe basing it off of the machine’s OU.  Hopefully someone finds this useful but I have found it quite handy.  I have also finished a script to gather logs when the task sequence fails and send them to me but I am still testing that out and will save that for my next…

View original post 46 more words

SCUP : Managing 3rd Party Updates in SCCM 2012 using SCUP

This guide will show you how to configure SCUP and deploy 3rd party updates(Adobe, Flash Player) With Microsoft Updates via SCCM 2012 using SCUP plus software update catalogs. Managing 3rd Party Updates in SCCM 2012 using SCUP 1- Installing and configuration SCUP 2011 It’s required to publish the updates to WSUS in order to deploy … Continue reading SCUP : Managing 3rd Party Updates in SCCM 2012 using SCUP

Transfer, Seize and Placement of FSMO role ( Third of three post series)

AN IT DIARY of Windows, SCCM & PowerShell

Hi Friends

So, now we are on third post of FSMO series. In first two post we had discussed what FSMO is and their details. If you have not checked them yet you can read them here:



In this final blog we will discuss transfer, seize and placement of FSMO roles. So, lets start.

View original post 804 more words

FSMO role ( First of three blog series)

AN IT DIARY of Windows, SCCM & PowerShell

Hi Friends

I hope this blog finds you in good health and spirit. Most of the time I am training people on AD and Windows Server technologies and FSMO role is most common topic which is discussed often. So. I thought to compile the information in a blog which will work during training session and also for post-session review. So lets start.

View original post 263 more words

How to know if your computer supports BIOS/UEFI/Device Guard/Credential Guard ?

AN IT DIARY of Windows, SCCM & PowerShell

Hi Friends

Recently I was involved in Windows 10 imaging project through SCCM. In our task sequence we had BIOS to UEFI conversion step. Also we supported device guard and credential guard in Windows 10. Post imaging we had to verify if these features are enabled on our imaged machine which can be achieved through simple steps. I thought to compile this information for  reference. Hope it will be useful for you too. So, here are the steps:

  1. Run msinfo32 from command prompt.
  2. You can verify settings from “System Summary”.

Simple, isn’t. 🙂

You can also check for BIOS or UEFI support by browsing c:WindowsPanther and opening setpact.log.

Search for Callback_BootEnvironmentDetect: Detected boot environment. The value should show BIOS or EFI.

So, that’s all in this quick post. See you soon with another technical stuff. Till then “ta-ta”

View original post

Step by step troubleshooting of content distribution on distribution point in SCCM 2012

AN IT DIARY of Windows, SCCM & PowerShell

Hi friends

Hope this post finds you good health and spirit.This will be my second post on step by step troubleshooting series on SCCM. You can find first post here:


View original post 342 more words

SCORCH : An introduction to Orchestrator – Schedules

Schedules enable you to define when a Workflow or Activity can run. For example, there may be times when it is inappropriate to run some Workflows, such as running a backup Workflow on a main server during regular business hours. 1. Checking a Schedule This Workflow uses the Check Schedule Activity to match the current … Continue reading SCORCH : An introduction to Orchestrator – Schedules