I've been running this for a week in a scheduled task to collect logs to CSV. It has run successfully over this time, but now that I examine the output, I see that each run after the first run adds extraneous semi-colons for each new entry.
EDIT3:- I note that the Row of Header Names is removed from the CSV after the first run too.
The amount of added semi colons doubles on each daily run. This makes importing to excel impossible as the data importer freaks out.
Edit - Manually re-ran the BAT I use and caught this output.....
Starting run @ 2023-06-20 12:12:22.184290. Content: deque(['Audit.General', 'Audit.AzureActiveDirectory', 'Audit.Exchange', 'Audit.SharePoint', 'DLP.All']).
Rust engine finished receiving all content
Interfaces\FileInterface.py:96: DtypeWarning: Columns (0,1,2,3,5,6,9,10,11,12,14,15,16,17,18,19,20,22,23,24,25,27,28,29,30,31,33,34,37,38,39,40,42,43,44,45,46,47,48,50,51,52,53,55,56,57,58,59,61,62,65,66,67,68,70,71,72,73,74,75,76,78,79,80,81,83,84,85,86,87,89,90,93,94,95,96,98,99,100,101,102,103,104,106,107,108,109,111,112,113,114,115,117,118,121,122,123,124,126,127,128,129,130,131,132,134,135,136,137,139,140,141,142,143,145,146,149,150,151,152,154,155,156,157,158,159,160,162,163,164,165,167,168,169,170,171,173,174,177,178,179,180,182,183,184,185,186,187,188,190,191,192,193,195,196,197,198,199,201,202,205,206,207,208,210,211,212,213,214,215,216,218,219,220,221,223,224,225,226,227,229,230,233,234,235,236,238,239,240,241,242,243,244,246,247,248,249,251,252,253,254,255,257,258,261,262,263,265,266,267,268,269,270,272,273,274,275,276,277,279,280,281,282,283,285,286,289,290,291,292,294,295,296,297,298,299,300,302,303,304,305,307,308,309,310,311,313,314,317,318,319,320,322,323,324,325,326,327,328,330,331,332,333,335,336,337,338,339,341,342,345,346,347,348,350,351,352,353,354,355,356,358,359,360,361,363,364,365,366,367,369,370,373,374,375,376,378,379,380,381,382,383,384,386,387,388,389,391) have mixed types. Specify dtype option on import or set low_memory=False.
Writing 2 logs of type Audit.AzureActiveDirectory to F:\Office365 audit log collector\Logs\365Log_AuditAzureActiveDirectory.csv
Interfaces\FileInterface.py:96: DtypeWarning: Columns (0,1,2,3,4,6,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,28,30,31,32,33,34,35,37,38,39,40,41,42,43,48,50,51,52,53,54,55,56,57,58,59,60,61,62,64,65,66,67,68,69,70,72,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,98,99,100,101,102,103,105,106,111,113,114,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,139,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,165,166,167,168,169,171,173,174,175,180,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,205,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,230,231,232,233,234,235,236,237,239,241,242,243,244,245,246,251,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,269,272,273,274,275,276,277,278,279,281,282,283,284,285,286,287,288,289,290,291,292,293,296,297,298,299,301,302,303,304,305,306,307,308,310,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,332,334,335,336,337,338,339,340,341,342,343,344,345,346,348,349,350,351,352,357,359,360,361,362,363,364,365,366,367,368,370,371,372,373,374,376,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,402,403,404,405,406,408,409,411,412,413,414,419,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,442,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,469,470,471,472,473,475,476,477,478,479,480,482,485,487,488,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,508,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,532,533,534,535,536,538,539,541,542,543,544,545,546,547,548,549,550,555,556,557,558,559,560,561,562,563,564,565,566,567,569,570,571,572,573,575,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,601,602,603,604,605,606,607,609,610,612,615,617,618,619,620,621,622,623,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,642,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,665,666,668,669,670,671,672,673,674,675,676,677,678,680,681,686,688,689,690,691,692,693,694,695,696,697,698,700,703,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,725,726,727,728,729,731,733,734,735,736,737,738,743,745,746,747,748,749,750,752,753,754,755,756,757,758,759,760,762,765,766,767,768,769,770,771,772,773,774,775,776,777,778,779,780,781,782,783,785,786,788,789,790,791,792,793,794,795,796,798,801,803,804,805,806,807,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,826,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,852,853,854,855,856,858,859,860,861,866,868,869,870,871,873,874,875,876,877,878,879,880,881,882) have mixed types. Specify dtype option on import or set low_memory=False.
Writing 17 logs of type Audit.SharePoint to F:\Office365 audit log collector\Logs\365Log_AuditSharePoint.csv
Finished. Total logs retrieved: 338. Total retries: 0. Total logs with errors: 0. Run time: 0:02:50.215925.
FileInterface reports: 19 successfully sent, 0 errors
F:\Office365 audit log collector>pause
Press any key to continue . . .