I am trying to generate a report to get server's manufacturer and operating system information. so fas I have got below query using which I am getting hostname and manufacturer information

select Name0,Manufacturer0 from v_GS_COMPUTER_SYSTEM

we can get the OS information from V_GS_Operatingsystem but I am not sure how to join the information from these two classes. could someone please give an example on how to get information from multiple classes like  v_GS_COMPUTER_SYSTEM and V_GS_Operatingsystem

Untested, off the top of my head:

Select sys.name0,

cs.manufacturer0,

os.caption0

from v_R_System sys

INNER JOIN v_GS_COMPUTER_SYSTEM cs on sys.resourceID = cs.resourceID

INNER JOIN V_GS_Operating_system os on sys.resourceID = os.resourceID

BTW... Take a look at normalize from BDNA. Using it you can do this with zero joins. :-)

Sorry, you said you just want servers:

Select sys.name0,

cs.manufacturer0,

os.caption0

from v_R_System sys

INNER JOIN v_GS_COMPUTER_SYSTEM cs on sys.resourceID = cs.resourceID

INNER JOIN V_GS_Operating_system os on sys.resourceID = os.resourceID

Where os.caption0 like '%server%'