What is going to happen if I run the SiteMinder SMAuditImport tool twice on the same audit file?

Document ID : KB000052462
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Customer would like to know the expected behavior if he runs the SMAuditImport utility over and over on the same audit file.

Solution:

SMAuditImport tool can be run against an input file any number of times, the utility handle the case where some lines in the input file have already been inserted to the database. When a row has been inserted into the database, it is marked with the # character.

Audit file before run the SMAuditImport tool:

[Auth][AuthAccept][][lempvm05][29/Sep/2009:16:35:31 -0500][lempvm05][LBuXONo5QHg/dZnW3RHiImi/iu4=]
[Lisac][03-9f934a35-8430-4df3-bfca-b65fcb63e6a6][Test Realm][06-28d1d539-40ac-4203-97e8-a2690ba638b1]
[138.42.193.154][/test/hola.html][get][SM92][SM92][ODBC:][idletime=3600;maxtime=7200;authlevel=5;]
[][Test][][][][][][Az][AzAccept][][lempvm05][29/Sep/2009:16:35:31 -0500][lempvm05]
[LBuXONo5QHg/dZnW3RHiImi/iu4=][Lisac][03-9f934a35-8430-4df3-bfca-b65fcb63e6a6][Test Realm]
[06-28d1d539-40ac-4203-97e8-a2690ba638b1][138.42.193.154][/test/hola.html][get][][][][][]
[Test][][][][][]

Audit file after run the SMAuditImport tool:

#Auth][AuthAccept][][lempvm05][29/Sep/2009:16:35:31 -0500][lempvm05][LBuXONo5QHg/dZnW3RHiImi/iu4=][Lisac]
[03-9f934a35-8430-4df3-bfca-b65fcb63e6a6][Test Realm][06-28d1d539-40ac-4203-97e8-a2690ba638b1]
[138.42.193.154][/test/hola.html][get][SM92][SM92][ODBC:][idletime=3600;maxtime=7200;authlevel=5;][]
[Test][][][][][]#Az][AzAccept][][lempvm05][29/Sep/2009:16:35:31 -0500][lempvm05]
[LBuXONo5QHg/dZnW3RHiImi/iu4=][Lisac][03-9f934a35-8430-4df3-bfca-b65fcb63e6a6][Test Realm]
[06-28d1d539-40ac-4203-97e8-a2690ba638b1][138.42.193.154][/test/hola.html][get][][][][][][Test][][][][][]