RE: Upgrade 2013R2 to 2016R2 duplicated smartlists
Answered my own question, the numerical ones were in there as well as the worded ones to fix I had to delete all the numeric. Not sure if this is going to be a repeated issue in the R2, have another upgrade and will report back.
Fixed it by doing this, you will have to find all the numeric ones using this query first:
select * from DYNAMICS..ASIEXP81 where ASI_Favorite_Save_Level=0 and ASI_Favorite_Dict_ID=0 order by ASI_Favorite_Type
delete from DYNAMICS..ASIEXP81 WHERE ASI_Favorite_Name IN ('28003', '288004', '28005', '28006', '28007', '28008', '28009', '28010', '28011', '28012', '28013', '28014', '28015', '28016', '28017', '28018', '28019', '28020', '28021', '28022', '28023', '28024', '28027', '28028', '28029', '28030', '28031', '28032', '28036')