Hi FME'ers,
I have trying to parse and analyse the log file from our ArcGIS Licence Manager. I have managed to exact the user, the date/time, licence type, machine name and check-in/check-out. I am now trying to determine how long a user checked a licence out for. This would require aggregating or joining the in and out records for a particular user (I think). The difficulty I am having is identifying a unique session, e.g. user A check out the licence at 0900 and checked in at 1700 on 01/01/2019. There is no unique session identifier, just a series of in's and outs and these may span over more than one days. My best guess would be to isolate the user (group?) then do some kind of 1:1 join.....maybe. You help would be greatly appreciated.
Thanks,
David