Hello All,
We recently got asked how many times we used the Reassign tool and what were the RouteIDs that got reassigned. Well, it's been discussed on here before how to access the LRS Edit Log and use the Activity Types to pull the total number, but not really how to pull which RouteIDs got changed and what to. After some digging online, I figured out the RouteID information is stored in XML format in the 'EDITDATA' BLOB in that table. So we created the below Python Script to pull that information out and put it in a CSV file.
