Hardware Inventory

[miauninja]

Hi all. Its possible (and some one could write it here), to make a report with a real inventory?

Computername
Domain
Processor speed
Memory
Harddisk
VGA Model
IP
Username

I dont know if its possible.

[miauninja]

It show me "No data to Display"

[amerisbank]

Here is my computer inventory query... remove columns you don't want:

use lansweeperdb

select DISTINCT
co1.ComputerName, cs1.Domain, co1.Username, co1.UserDomain, co1.LastKnownIP, co1.LastSeen,
os1.Caption as 'OS Name', os1.CSDVersion as 'Service Pack', os1.Version as 'OS Version',
os1.LastBootUpTime, os1.WindowsDirectory,
csp1.IdentifyingNumber as 'Serial Number',
cs1.Manufacturer, cs1.Model, cs1.NumberofProcessors,
cpu.MaxClockSpeed as 'MaxCPUspeed', cpu.CurrentClockSpeed, cpu.Manufacturer as 'CPU Manufacturer',
cpu.Name as 'CPU Name', cpu.ExtClock,
os1.TotalVisibleMemorySize / 1024 as 'Total Memory (MB)',
os1.FreePhysicalMemory / 1024 as 'Free Memory (MB)',
dsk.Caption,
Round((cast(dsk.Size as real)/1024/1024/1024),3) as "Disk Size GB",
Round((cast(dsk.freespace as real)/1024/1024/1024),3) as "Disk Free GB",
dcc.caption as 'Video Controller', dcc.HorizontalResolution, dcc.VerticalResolution, dcc.BitsPerPixel,
os1.LocalDateTime, cs1.CurrentTimeZone, cs1.DaylightInEffect, cs1.EnableDaylightSavingsTime

from tblComputers co1

left outer join tblOperatingSystem os1 ON (co1.ComputerName = os1.ComputerName)
left outer join tblComputerSystemProduct csp1 ON (co1.ComputerName = csp1.ComputerName)
left outer join tblComputerSystem cs1 ON (co1.ComputerName = cs1.ComputerName)
left outer join tblDisplayControllerConfiguration dcc ON (co1.ComputerName = dcc.ComputerName)
left outer join tblProcessor cpu ON (co1.ComputerName = cpu.ComputerName)
left outer join tblDiskDrives dsk ON (co1.ComputerName = dsk.ComputerName)

where
(dsk.description like '%fixed disk%' and dsk.caption like 'c:')

order by co1.ComputerName




regards,
Claud