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.

10.0.4 (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:
   
   update ASSET set MODEL_ID = (select MAX(MODEL_ID) from MODEL where MODEL_NAME = '[Unspecified Model]') where MODEL_ID in (select MODEL_ID from MODEL where MODEL_NAME = '[Unspecified Model]');
   
   delete from model where MODEL_ID <> (select MAX(MODEL_ID) from MODEL) and MODEL_NAME = '[Unspecified Model]';
   
   update MODEL set MANUFACTURER_ID = (select MAX(MANUFACTURER_ID) from MANUFACTURER where NAME='[Unspecified Manufacturer]') where MANUFACTURER_ID in (select MANUFACTURER_ID from MANUFACTURER where NAME = '[Unspecified Manufacturer]');
   
   delete from MANUFACTURER where MANUFACTURER_ID <> (select MAX(MANUFACTURER_ID) from MANUFACTURER) and NAME = '[Unspecified Manufacturer]';
   
   
2. Added: JVM argument 'WHDLdapPasswordCacheDays=<num_days>' to specify the number of days to cache LDAP passwords. (For non-Windows platforms, add this to the JAVA_OPTIONS setting in whd.conf. For Windows platforms, add it to /bin/wrapper/conf/wrapper_template.conf. For Monitor deployments, add it to the Additional Java Arguments setting in the application configuration page.) 
3. Added: Ability client bulk-action option to assign a client to all or specific CAB locations.
4. Fixed: Various null-pointer exceptions and cosmetic improvements.
5. Fixed: Escalation e-mail to level techs now respects location/department filtering.