9.2.3.9 (5/18/10)

1. Fixed: Bug in Discovery Connections when using SQL Server for WHD database that can cause a growing number of "[Unspecified Manufacturer]" and "[Unspecified Model]" entries in the database.
   
   NOTE: If you have encountered this issue, you can execute the following SQL to clean up the extra Manufacturer and Model records. (If your database is not named whd, replace whd.dbo with your_database_name.dbo.)
   
   update whd.dbo.ASSET set MODEL_ID = (select MAX(MODEL_ID) from whd.dbo.MODEL where MODEL_NAME = '[Unspecified Model]') where MODEL_ID in (select MODEL_ID from whd.dbo.MODEL where MODEL_NAME = '[Unspecified Model]'); 
   
   delete from whd.dbo.MODEL where MODEL_ID <> (select MAX(MODEL_ID) from whd.dbo.MODEL) and MODEL_NAME = '[Unspecified Model]';
   
   update whd.dbo.MODEL set MANUFACTURER_ID = (select MAX(MANUFACTURER_ID) from whd.dbo.MANUFACTURER where NAME='[Unspecified Manufacturer]') where MANUFACTURER_ID in (select MANUFACTURER_ID from whd.dbo.MANUFACTURER where NAME = '[Unspecified Manufacturer]');
   
   delete from whd.dbo.MANUFACTURER where MANUFACTURER_ID <> (select MAX(MANUFACTURER_ID) from whd.dbo.MANUFACTURER) and NAME = '[Unspecified Manufacturer]';
   
   
2. Fixed: Escalation e-mail to level techs now respects Location/Department group filtering.
3. Fixed: Various cosmetic fixes for IE7 compatibility.