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
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
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
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
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
This is second of three blog series. In first blog we had discussed what is FSMO. If you have not checked my first post you can check it here:
In this post we will discuss FSMO roles in detail. So lets start.
View original post 1,363 more words
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
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:
- Run msinfo32 from command prompt.
- 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”
Hope this post finds you in good health and spirit. Recently, I got opportunity to do few OS troubleshooting trainings and realized that some of the participant were not well aware of windows booting process which indeed helps a lot in different troubleshooting especially startup ones.
View original post 692 more words
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