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%’
In the past, legacy systems were the backbone of many industries. But today, they’ve become a major obstacle for businesses striving to achieve their full potential. Organizations of all kinds are now pushing forward, and they
1. Microsoft Teams: Flexible Membership for Frontline Teams Overview Microsoft Teams admin center is going to allow admins to deploy location-based frontline teams with flexible membership management. They will be able to manage team membership automatically
There could be several reasons that you would need to change the sourceAnchor in Entra Connect (formerly Azure AD Connect), such as an old installation that still uses objectGuid instead of ms-Ds-ConsistencyGuid, or maybe you need
Let’s talk about the most remarkable recent update for Windows 11. It introduces Hotpatch updates for Windows 11 Enterprise, version 24H2, and later. Why is it significant for businesses? Hotpatch allows security updates to be applied
Windows Autopatch Hotpatch: No Reboots for Security Updates Overview: A new feature in Windows Autopatch, Hotpatch, is now in public preview. This solution allows IT admins to apply security updates without rebooting devices. This update will
Ensure Compatibility and Security for iOS/iPadOS 18.2 Intune App SDK and Intune App Wrapping Tool for iOS now require to be updated to their latest version in preparation for the next release of iOS/iPadOS 18.2. This
Copyright © 2012-2024 Windows Management Experts Inc.
Stay ahead of the competition with our Professional IT offerings.
