SQL query for SCCM 2007 R2 to find all Dell desktops and laptops

My colleague wrote a SQL query for SCCM 2007 R2 that finds all the Dell desktops and laptops in our environment.


select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System   INNER JOIN SMS_G_System_COMPUTER_SYSTEM   ON SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId  WHERE SMS_R_System.NetbiosName NOT LIKE "SR%"   AND SMS_R_System.Active = 1  AND SMS_G_System_COMPUTER_SYSTEM.Manufacturer00 like "%Dell%"

Comments

Post a Comment

Popular posts from this blog

"The SNMP Service is ignoring the manager because its name could not be resolved." in Windows Server Event log.

 Interesting SNMP service problem on Windows. Since installing KB5051979 on Windows Server 2022 Standard, we can no longer use the SNMP service. The server no longer responds to SNMP requests from the management server <Server name>. Message in Event log on the problem server:- "The SNMP Service is ignoring the manager <Server name> because its name could not be resolved." The manager <Server name> CAN be pinged and resolved with DNS, also reverse lookup works. ............. Turns out, the GPO applying the policy for the names in the SNMP service had a fault. Re-created the GPO with the names again, and it worked.
Read more

Server Manager will not start, error .NET Framework: "This application requires one of the following versions of the .NET Framework:"

Server Manager will not start on Windows Server 2019 after installing ADConnect. Error ServerManager.exe: This application could not be started. .NET Framework: "This application requires one of the following versions of the .NET Framework:xxxxx Do you want to install .NET framework now?" Of course it's already installed automatically on the server, so if you try and install it again you can't, error "already installed". Try the .NET repair package, can't repair the install. Try dsim.exe to install the package, error "Microsoft .NET Framework is already part of this installation". .NET Runtime version : 4.0.30319.0 - This application could not be started.This application requires one of the following versions of the .NET Framework:  v4.0.30319 The answer is to re-create the registry entries deleted when you installed ADConnect:- [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\.NETFramework\v4.0.30319] "AspNetEnforceViewStateMac"=dw...
Read more