Incorrect hostname Syntax:
SELECT DISTINCT
SYS.Netbios_Name0 "Hostname", SYS.User_Name0,
OPSYS.Caption0 as C054, OPSYS.Version0,
MEM.TotalPhysicalMemory0 "RAM",
CSYS.Manufacturer0, CSYS.Model0,
Processor.Manufacturer0, Processor.Name0, Processor.MaxClockSpeed0,
DSYS.Size0 "HD Size (MB)"
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 Not Like 'VARIABLE%'ORDER BY SYS.Netbios_Name0
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment