Looking for a view or export of products that are in abandoned carts for all the customer (rather looking from customer view looking for a product view).

Is it possible? and if yes please help, it could be via SQL report I suppose as an easy option rather going.

Any option and if its SQL, does anyone got the script.

Basically report that shows as e.g.
something of this sort->
Product ID, Product Name, Quantity, Customer List

123, TV Samsung, 5, <Mr X; MR Y; Mr Z>