Translog
Track Exactly Who Did What, When!
One of the most common questions we get is ‘who did what?’. Usually this comes about in situations such as ‘the big customer’ complains of an improper billing and everyone wants to know, ‘Who is responsible for this?’ And of course, there are many, far less dramatic situations which will invariably come up where you need to be able to audit all changes made to a particular piece of information.
Standard Equipment: Last Revision
Standard equipment with SAFE is the ability to track the Last Revision Date, Last Revision Time, and Last Revised By for most records such as Customers, Products, Sales Orders, A/P Bills, etc. For example, you can easily view the last time a Customer was edited and who made the change from the Customer Browse. In the same way, you can review the last person to edit an A/P Bill (usually this would be right before a payment was made against the Bill.)
TransLog SAFExtension
Optional equipment is our TransLog SAFExtension, which keeps a running audit trail of all changes to your data. For example, you can specify that you wish to track ‘who did what’ for all aspects of the Sales Order process, but not track edits to Product Specs. A complete set of reports is included which allows the manager to track changes to specific tables or even down to a single transaction. For example, this gives you the ability to list every time a Sales Order was edited and by whom, from creation, through billing and payment.
Translog is now easier than ever. A Translog menu has been added to every browse box. Just right click on any master record or transaction and instantly see all changes to that data! Another first for SAFE—complete auditing of database changes made SIMPLE.
No Free Lunch, Though!
TransLog has two costs. The first, of course, is the price! The second cost is in CPU horsepower. As you might imagine, logging all these actions in such a detailed way would increase database activity on your server. You’re right! And in fact, if you elect to log all activity in SAFE, you will probably notice a performance drop:
| Database Version | Performance Reduction |
|---|---|
| MSDE (included in SAFE/6 and SAFE/7 for 1-3 users) |
15-20% |
| SQL Server 2000 (for larger installations in SAFE/6 and SAFE/7) |
10% |
| SQL Server 2005 (recommended for SAFE/8) |
0-5% |
To compensate, you may want to consider doing all the normal things we suggest for improving performance: Faster server hard disk, faster network cards, network switches instead of hubs, etc.
Conclusion
As your business grows, the ability to track transactions and record updates in a comprehensive way becomes more and more important. TransLog gives you this
capability at a bargain price, with the caveat that your hardware be powerful enough to support the added disk activity. Of course, for the majority of you who will most benefit
from this SAFExtension, this level of hardware should be in place.
Purchase Translog SAFExtension now for $1,295.00