→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎11-17-2011 08:12 PM
Solved! Go to Solution.
‎11-18-2011 11:18 AM
Select Distinct Top 1000000 tblComputers.Username As [User],
tblComputers.Computer As [Asset Tag],
tblComputerSystemProduct.IdentifyingNumber As [Service Tag],
tblComputersystem.Model As Model, tblPROCESSOR.Name As CPU,
tblPROCESSOR.MaxClockSpeed As [CPU Speed], tblPROCESSOR.ExtClock As FSB,
web40CorrectMemory.Memory As Memory, tblPhysicalMemory.Speed As
[Memory
Speed], tblDiskdrives.Caption, tblDiskdrives.Size As [HD Size],
tblDiskdrives.Freespace As [HD Free], tblOperatingsystem.Caption As OS,
tblOperatingsystem.CSDVersion As SP
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Inner Join
tblPhysicalMemory On tblComputers.Computername =
tblPhysicalMemory.Computername Inner Join
tblPROCESSOR On tblComputers.Computername = tblPROCESSOR.Computername
Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblPhysicalMemoryArray On tblComputers.Computername =
tblPhysicalMemoryArray.Computername Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername
‎11-18-2011 11:18 AM
Select Distinct Top 1000000 tblComputers.Username As [User],
tblComputers.Computer As [Asset Tag],
tblComputerSystemProduct.IdentifyingNumber As [Service Tag],
tblComputersystem.Model As Model, tblPROCESSOR.Name As CPU,
tblPROCESSOR.MaxClockSpeed As [CPU Speed], tblPROCESSOR.ExtClock As FSB,
web40CorrectMemory.Memory As Memory, tblPhysicalMemory.Speed As
[Memory
Speed], tblDiskdrives.Caption, tblDiskdrives.Size As [HD Size],
tblDiskdrives.Freespace As [HD Free], tblOperatingsystem.Caption As OS,
tblOperatingsystem.CSDVersion As SP
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Inner Join
tblPhysicalMemory On tblComputers.Computername =
tblPhysicalMemory.Computername Inner Join
tblPROCESSOR On tblComputers.Computername = tblPROCESSOR.Computername
Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblPhysicalMemoryArray On tblComputers.Computername =
tblPhysicalMemoryArray.Computername Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now