SQL Query to know how many clients are connected to Internet MP in Endpoint configuration manager

After Implementing CMG, configuration manager management point keeps the ability to allow both the Intranet and Internet traffic. If you have allowed the Internet traffic to your servers then you might be thinking about how many clients machines are approaching the servers through Internet traffic ( CMG ) All these possible by using the SQL … Continue reading SQL Query to know how many clients are connected to Internet MP in Endpoint configuration manager

SQL Query to get all SCCM servers with their roles

Most of the time system administrator struggle to find all the SCCM servers with their roles. I have created one sql query to get the details servers with the roles. Query is below SELECTsrs.ServerName,srs.SiteCode,vs.SiteName,vst.AD_Site_Name0 as ADSite,vs.ReportingSiteCode as Parent,vs.Installdir,MAX(CASE srs.rolename WHEN 'SMS Site System' THEN 'Yes' Else ' ' END) as SiteSys,MAX(CASE srs.rolename WHEN 'SMS Component … Continue reading SQL Query to get all SCCM servers with their roles

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, MEM & 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, MEM & 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, MEM & 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