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%’
1. Final Countdown for Windows 11 Version 22H2 Enterprise & Education Overview Windows 11, version 22H2 (Enterprise, Education, and IoT Enterprise editions) is going to reach end of the servicing on October 14, 2025. The October
The discourse surrounding regulatory compliance in human resource management has undergone a substantive paradigm shift from a temporary administrative burden to a strategically central imperative. In such circumstances, the procedural fidelity of HR operations has become
1. NightEagle APT Exploits Zero-Day in Microsoft Exchange to Target Chinese Defense and Tech Sectors Overview A new advanced persistent threat group, dubbed NightEagle (also called APT-Q-95), is being linked to a string of attacks. These
1. Microsoft Exchange Update: Rejecting Emails with Multiple “From” Addresses Without a Sender Header Update Overview Exchange Online has transitioned to rigorous enforcement of RFC 5322 compliance, particularly in relation to the structural semantics of message
The concept of employee experience comes with a wide set of multifaceted perceptions and interactions an individual may have during their tenure in an organization. A positive employee experience correlates strongly with higher retention rates. It
Migrating data from platforms like Google, Box, Dropbox, or network file systems to M365 can help to simplify your storage offerings. After data for which you have completed your migration, you should make sure that the
Stay ahead of the competition with our Professional IT offerings.
