1. The sync time of the connector reduce quite a bit. We saw a 65% increase in performance in SCCM connector and 55% increase in performance for AD connector.
2. The size of the ECL table and the history tables do not increase e.g. in our test scenarios AD connector brought in 2.2 million rows and SCCM connector brought in 11.6 million rows in ECL and history table alone. With the feature enabled no rows are added into these tables.
|
Rows added to ECL & history without feature |
Rows added to ECL & history with feature enabled |
Sync time without feature |
Sync time with feature enabled |
Improvement % |
AD connector |
2.2 million |
Nil |
4 hours 25 mins |
1 hour 55 mins |
~ 55% |
SCCM connector |
11.6 million |
Nil |
30 hours |
10 hours |
~ 65% |
1. DCM incidents creation would not work when this feature is enabled
2. Some customers may have defined workflows that keep an eye on the data being brought by the connectors. If you have defined workflows which need to be triggered when the data is brought in by connectors then enabling this feature will not trigger those workflows. Since the workflows look into the ECL table for entries and this feature doesn’t log entries in ECL table, these workflows would not work. It is advised that in such cases this feature should not be switched on.
3. Since this feature does not write entries in the ECL and history table, the history of the creation and/or the changes to the data items (brought in by the connectors) in SM, are not recorded. That is to say, you would no longer be able to tell when a user or a computer object was imported into SM database and/or when changes to these objects were imported into SM database.
In some cases the changes to data like users and computers need be recorded in database for auditing purposes. In these cases an alternative is to get the history of changes from the source i.e. get the history of changes made to the user from AD or get the history of changes made to the computer from SCCM.
A few points to note here
a. Switching on this feature does not turn off logging history data about work items like incident, change requests etc. They will continue to work as is.
b. Any explicit change made by the user to the data brought in by the connectors like a user or a computer, would still be recorded in the ECL and history tables despite switching on this feature.
c. The history of using the data brought in by connector is also recorded despite switching on the feature e.g. if a computer (brought in by SCCM connector) is added to an incident or a user is assigned as affected user, these changes are still recorded in the system.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.