‎02-16-2010 08:41 AM
‎02-16-2010 12:34 PM
Facilities wrote:
Memory issue:
The current release of lansweeper does get the correct memory information from the server so the WMI call does work. Do you still want me to test the WMI call?
‎02-16-2010 10:46 AM
Alter view web40OScode
AS
SELECT dbo.tblComputers.Computername, dbo.tblOperatingsystem.ServicePackMajorVersion AS SP, CASE WHEN isnull(dbo.tbloperatingsystem.version, '')
= '' THEN '0' ELSE dbo.tblOperatingsystem.Version + ISNULL(dbo.tblOperatingsystem.OtherTypeDescription, '') + CASE WHEN isnull(domainrole, 0)
> 1 THEN 'S' ELSE '' END END AS OScode
FROM dbo.tblComputersystem RIGHT OUTER JOIN
dbo.tblComputers ON dbo.tblComputersystem.Computername = dbo.tblComputers.Computername LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
‎02-16-2010 10:14 AM
select * from win32_physicalmemory
select * from win32_physicalmemoryarray
‎02-16-2010 09:21 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now