How to find all products with recurring profile

[VikG]

Hi we are using Magento V 1.9.2.0 and have a problem whereby some of our inventory has an active recurring profile. This is a mistake as it should not have this.

However the only way we can find this right now is going through 1 product at a time.

Is there a way to find these in bulk? Even if it was to download the Database and search for a particular thing. 

We will change them back to normal profile manually but just want to be able to locate all Recurring Profiles to put a stop to this problem.

Your help is much appreciated.

[VikG]

Sorry for some reason my subject was completely wrong. I have now fixed this.

[prakash786]

Hello VikG

You can disable Recurring profile for all product from admin.

Please login into admin -> catalog -> Manage products after select all products and go to action top the catalog grid and select update attribute and submit.

After that please click checkbox near by Enable Recurring Profile and select No options and click submit.

 Hope it will help you, if works then mark as solution.