i want to know a table for macro and plugin details

[Palyekar, Anvi]

i  am joining two queries, so joining two tables i want details for macro and plugins or where exactly macro and plugin data is stored like in which table??

[Naveen Kumar_Appfire]

Hi @Palyekar, Anvi

Using the below table you can get the space name and id where the plugin details are saved.

SELECT DISTINCT s.spaceid, s.spacekey, s.spacename FROM CONTENT c JOIN BODYCONTENT bc ON c.contentid = bc.contentid JOIN SPACES s ON c.spaceid = s.spaceid WHERE c.prevver IS NULL AND c.contenttype IN ('PAGE', 'BLOGPOST') AND bc.body LIKE '%ac:name="***%';

[Palyekar, Anvi]

Thanks Naveen for quick reply.

But i don't want the macro name in any text document....i have this query already.

I want table name where all plugin and macro details are present.