Specific Machine Detail

Specific Machine Detail:

SELECT SYS.Netbios_Name0, SYS.User_Name0,
OPSYS.Caption0 as C054, OPSYS.Version0,
MEM.TotalPhysicalMemory0, IPAddr.IP_Addresses0, Processor.Manufacturer0,
CSYS.Model0, Processor.Name0, Processor.MaxClockSpeed0,
DSYS.Size0
FROM v_R_System SYSLEFT JOIN v_RA_System_IPAddresses IPAddr on SYS.ResourceID = IPAddr.ResourceIDLEFT JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM.ResourceIDLEFT JOIN v_GS_COMPUTER_SYSTEM CSYS on SYS.ResourceID = CSYS.ResourceIDLEFT JOIN v_GS_PROCESSOR Processor on Processor.ResourceID = SYS.ResourceIDLEFT JOIN v_GS_OPERATING_SYSTEM OPSYS on SYS.ResourceID = OPSYS.ResourceIDLEFT JOIN v_GS_DISK DSYS on SYS.ResourceID = DSYS.ResourceIDWHERE SYS.Netbios_Name0 = @variableORDER BY SYS.Netbios_Name0, SYS.Resource_Domain_OR_Workgr0