Browse Prior Art Database

System and Method of Creating a Snapshot of Server Diagnostics during a Crash

IP.com Disclosure Number: IPCOM000131893D
Publication Date: 2005-Nov-21
Document File: 2 page(s) / 28K

Publishing Venue

The IP.com Prior Art Database

Abstract

Data on a server database may be changed whenever there is some interaction through either the mobile device manager on a computer, its services, or the mobile device. Analyzing server database changes is a tedious task, and often it is hard to find out what is going in there. It is not easy to understand, as there are multiple tables that dynamically change for different reasons. It is impossible to write such a spec document that could explain what will exactly occur in the server database Server Snap utility is an excel application that tracks and reports any change that occurs in the database between two different states. Server Snap can connect to SQL Server, then take the records from specified tables (or all of them) in the separate spreadsheets. At that moment, the user (tester or developer) can perform any actions on the server. As soon it is completed, Server Snap can collect the second data snap and compare with first one taken earlier. Server Snap reports any differences found in the captured records, for example: - changed values (changed) - all new records (new1, new2 ....) - all deleted records (deleted1, deleted2 ...) - reported changes (a hyperlink to the table field where it was found) Changes are coloured differently (easy to spot when there is lots of data). Tables data in any or all of the database tables after executing any test case. For example: between different builds, performing any action in device Manager, adding a new user, when using any of BRK tools that interacts with server database Steps to use this utility: 1. Set database connection information. 2. "Yes" in the first Active column determines the active server database. 3. For trusted connection, leave blank "User" and "Password" fields. 4. The Platform field is optional (related to the server). Once the server database connection values have been set, press "Connect DB" button. If the connection is successful, there will be a list of database tables. 1. Set "Yes" beside any of server tables you want to examine (all or just a few). 2. Press "Get Snap 1" to take first snap of selected tables. 3. Execute the test on the server. 4. Press "Get Snap 2" to take second snap of selected tables. 5. Press "Compare..." button to create the report. 6. Examine the differences (using the hyperlinks).

This text was extracted from a Microsoft Word document.
This is the abbreviated version, containing approximately 58% of the total text.

SERVER SNAPSHOT

System and Method of Creating a Snapshot of Server Diagnostics during a Crash

Disclosed Anonymously

Data on a server database may be changed whenever there is some interaction through either the mobile device manager on a computer, its services, or the mobile device. Analyzing server database changes is a tedious task, and often it is hard to find out what is going in there. It is not easy to understand, as there are multiple tables that dynamically change for different reasons. It is impossible to write such a spec document that could explain what will exactly occur in the server database

Server Snap utility is an excel application that tracks and reports any change that occurs in the database between two different states. Server Snap can connect to SQL Server, then take the records from specified tables (or all of them) in the separate spreadsheets. At that moment, the user (tester or developer) can perform any actions on the server. As soon it is completed, Server Snap can collect the second data snap and compare with first one taken earlier.

Server Snap reports any differences found in the captured records, for example:

    - changed values         (changed)

    - all new records         (new1, new2 ....)

    - all deleted records    (deleted1, deleted2 ...)

    - reported changes (a hyperlink to the table field where it was found)

 

Changes are coloured differently (easy to spot when there is lots of data).

Tables data in...