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]

Database is 146 MB, a little too big to email.

[Hemoco]

Would it be possible to download a backup of your database (please mail us at lansweeper@hemoco.com)

[logan5]

ACHILLES 1 NULL
AMADEUS 1 NULL
APOLLO 1 NULL
ARES 1 NULL
ATHENA 1 NULL
BLACKBERRY 1 NULL
CERBERUS 1 NULL
CERNER1 1 NULL
CERNER43 1 NULL
CERNERIMAGING 1 NULL
CERNERTEST 1 NULL
CLADEUS 1 NULL
D2B2DDC1 1 NULL
DIONYSUS 1 NULL
EMCRM1 1 NULL
EXCHANGE07 1 NULL
GHOST 1 NULL
GPSERVER 1 NULL
GPSERVER2 1 NULL
HELPDESK 1 NULL
HERA 1 NULL
HERMES 1 NULL
HORIZONAPPZEUS 1 NULL
HORIZONSDB 1 NULL
HPCCR-16D1AB7E0 1 NULL
HPCCR-55C25C626 1 NULL
IOMEGA 1 NULL
IOMEGA2 1 NULL
LBARLOWE 1 NULL
LIFEBOOK3 1 NULL
MISYS 1 NULL
NACHO 1 NULL
NEWBOXONBILL2 1 NULL
NEWBOXONBILLS3 1 NULL
NEWBOXONBILLS4 1 NULL
NEWBOXONBILLS5 1 NULL
NEWBOXONBILLSDE 1 NULL
OLYMPUS 1 NULL
PC-1000 1 NULL
PC-1007 1 NULL
PC-1008 1 NULL
PC-1009 1 NULL
PC-1011 1 NULL
PC-1014 1 NULL
PC-1044 1 NULL
PC-1046 1 NULL
PC-1051 1 NULL
PC-1055 1 NULL
PC-1056 1 NULL
PC-1057 1 NULL
PC-1061 1 NULL
PC-1064 1 NULL
PC-1065 1 NULL
PC-1066 1 NULL
PC-1070 1 NULL
PC-1078 1 NULL
PC-1079 1 NULL
PC-1081 1 NULL
PC-1082 1 NULL
PC-1087 1 NULL
PC-1088 1 NULL
PC-1089 1 NULL
PC-1096 1 NULL
PC-1097 1 NULL
PC-1098 1 NULL
PC-1102 1 NULL
PC-1103 1 NULL
PC-1104 1 NULL
PC-1107 1 NULL
PC-1110 1 NULL
PC-1114 1 NULL
PC-1123 1 NULL
PC-1125 1 NULL
PC-1130 1 NULL
PC-1131 1 NULL
PC-1132 1 NULL
PC-1133 1 NULL
PC-1134 1 NULL
PC-1137 1 NULL
PC-1140 1 NULL
PC-1143 1 NULL
PC-1151 1 NULL
PC-1152 1 NULL
PC-1157 2 Non-active
PC-1158 1 NULL
PC-1160 1 NULL
PC-1162 1 NULL
PC-1166 1 NULL
PC-1167 1 NULL
PC-1168 1 NULL
PC-1171 1 NULL
PC-1172 1 NULL
PC-1176 1 NULL
PC-1179 1 NULL
PC-1181 1 NULL
PC-1182 1 NULL
PC-1184 1 NULL
PC-1186 1 NULL
PC-1188 1 NULL
PC-1192 1 NULL
PC-1193 1 NULL
PC-1194 1 NULL
PC-1195 1 NULL
PC-1196 1 NULL
PC-1197 1 NULL
PC-1198 1 NULL
PC-1200 1 NULL
PC-1201 1 NULL
PC-1202 1 NULL
PC-1203 1 NULL
PC-1205 1 NULL
PC-1206 1 NULL
PC-1207 1 NULL
PC-1208 1 NULL
PC-1210 1 NULL
PC-1211 1 NULL
PC-1212 1 NULL
PC-1213 1 NULL
PC-1215 1 NULL
PC-1216 1 NULL
PC-1217 1 NULL
PC-1219 1 NULL
PC-1224 1 NULL
PC-1227 1 NULL
PC-1228 1 NULL
PC-1229 1 NULL
PC-1231 1 NULL
PC-1232 1 NULL
PC-1233 1 NULL
PC-1234 1 NULL
PC-1236 1 NULL
PC-1240 1 NULL
PC-1241 1 NULL
PC-1242 1 NULL
PC-1244 1 NULL
PC-1245 1 NULL
PC-1248 1 NULL
PC-1249 1 NULL
PC-1250 1 NULL
PC-1251 1 NULL
PC-1255 1 NULL
PC-1256 1 NULL
PC-1257 1 NULL
PC-1258 1 NULL
PC-1259 1 NULL
PC-1260 1 NULL
PC-1263 1 NULL
PC-1267 1 NULL
PC-1269 1 NULL
PC-1269-XP-VM 1 NULL
PC-1271 1 NULL
PC-1272 1 NULL
PC-1273 1 NULL
PC-1274 1 NULL
PC-1284 1 NULL
PC-1285 1 NULL
PC-1287 1 NULL
PC-1289 1 NULL
PC-1291 1 NULL
PC-1295 1 NULL
PC-1297 1 NULL
PC-1299 1 NULL
PC-1300 1 NULL
PC-1301 1 NULL
PC-1302 1 NULL
PC-1303 1 NULL
PC-1304 1 NULL
PC-1305 1 NULL
PC-1306 1 NULL
PC-1307 1 NULL
PC-1308 1 NULL
PC-1309 1 NULL
PC-1310 1 NULL
PC-1312 1 NULL
PC-1314 1 NULL
PC-1317 1 NULL
PC-1318 1 NULL
PC-1319 1 NULL
PC-1320 1 NULL
PC-1325 1 NULL
PC-1326 1 NULL
PC-1328 1 NULL
PC-1329 1 NULL
PC-1330 1 NULL
PC-1332 1 NULL
PC-1333 1 NULL
PC-1334 1 NULL
PC-1338 1 NULL
PC-1339 1 NULL
PC-1340 1 NULL
PC-1345 1 NULL
PC-1346 1 NULL
PC-1349 1 NULL
PC-1351 1 NULL
PC-1352 1 NULL
PC-1353 1 NULL
PC-1354 1 NULL
PC-1356 1 NULL
PC-1358 1 NULL
PC-1360 1 NULL
PC-1361 1 NULL
PC-1362 1 NULL
PC-1363 1 NULL
PC-1365 1 NULL
PC-1367 1 NULL
PC-1368 1 NULL
PC-1371 1 NULL
PC-1372 1 NULL
PC-1373 1 NULL
PC-1374 1 NULL
PC-1375 1 NULL
PC-1376 1 NULL
PC-1377 1 NULL
PC-1378 1 Active
PC-1380 1 NULL
PC-1382 1 NULL
PC-1383 1 NULL
PC-1384 1 NULL
PC-1386 1 NULL
PC-1387 1 NULL
PC-1388 1 NULL
PC-1391 1 NULL
PC-1392 1 NULL
PC-1393 1 NULL
PC-1394 1 NULL
PC-1396 1 NULL
PC-1397 1 NULL
PC-1398 1 NULL
PC-1399 1 NULL
PC-1401 1 NULL
PC-1402 1 NULL
PC-1403 1 NULL
PC-1404 1 NULL
PC-1405 1 NULL
PC-1406 1 NULL
PC-1408 1 NULL
PC-1410 1 NULL
PC-1413 1 NULL
PC-1414 1 NULL
PC-1415 1 NULL
PC-1416 1 NULL
PC-1417 1 NULL
PC-1418 1 NULL
PC-1419 1 NULL
PC-1420 1 NULL
PC-1421 1 NULL
PC-1423 1 NULL
PC-1426 1 NULL
PC-1427 1 NULL
PC-1428 1 NULL
PC-1429 1 NULL
PC-1430 1 NULL
PC-1431 1 NULL
PC-1432 1 NULL
PC-1433 1 NULL
PC-1434 1 NULL
PC-1435 1 NULL
PC-1436 1 NULL
PC-1438 1 NULL
PC-1439 1 NULL
PC-1440 1 NULL
PC-1441 1 NULL
PC-1442 1 NULL
PC-1443 1 NULL
PC-1444 1 NULL
PC-1445 1 NULL
PC-1446 1 NULL
PC-1447 1 NULL
PC-1448 1 NULL
PC-1449 1 NULL
PC-1451 1 NULL
PC-1452 1 NULL
PC-1453 1 NULL
PC-1454 1 NULL
PC-1455 1 NULL
PC-1456 1 NULL
PC-1457 1 NULL
PC-1458 1 NULL
PC-1459 1 NULL
PC-1460 1 NULL
PC-1461 1 NULL
PC-1462 1 NULL
PC-1463 1 NULL
PC-1464 1 NULL
PC-1465 1 NULL
PC-1466 1 NULL
PC-1467 1 NULL
PC-1468 1 NULL
PC-1469 1 NULL
PC-1470 1 NULL
PC-1471 1 NULL
PC-1472 1 NULL
PC-1473 1 NULL
PC-1474 1 NULL
PC-1475 1 NULL
PC-1476 1 NULL
PC-1477 1 NULL
PC-1478 1 NULL
PC-1480 1 NULL
PC-1481 1 NULL
PC-1482 1 NULL
PC-1483 1 NULL
PC-1484 1 NULL
PC-1485 1 NULL
PC-1486 1 NULL
PC-1487 1 NULL
PC-1488 1 NULL
PC-1489 1 NULL
PC-1490 1 NULL
PC-1491 1 NULL
PC-1492 1 NULL
PC-1493 1 NULL
PC-1494 1 NULL
PC-1495 1 NULL
PC-1496 1 NULL
PC-1497 1 NULL
PC-1498 1 NULL
PC-1499 1 NULL
PC-1500 1 NULL
PC-1501 1 NULL
PC-1502 1 NULL
PC-1504 1 NULL
PC-1505 1 NULL
PC-1506 1 NULL
PC-1507 1 NULL
PC-1508 1 NULL
PC-1509 1 NULL
PC-1510 1 NULL
PC-1511 1 NULL
PC-1512 1 NULL
PC-1513 1 NULL
PC-1514 1 NULL
PC-1515 1 NULL
PC-1516 1 NULL
PC-1517 1 NULL
PC-1518 1 NULL
PC-1519 1 NULL
PC-1520 1 NULL
PC-1521 1 NULL
PC-1522 1 NULL
PC-1523 1 NULL
PC-1525 1 NULL
PC-1526 1 NULL
PC-1527 1 NULL
PC-1528 1 NULL
PC-1529 1 NULL
PC-1530 1 NULL
PC-1531 1 NULL
PC-1532 1 NULL
PC-1533 1 NULL
PC-1534 1 NULL
PC-1535 1 NULL
PC-1536 1 NULL
PC-1539 1 NULL
PC-1540 1 NULL
PC-1541 1 NULL
PC-1542 1 NULL
PC-1543 1 NULL
PC-1545 1 NULL
PC-1546 1 NULL
PC-1547 1 NULL
PC-1548 1 NULL
PC-1550 1 NULL
PC-1553 1 NULL
PC-1554 1 NULL
PC-1555 1 NULL
PC-1556 1 NULL
PC-1557 1 NULL
PC-1559 1 NULL
PC-1560 1 NULL
PC-1561 1 NULL
PC-1562 1 NULL
PC-848 1 NULL
PC-899 1 NULL
PC-901 1 NULL
PC-922 1 NULL
PC-933 1 NULL
PC-934 1 NULL
PC-935 1 NULL
PC-955 1 NULL
PC-956 1 NULL
PC-974 1 NULL
PC-985 2 Non-active
PEGASUS 1 NULL
PEGASUS1 1 NULL
PEGASUS2 1 NULL
PEGASUS3 1 NULL
POSEIDON 1 NULL
PSERVER 1 NULL
RAISERS_EDGE 1 NULL
SKYWALKER 1 NULL
SMSERVER 1 NULL
STORAGE1 1 NULL
STORAGE2 1 NULL
TRITONIS 1 NULL
UNITY 1 NULL
URANUS 1 NULL
ZORO 1 NULL

[Hemoco]

That was ok, please run "select * from web30repallcompstates"

[logan5]

Perhaps I am running it wrong? I ran it from sql query analyzer, "Exec [procedure] [domain]" ?

exec Web30computers domain

[Hemoco]

Strange problem, so you have other things that are not working that might give a clue.

Your stored procedure looks ok but it is giving wrong results.

Could you post the output of "web30repallcompstates"

[logan5]

CREATE 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

[Hemoco]

Yes

[logan5]

I'm running SQL 2000, in Enterprise Mgr?

[Hemoco]

In the SQL management studio, double click on the stored procedure.