Tip of the day: Normalized list of Workstations

This query lists all the Workstations, their manufacturer, product and model.
Workstation definition: A type of computer used for engineering applications (CAD/CAM), desktop publishing, software development, and other types of applications that require a moderate amount of computing power and relatively high quality graphics capabilities

These queries use the BDNA Normalize CM supplied BDNA_HARDWARE_DATA.


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 = “Workstations”


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

Sample query result:

Category2 Manufacturer Model
Workstations Dell Precision
Workstations Dell Precision Mobile Workstation
Workstations Hewlett-Packard Company EliteBook Mobile Workstation
Workstations Hewlett-Packard Company Workstation
Workstations Hewlett-Packard Company Z400 Workstation
Workstations Hewlett-Packard Company Z800 Workstation
Workstations IBM IntelliStation Z Pro



Written by , Posted .

Leave a Comment

You must be logged in to post a comment.