How-To Guides
Andrew Armstrong
Andrew Armstrong is a UK-based IT professional with 26+ years of hands-on experience in Windows, Windows Server, SCCM/ConfigMgr, Active Directory, PowerShell, and enterprise infrastructure.
He founded TechyGeeksHome in 2010 and has published over 1,500 practical guides covering real-world IT problems and solutions. When not solving IT problems,
Andrew develops free Windows utilities including Ultimate Settings Panel, which has been downloaded over 850,000 times.
How-To Guides
How-To Guides
SCCM Newly Discovered Devices: SQL Query for the Last 24 Hours
System Center
SCCM Last Logged User: Find by NetBIOS Name
System Center
SCCM Last Logged On User: Query for All Systems
System Center
SCCM Query Collections: Creating x86 & x64 Machine Collections
System Center
SCCM OSD Task Sequence: Prompting for Computer Name During Deployment
System Center
SCCM Asset Intelligence & Software Licensing Usage
System Center
SCCM Management Points Failing: Fixing the SMS Agent Host Service Issue
System Center
SCCM SQL Query: Count Different Operating Systems in Your Environment
System Center
SCCM Task Sequence Deployment: Running Packages from a Distribution Point
System Center
SCCM Collection Queries
How-To Guides