Comparing Snapshots - Using the Filter Options

Top  Previous  Next



Snapshot Compare allows the use of filters to make it easier for the user to find the exact differences they are searching for.


Filtering Options


There are two subsets of filtering options. Both can be used before and after a snapshot is compared.

First, you have the option of filtering items by status.


Checking and unchecking the above status checkboxes will cause the snapshot results to either show or hide items in the respective status. For instance, the snapshot image below shows that uspUpdateEmployeePersonalInfo has been modified in "aw snapshot 4".

After the "Modified" checkbox is unchecked uspUpdateEmployeePersonalInfo no longer appears in the results view.


Re-checking the "Modified" checkbox will make uspUpdateEmployeePersonalInfo reappear.


Filtering Statuses


There are five statuses that can be used to filter items in the snapshot compare.


 Modified    The object has been modified in on of the snapshots. The icon in the middle of the object name explains which object changed.  indicates the object changed in Snapshot 2.   indicates the object changed in Snapshot 1
 New  The object is new in Snapshot 2. Also indicated by the  icon
 Deleted  The object existed in Snapshot 1, but not Snapshot 2. Also indicated by the  icon
 Not Equal  The object changed from Snapshot 1 to Snapshot 2
 Equal  The objects are the same


Object Filters

Snapshot compare allows the use of object filters to filter out types of objects before and after a snapshot. To filter out an object simply uncheck the checkbox next to an object name. When an object is unchecked it will appear in bold red text to indicate the filter has been set.


Checking / unchecking an object with child objects will check/uncheck all of its child nodes as well. Below, "SQL Server" was unchecked and all of the child items were unchecked.


Pre-Comparison Object Filtering

Using an object filter before a snapshot is performed prevents the snapshot from comparing the filtered objects. If there are object types you do not want to be compared then uncheck the objects before peforming a snapshot compare. This is useful if the snapshot contains objects that will take a large amount of time to be compared when the comparison of those objects is unecessary.

Post-Comparison Object Filtering

Using an object filter after a snapshot is performed simply hides in the results view. For instance in the screenshots below the stored procedures are visible in the first screenshot but not visible after the stored procedure filter option is unchecked.

Stored Procedures are visible

Stored Procedures are hidden