Skip to content

Instantly share code, notes, and snippets.

@GambitK
Created July 4, 2017 12:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save GambitK/38c9894018672fef8f9d1955a962fb30 to your computer and use it in GitHub Desktop.
Save GambitK/38c9894018672fef8f9d1955a962fb30 to your computer and use it in GitHub Desktop.
<?xml version="1.0" encoding="UTF-8"?>
<Audit xmlns="http://xmlns.oracle.com/oracleas/schema/dbserver_audittrail-10_2.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.oracle.com/oracleas/schema/dbserver_audittrail-10_2.xsd">
<Version>10.2</Version>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>138011098</Session_Id><StatementId>1</StatementId><EntryId>1</EntryId><Extended_Timestamp>2012-11-28T12:53:34.816405</Extended_Timestamp><DB_User>CR</DB_User><OS_User>asoliz</OS_User><Userhost>svrdb11</Userhost><OS_Process>27047</OS_Process><Instance_Number>0</Instance_Number><Action>100</Action><TransactionId>0000000000000000</TransactionId><Returncode>0</Returncode>
<Comment_Text>Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.24)(PORT=54364))</Comment_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>138011098</Session_Id><EntryId>2</EntryId><Extended_Timestamp>2012-11-28T12:53:44.985232</Extended_Timestamp><DB_User>CR</DB_User><OS_User>asoliz</OS_User><Userhost>svrdb11</Userhost><Instance_Number>0</Instance_Number><Action>101</Action><Returncode>0</Returncode>
</AuditRecord>
</Audit>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>138027559</Session_Id><StatementId>1</StatementId><EntryId>1</EntryId><Extended_Timestamp>2012-11-28T17:00:45.926814</Extended_Timestamp><DB_User>CR</DB_User><OS_User>NETWORK?SERVICE</OS_User><Userhost>svrdb11</Userhost><OS_Process>27047</OS_Process><Instance_Number>0</Instance_Number><Action>100</Action><TransactionId>0000000000000000</TransactionId><Returncode>0</Returncode>
<Comment_Text>Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.24)(PORT=51320))</Comment_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>138027559</Session_Id><EntryId>2</EntryId><Extended_Timestamp>2012-11-28T17:00:45.954773</Extended_Timestamp><DB_User>CR</DB_User><OS_User>NETWORK?SERVICE</OS_User><Userhost>svrdb11</Userhost><Instance_Number>0</Instance_Number><Action>101</Action><Returncode>0</Returncode>
</AuditRecord>
</Audit>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>138057815</Session_Id><StatementId>1</StatementId><EntryId>1</EntryId><Extended_Timestamp>2012-11-29T11:27:27.019270</Extended_Timestamp><DB_User>SBC_IVR</DB_User><OS_User>NETWORK?SERVICE</OS_User><Userhost>IVR\USER</Userhost><OS_Process>27047</OS_Process><Terminal>USER</Terminal><Instance_Number>0</Instance_Number><Action>100</Action><TransactionId>0000000000000000</TransactionId><Returncode>0</Returncode>
<Comment_Text>Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.32)(PORT=3294))</Comment_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>138057815</Session_Id><EntryId>2</EntryId><Extended_Timestamp>2012-11-29T11:27:53.633169</Extended_Timestamp><DB_User>SBC_IVR</DB_User><OS_User>NETWORK?SERVICE</OS_User><Userhost>IVR\USER</Userhost><Terminal>USER</Terminal><Instance_Number>0</Instance_Number><Action>101</Action><Returncode>0</Returncode>
</AuditRecord>
</Audit>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>138073784</Session_Id><StatementId>1</StatementId><EntryId>1</EntryId><Extended_Timestamp>2012-11-29T15:43:46.471817</Extended_Timestamp><DB_User>CR</DB_User><OS_User>stelleria</OS_User><Userhost>svrdb11</Userhost><OS_Process>27047</OS_Process><Instance_Number>0</Instance_Number><Action>100</Action><TransactionId>0000000000000000</TransactionId><Returncode>0</Returncode>
<Comment_Text>Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.24)(PORT=56024))</Comment_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>138073784</Session_Id><EntryId>2</EntryId><Extended_Timestamp>2012-11-29T15:44:49.864270</Extended_Timestamp><DB_User>CR</DB_User><OS_User>stelleria</OS_User><Userhost>svrdb11</Userhost><Instance_Number>0</Instance_Number><Action>101</Action><Returncode>0</Returncode>
</AuditRecord>
</Audit>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>138104383</Session_Id><StatementId>1</StatementId><EntryId>1</EntryId><Extended_Timestamp>2012-11-30T09:42:19.753584</Extended_Timestamp><DB_User>DBSNMP</DB_User><OS_User>oraban</OS_User><Userhost>svrdb.domain.local</Userhost><OS_Process>27047</OS_Process><Terminal>unknown</Terminal><Instance_Number>0</Instance_Number><Action>100</Action><TransactionId>0000000000000000</TransactionId><Returncode>0</Returncode>
<Comment_Text>Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.9.0.221)(PORT=56370))</Comment_Text>
</AuditRecord>
</Audit>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>138120603</Session_Id><StatementId>1</StatementId><EntryId>1</EntryId><Extended_Timestamp>2012-11-30T13:40:51.857149</Extended_Timestamp><DB_User>CR</DB_User><OS_User>hponciano</OS_User><Userhost>svrdb11</Userhost><OS_Process>27047</OS_Process><Instance_Number>0</Instance_Number><Action>100</Action><TransactionId>0000000000000000</TransactionId><Returncode>0</Returncode>
<Comment_Text>Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.24)(PORT=58987))</Comment_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>138120603</Session_Id><EntryId>2</EntryId><Extended_Timestamp>2012-11-30T13:42:48.059827</Extended_Timestamp><DB_User>CR</DB_User><OS_User>hponciano</OS_User><Userhost>svrdb11</Userhost><Instance_Number>0</Instance_Number><Action>101</Action><Returncode>0</Returncode>
</AuditRecord>
</Audit>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>138137737</Session_Id><StatementId>1</StatementId><EntryId>1</EntryId><Extended_Timestamp>2012-11-30T17:31:18.317988</Extended_Timestamp><DB_User>NSANTOS</DB_User><OS_User>erivera</OS_User><Userhost>domain\VMSVRTERMINAL10</Userhost><OS_Process>27047</OS_Process><Terminal>VMSVRTERMINAL10</Terminal><Instance_Number>0</Instance_Number><Action>100</Action><TransactionId>0000000000000000</TransactionId><Returncode>0</Returncode>
<Comment_Text>Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.96)(PORT=53849))</Comment_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>155509154</Session_Id><StatementId>1</StatementId><EntryId>1</EntryId><Extended_Timestamp>2013-11-03T12:21:32.800404</Extended_Timestamp><DB_User>SBUSIB</DB_User><OS_User>NETWORK?SERVICE</OS_User><Userhost>domain\user02S</Userhost><OS_Process>27047</OS_Process><Terminal>user02S</Terminal><Instance_Number>0</Instance_Number><Action>100</Action><TransactionId>0000000000000000</TransactionId><Returncode>0</Returncode>
<Comment_Text>Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.199)(PORT=1215))</Comment_Text>
</AuditRecord>
<AuditRecord><Audit_Type>1</Audit_Type><Session_Id>155509154</Session_Id><EntryId>2</EntryId><Extended_Timestamp>2013-11-03T12:32:38.495672</Extended_Timestamp><DB_User>SBUSIB</DB_User><OS_User>NETWORK?SERVICE</OS_User><Userhost>domain\user02S</Userhost><Terminal>user02S</Terminal><Instance_Number>0</Instance_Number><Action>101</Action><Returncode>0</Returncode>
</AuditRecord>
</Audit>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment