ServiceNow contains an optional Data Archiving plug-in which allows moving data that is no longer necessary for immediate day-to-day access from primary tables into a set of archive tables. SnowMirror supported these archiving processes only by using a differential delete strategy or a differential synchronization. However, these features are not designed for huge tables that are usually being archived. The latest SnowMirror 3.2.3 introduces a new archiving support in the Audit delete strategy. (more…)
The new Consistency Check feature is very useful and very popular functionality in SnowMirror 3.2. It compares the number of records on the ServiceNow side with the number of rows in the mirror database after each replication run. If the numbers are different then the synchronization raises a warning which might trigger an email notification. There are several frequently asked questions and most of them about what to do when SnowMirror claims that there is an inconsistency between ServiceNow and the mirror database. This article covers most of the common cases. (more…)
The new release SnowMirror 3.2 brings several improvements and fixes as requested by our growing user base. The most important feature is the Consistency Check which compares the number of records on both sides and raises a warning if necessary. Another feature is the log retention job improving SnowMirror operations in long-term. The release contains many other small improvements and bug fixes as well. (more…)
In one of the previous posts, we described how to evaluate SnowMirror efficiently. In this article, we give you several best practices on how to install and configure production environment for SnowMirror. Following these best practices will save you some time in the future and help you to avoid issues in SnowMirror operations. (more…)
The official ServiceNow documentation says: Reference fields store a Sys ID, for each referenced record in the database, but the Sys ID is not shown. The reference field shows the display value. And then some other bits and pieces on how to configure display values and a very unconvincing algorithm how the display value fields are being evaluated. SnowMirror supports the ServiceNow display values out of the box so we had to gather all the information available and the rest comes from observations and reverse engineering. (more…)
ServiceNow announced general availability of their latest release Geneva today. SnowMirror is always keeping pace with ServiceNow releases and patches, so welcome SnowMirror 3.1, Geneva-compatible version which was released the same day as ServiceNow Geneva. This new version contains several new features and improvements. Mainly the Display Values support has been re-worked and there was a large optimization in the meta-data handling. (more…)
On the surface time zones seem to be fairly straightforward to deal with, but as we’ve learned, there are a few pitfalls to look out for. In this short post, I will describe how ServiceNow works with dates and time zones and how SnowMirror users can deal with time zones in the replicated data. A typical SnowMirror FAQ is: “I see different times in the mirror database than in our ServiceNow instance! What’s wrong?“. (more…)
SnowMirror team proudly announces the general availability of SnowMirror 3.0. We started developing SnowMirror 3 in cooperation with ServiceNow database experts several months ago. The cooperation resulted in a completely re-worked replication algorithm together with several new features improving SnowMirror performance and reliability. We do recommend upgrading the test SnowMirror installation first and then, if successful, upgrading the production mirrors afterward. By introducing indexes on the ServiceNow side the performance improves even more. (more…)
EDIT: There is a completely new ServiceNow backup feature in SnowMirror 3.3. Read more about backing up individual ServiceNow tables.
Backing up critical data has been a best practice for decades. Storage, backup solutions, and processes have evolved so much in the past years. There is even a Disaster Recovery Plan, a well-documented process to recover and protect a business IT infrastructure in the event of a disaster. Yet, every day, enterprises send critical data to cloud platforms such as ServiceNow without any plan for how they will backup the data and restore it.
If you are interested in backing up your ServiceNow data, SnowMirror provides automated, secure replication of selected tables into an on-premise database. Once the data is on-premise, leverage proven database and backup tools to work with the data and make SnowMirror part of your disaster recovery plan. (more…)
-
GuideVision, s.r.o.
V Parku 2326/18
148 00
Prague 4
Czech Republic
