How to check if a portlet is used by any virtual instance in Liferay 6.2

Issue

• How can I check if a portlet is used by any virtual instance in Liferay 6.2?

Environment

• Liferay Portal 6.2

Resolution

1. Go to Control Panel > Plugins Configuration.
2. Click the portlet you are checking.
3. Find the portlet ID on the resulting page.
4. Query the database using the following SQL command, replacing [portletId] with the actual portlet ID:

   SELECT * FROM Layout WHERE typeSettings LIKE '%[portletId]%';

5. This query returns all pages where the portlet is displayed. The `companyId` column indicates the associated virtual instance. You can find the `companyId` in the `Company` table.

Additional Information

• As a general recommendation, back up your database before performing any database operations.