Thursday, February 16, 2012

Commercial Audit Software

I'm looking for a good commercial, 3rd party solution, not a Trace solution.
Can anyone provide comments on something they have in production? So
far, my limited research has turned up Lumigent Entegra, and RippleTech
LogCaster.
My goal is to track DML changes by login with minimal impact on system
performance. Further, I need the audit data to be as secure as possible from
malicious updates and deletes. This is to implement audit tracking for SOX
compliance.
ThanksLumigent Entegra is probably the most mature product on the market for
server-level auditing. It isn't perfect, but it can go a long way towards
filling the audit requirements.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Garth Wells" <nobody@.ishome.com> wrote in message
news:uoCCTMXKFHA.2852@.TK2MSFTNGP14.phx.gbl...
> I'm looking for a good commercial, 3rd party solution, not a Trace
> solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible
> from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>|||Manakoa Services Corporation is releasing a System Controls MP for MOM2005
which provides basic collection and reporting for windows security events.
You can review the features at http://www.manakoa.com/products/scmp/
The RTM is scheduled for May 31st. If your interested in particpating in the
beta you can contact me at jbeckett@.manakoa.com for more info.
"Garth Wells" wrote:

> I'm looking for a good commercial, 3rd party solution, not a Trace solutio
n.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible fr
om
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>
>|||You can try LiveAudit from www.datamirror.com. It captures inserts updates
and deletes from the ms_replcmds table in the distribution database. You
need to publish the tables that you need to track. In addition to the actual
change in a row, you can also add journal information such as who made the
change, when the change was made, and what type of change accured among
other journal control information the changes are then reported as table
entries in most databases available. From there, you can use something like
Crystal reports to look at the history or trail of the changes made to the
database.
Hope this helps,
RdR
"Jeremiah Beckett" <Jeremiah Beckett@.discussions.microsoft.com> wrote in
message news:B08EC974-72DB-461F-AAEB-98CE1687852A@.microsoft.com...[vbcol=seagreen]
> Manakoa Services Corporation is releasing a System Controls MP for MOM2005
> which provides basic collection and reporting for windows security events.
> You can review the features at http://www.manakoa.com/products/scmp/
> The RTM is scheduled for May 31st. If your interested in particpating in
> the
> beta you can contact me at jbeckett@.manakoa.com for more info.
>
> "Garth Wells" wrote:
>

No comments:

Post a Comment