Page Comparison

...

1. Stop CyReport Engine service.

2. Backup Database ‘CyTrack’

3. run, against the database:

   • select
     eas.id,
     eas.id_ext,
     eas.extensionnumber,
     e.*

     from
     tblDirExtAcdStationState as eas
     inner join tblDirExt as e on eas.id_ext = e.id

     where extensionnumber in
     (select extensionnumber from tblDirExtAcdStationState
     group by extensionnumber
     having count(*) > 1)
     and eas.extensionnumber != e.num

4. Run, against the database:

   • delete from tblDirExtAcdStationState where id in
     (select
     eas.id
     from
     tblDirExtAcdStationState as eas
     inner join tblDirExt as e on eas.id_ext = e.id

     where extensionnumber in
     (select extensionnumber from tblDirExtAcdStationState
     group by extensionnumber
     having count(*) > 1)
     and eas.extensionnumber != e.num)

5. Start CyReport Engine service.

6. Check that the ACD Agents combo to ensure extensions are not duplicated any more.