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

Share This Post

List of Servers

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

* Requires BDNA Normalize CM

Category2

Manufacturer

Model

Servers

Dell

PowerEdge

Servers

Hewlett-Packard Company

ProLiant BL460c G6 Server Blade

Servers

Hewlett-Packard Company

ProLiant DL360 G2 Server

Servers

Hewlett-Packard Company

ProLiant DL360 G3 Server

Servers

Hewlett-Packard Company

ProLiant DL360 G5 Server

Servers

Hewlett-Packard Company

ProLiant DL360 G6 Server

Servers

Hewlett-Packard Company

ProLiant DL380 G2 Server

Servers

Hewlett-Packard Company

ProLiant DL380 G3 Server

Servers

Hewlett-Packard Company

ProLiant DL380 G4 Server

Servers

Hewlett-Packard Company

ProLiant DL380 G5 Server

Servers

Hewlett-Packard Company

ProLiant DL380 G6 Server

Servers

Hewlett-Packard Company

ProLiant DL580 G2 Server

Servers

Hewlett-Packard Company

ProLiant DL580 G3 Server

Servers

Hewlett-Packard Company

ProLiant DL580 G4 Server

Servers

Hewlett-Packard Company

ProLiant DL580 G5 Server

Servers

Hewlett-Packard Company

ProLiant DL585 G1 Server

*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 = "Servers"

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 = ‘Servers’

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