Your company's ad could live here and reach over 50,000 people a month!

Share This Post

List of Desktops

This query lists all the Desktops by hardware manufacturer, product and model.

Desktop definition: A computer designed to fit comfortably on top of a desk, typically with the monitor sitting on top of the computer.

* Requires BDNA Normalize CM

Category2

Manufacturer

Model

Desktops

Dell

Dimension

Desktops

Dell

OptiPlex

Desktops

Hewlett-Packard Company

Compaq Business Desktop PC

Desktops

Hewlett-Packard Company

Compaq Deskpro Desktop PC

Desktops

Hewlett-Packard Company

Compaq Desktop

Desktops

Hewlett-Packard Company

Compaq Evo D510 series

Desktops

Hewlett-Packard Company

Compaq Evo Desktop

Desktops

Hewlett-Packard Company

Elite Desktop PC

Desktops

Lenovo Group

ThinkCentre M51

Desktops

Lenovo Group

ThinkCentre M52

Desktops

Lenovo Group

ThinkCentre M55

Desktops

Lenovo Group

ThinkCentre M57

Desktops

Lenovo Group

ThinkCentre M57p

Desktops

Lenovo Group

ThinkCentre M58p

*The list above is not exhaustive, and only provided a sample of the data that are available within CM.

Using the new CM class BDNA_HARDWARE_DATA, all your hardware information are now available into a single table. You can query this table using WQL or SQL.

WQL

select System.Name, HARDWARE.Category1, HARDWARE.Category2, HARDWARE.Manufacturer, HARDWARE.Product, HARDWARE.Model from SMS_R_System inner join SMS_G_System_BDNA_BDNAHARDWAREDATA_1_1 as HARDWARE on HARDWARE.SMSUniqueIdentifier = SMS_R_System.SMSUniqueIdentifier inner join SMS_R_System as System on System.SMSUniqueIdentifier = HARDWARE.SMSUniqueIdentifier where HARDWARE.Category2 = "Desktops"

SQL

SELECT v_R_System.Name0 as Name, Hardware.Category10 as Category1, Hardware.Category20 as Category2, Hardware.Manufacturer0 as Manufacturer, Hardware.Product0 as Product, Hardware.Model0 as Model

FROM v_R_System

INNER JOIN v_GS_BDNA_Hardware_Data0 Hardware ON Hardware.SMSUniqueIdentifier0=v_R_System.SMS_Unique_Identifier0

WHERE Hardware.Category20 = Desktops’

Share This Post

A community professional, keynoter, and evangelist who has driven social media and marketing strategies, editorial successes, delivered customer successes and built some of the largest and longest-running online communities. Rod has created, managed and grown small, medium, and mega-sized conferences; run entire editorial teams to deliver record traffic and market leadership; as product manager, directed the success of hundreds of product releases; supported sales and marketing to ensure customer success; developed, run and sold businesses; written thousands of technical articles, white papers, case studies, and technical documentation; hosted and delivered hundreds of attendance shattering webinars and virtual tradeshows; and delivered keynote speeches and sessions at a wide variety of events including conferences, webinars, events, and user groups.

Leave a Reply