6.x: Active Directory component NTDS fails to register on Windows 2008 server

If you to monitor Active Directory on a Windows 2008 server the NTDS component fails to register. This happens because some of the statistics that existed in Windows 2003 do not exist in Windows 2008.

1. Access your websql by going to http://localhost:7230/websql (Database name is FZEDB1 the Username and Password are the ones used for your main account)
2. Once you are in the following will have to be changed

   DRA_INBD_OBJ_APPL_RATE
   DRA_INBD_OBJ_FILTER_RATE
   DRA_INBD_PROP_APPL_RATE
   DRA_INBD_PROP_FILTER_RATE
   DS_DIR_WRTS_RATE
   DS_DIR_SRCH_RATE
   DS_DIR_READS_RATE
   DS_NAME_CACHE_HIT_RATE
   KDC_AS_REQS
   KDC_TGS_REQS
   KERBEROS_AUTH_RATE
   NTLM_AUTH_RATE

   To alter the size of the column in D_ACTIVEDIRECTORYNTDS, execute the following query for each of the 12 changed fields (substituting the field name):

   ALTER TABLE D_ACTIVEDIRECTORYNTDS MODIFY DRA_INBD_OBJ_APPL_RATE FIXED(12,2)

3. To change the value in the COLUMNS table, execute the following query for each of the 12 changed fields (substituting the field name):

   UPDATE COLUMNS SET COLUMNSIZE=12 WHERE NAME='DRA_INBD_OBJ_APPL_RATE'

4. Execute the following commands one at a time from the same WebSQL tool:

   UPDATE COLUMNS SET STATISTICSTYPE='Level' WHERE NAME='DS_NAME_CACHE_HIT_RATE'

   UPDATE COLUMNS SET STATISTICSTYPE='Level' WHERE NAME='KDC_AS_REQS'

   UPDATE COLUMNS SET STATISTICSTYPE='Level' WHERE NAME='KDC_TGS_REQ'

   UPDATE COLUMNS SET STATISTICSTYPE='Level' WHERE NAME='KERBEROS_AUTH_RATE'

   UPDATE COLUMNS SET STATISTICSTYPE='Level' WHERE NAME='NTLM_AUTH_RATE'

5. Download file by right-clicking on the link ActiveDirectory_NTDS.xml and selecting Save Target As, and in \Longitude\applications\ActiveDirectory\collectors rename the old file to a .orig extension so we have a backup.
6. Restart the following services:
   Heroix Longitude Consolidator
   Heroix Longitude Statistics Server
   Heroix Longitude Web UI
7. Log back into the UI, click on the Active Directory gear and click test next to the NTDS component