When using Change Auditor for SQL, the reported User Login, Computer Name and IP Addresses reported are not corrects
VSTS10558
When a number of database transactions are performed and there a large number of logon\logoffs recorded in SQL, the Change Auditor Agent obtains the incorrect Login Time for the database transaction
Since Database SPIDs are often reused, the Agent finds the incorrect corresponding login information for the transaction.
The issue appears to occur only in SQL Server 2008 and 2008 R2 and when using SQL logins
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy