Weekly Tip 36

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%’

Share:

Facebook
Twitter
LinkedIn
Picture of Matt Tinney

Matt Tinney

Professional IT executive & business leader having decades of experience with Microsoft technologies delivering modern-day cloud & security solutions.

Contact Us

=
On Key

More Posts

WME Cybersecurity Briefings No. 034
Cyber Security

WME Security Briefing 18 November 2024

New LightSpy Spyware Variant Poses Increased Threat to iPhone Users Overview Recent analysis reveals an enhanced version of the iOS spyware, LightSpy. It targets iPhones with advanced surveillance features and destructive capabilities. Basically, detected for the first time

Click Here to Read Full Article »
Be assured of everything

Get WME Services

Stay ahead of the competition with our Professional IT offerings.

=