‎04-20-2010 07:09 PM
SELECT tblcomputers.Computer, tblComputers.Username, c.Model, s.IdentifyingNumber,tblcomputers.lastknownip, cast(cast(c.TotalPhysicalMemory as decimal(18,2))/1048576 as int) as TotalPhysicalMemory, cast(datepart(dd,c.Lastchanged) as nvarchar(2)) +N'/'+ cast(datepart(mm,c.Lastchanged)as nvarchar(2)) +N'/'+ cast(datepart(yyyy,c.Lastchanged) as nvarchar(4)) as LastChanged
FROM tblComputersystem AS c INNER JOIN
tblComputerSystemProduct AS s ON c.Computername = s.Computername right JOIN
tblComputers ON c.Computername = tblComputers.Computername AND s.Computername = tblComputers.Computername
where tblcomputers.username like '%'
ORDER BY c.model
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now