Run this sql code to change the stored procedure
ALTER PROCEDURE dbo.Web30computers
(@domain varchar(80))
AS SELECT dbo.tblComputers.Computername, ISNULL(dbo.tblOperatingsystem.Description, '') AS thedescription, dbo.tblOperatingsystem.Caption AS OS,
CASE ISNULL(dbo.tblOperatingsystem.Description, 'NOT SCANNED') WHEN 'NOT SCANNED' THEN 1 ELSE 0 END AS Notscanned,
CAST(dbo.web30ProcessorCapacity.NrOfProcessors AS varchar) + ' * ' + CAST(dbo.web30ProcessorCapacity.MaxClockSpeed AS varchar)
+ ' Mhz' AS Processor, CAST(CAST(CAST(dbo.tblComputersystem.TotalPhysicalMemory AS bigint) / 1024 / 1024 AS NUMERIC) AS varchar)
+ ' MB' AS Memory, dbo.tblComputers.Lastseen, dbo.tblComputers.Username, dbo.tblComputers.LastknownIP,
dbo.web30repallcompstates.Thestate
FROM dbo.tblComputers INNER JOIN
dbo.web30repallcompstates ON dbo.tblComputers.Computername = dbo.web30repallcompstates.Computername LEFT OUTER JOIN
dbo.web30ProcessorCapacity ON dbo.tblComputers.Computername = dbo.web30ProcessorCapacity.Computername LEFT OUTER JOIN
dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE (dbo.tblComputers.Domain LIKE @domain)
ORDER BY dbo.tblComputers.Computername