Pull list of computers for a specific model
This tip requires a limited knowledge of SQL Server Management Studio. Paste this query into SSMS and modify the WHERE statement to pull the model that you are looking for. In this example, I was getting all Dell Latitude E6*20 series, with returned E6320, E6420, and E6520 devices.
SELECT ResouceID,Manufacturer0,Model0,Name0
FROM v_GS_COMPUTER_SYSTEM
WHERE v_GS_COMPUTER_SYSTEM.Model0 like ‘%Latitude E6%20%’
At some point, you may need to lock a computer to a specific version of Windows 11. This could be because of a compatibility issue with a critical app or device, the need to maintain more
ConfigMgr collection sync is a feature that has been in ConfigMgr for a few versions. At a high level, it syncs the membership of a collection to a group in Entra ID that can then be
Mergers and acquisitions promise growth, but the operational aftermath often reveals a deeper challenge… It involves integrating people, systems, and processes. While most attention stays on financials, contracts, and branding, the complexity of unifying HR systems
1. Exchange Online: Temporary Mailbox Access Disruption via MAPI Overview Some Exchange Online users experienced mailbox access issues via the Messaging API (MAPI) on August 20, 2025. The disruption occurred after Microsoft reverted a recent service
Growth in your organization often exposes what scale often conceals… Disjointed HR systems stitched together via inefficient manual effort and fragile workflows. Payroll lives in one platform, benefits in another, identity data floats untethered in AD,
HR chatbots are not futuristic ambitions anymore. Certainly, they are now workflow enablers. At their core, these AI agents interface between employees and backend systems. They answer queries, trigger actions, surface personalized information, and whatnot. But
