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][][][][][]