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. 028
Cyber Security

WME Security Briefing 27 September 2024

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

Click Here to Read Full Article »
Be assured of everything

Get WME Services

Stay ahead of the competition with our Professional IT offerings.

=