History:

Envision version 4.0 has introduced NIC SDEE Collection Service which collects IDS data formatted under the Security Device Event Exchange (SDEE) standard. NIC SDEE Collection Service converts these messages into syslog events and sends them to the Service.  This service has replaced the NIC IDS (XML) Service which was used with version prior to V4.0 to Collect IDS (XML) data from Cisco IDS devices and converts these messages into syslog events and sends them to the NIC Collector Service via shared memory. 

To make the change to the table, do the following:

1.      Stop ALL of the NIC Services except the NIC DB Server service

2.      Go to E:\%_envision%\database\cmd

3.      Double-click startISQL.cmd

4.      In the SQL Statements window, type:

select * from idsxmlServiceConfig

5.      Press [F5]

6.      Delete the entries in the Table depending on single or multi Site Environment and the version of envision.

?         Single site (ES) that has been upgraded to V 4.0 (Delete all the entries in the table).

 ?         If it's a mutli-site (LS) and there is a slave site still running version 3.7.0, do not delete the entries for that site, only delete the rows belonging to enVision version 4. 

 7.      To Delete the entries do the following: 

 ?  Right Click on the GUID of the entry 

 ?  Select Copy Cell 

 ?  In the SQL Statement Window type 

 ?  select * from idsxmlServiceConfig where guid = {Paste the GUID} 

 ?  Make Sure only the correct GUID is appearing 

 ?  In the SQL Statement Window type 

 ?  delete idsxmlServiceConfig where guid = {Paste the GUID} 

8. Press [F5]

9. Close the ISQL GUI.

10. Restart the All NIC Services.