Computers with Scan problems no longer appear red

[logan5]

cnok.gif icon no longer being used after upgrade to 3.5.1 from 3.5

[logan5]

Ok Ran the script and it looks fixed now! Awesome Thank you! 🙂 Do you know how we ended up with blank spaces in that field? Is it something we did?

[Hemoco]

logan5 wrote:
Ok Ran the script and it looks fixed now! Awesome Thank you! 🙂 Do you know how we ended up with blank spaces in that field? Is it something we did?

Most likely you added it by accident after loading the script

[Hemoco]

Found the problem, running this script should fix it.
In the second 'NOT SCANNED' there were 2 spaces in your version of the database (I checked the installer script and there it's ok)

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.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)

GO

[logan5]

Ok uploaded to Rapidshare, (got the email working but it was rejected in transport as too large.) Sent you the link this a.m.

[Hemoco]

Did you send me the link?
Can't seem to find it.

[logan5]

ok compression worked ok zipping to 7zip file. from 147 to 11mbs so sending via email should work ok. Let me know if you can open Ok. (If you don't have 7-zip you can download from: http://www.7-zip.org/, a free open source zipping utility.)

[Hemoco]

No, If you password protect it you can use Rapidshare

[logan5]

do you have an ftp site we can upload to?

[Hemoco]

Could you take a backup/zip it and upload it somewhere?