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%’
Microsoft is pushing the boundaries of productivity with the latest updates to Microsoft 365 Copilot. Whether it is Copilot Pages, which promotes AI-based collaboration, or the major enhancements coming in Teams, Excel, and other Microsoft services,
Remote Control Vulnerabilities in Kia Vehicles Overview Famous cybersecurity researchers Neiko Rivera, Sam Curry, and others have identified a series of vulnerabilities in Kia vehicles. The flaws could be exploited to control crucial functions of their
Cloud computing is changing fast, and Microsoft Azure leads the way. In 2025, key trends will shape how businesses use Azure for growth. IT pros, business leaders, and developers must know these trends. AI and machine
DragonRank SEO Manipulation Campaign Targeting IIS Servers Across Asia and Europe Overview A cyber espionage campaign is targeting IIS servers in several countries across Asia and Europe. The DragonRank campaign emanates from a simplified Chinese-speaking actor and specializes
Cybersecurity threats are growing complex. Defense industry faces new cybersecurity challenges every day. Identity and Access Management (IAM) is crucial in this fight. IAM tools are the first defense against unauthorized access and cyber threats, and
Fortinet Data Breach via Third-Party Cloud: A Security Alert Overview Fortinet confirms a huge data breach impacting a number of its customers. The incident involves unauthorized access to files stored on their cloud drive. The breach came
Copyright © 2012-2024 Windows Management Experts Inc.
Stay ahead of the competition with our Professional IT offerings.
