There's two parts to this.
First, you simply can't do it for addons. Addons provide functionality and you can't search for that. Think of it this way - if I wrote an addon that adds a button that just says "hello world" on the menu and pops up a picture of a random kitten when pressed - how do you know how that is used? There's nothing in the database for you to search for.
Secondly, you can do it for macros, but...
Reading the database is by far the hardest way to do this. You can use multiple different macros in the body of a page, and those are stored as xml, so SQL isn't going to help you much - you'll be able to find pages where each macro is used quite easily, but you're going to have to query for every macro individually, and parse the xml for it.
Confluence search does allow you to do it more easily, although you still need to do it for every macro - the term macroName:note will find every where you've used the note macro for example.
Your best option is therefore to do it in Confluence where you can use the API. See @Davin Studer 's answer on https://answers.atlassian.com/questions/155280 for what I'd do.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.