Why do you want to get the macro usage out of the SQL database?
As an administrator you have the possibility to check the macro usage in the settings as described here:
Confluence administrators can check how often each macro is used in your site.
To see how often a macro is used, go to > General Configuration > Macro Usage. This lists how often each macro is used in current spaces but doesn't include any macros used on pages in archived spaces or macros provided by disabled apps.
Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events