|
If you were logged in you would be able to see more operations.
|
|
|
I think it would useful to have a log that shows which specific confluence user is running the sql macro, what page the sql was located on, and when it was executed. I previously brought the idea up informally, and the idea was to monitor use in the confluence log4j log as an info message.
Thanks for your time
Clynt
|
|
Description
|
I think it would useful to have a log that shows which specific confluence user is running the sql macro, what page the sql was located on, and when it was executed. I previously brought the idea up informally, and the idea was to monitor use in the confluence log4j log as an info message.
Thanks for your time
Clynt |
Show » |
|
New Feature
Open
Major
Log SQL macro use
Example:
{replace-and-render}{replace-item:%Query%}select * from confluence.Confluence.Bandana where BANDANACONTEXT = '\$value'{replace-item}
{replace-item:%fullName%}{report-info:global:current user}{replace-item}
{replace-body}
{run:replace=value::Bandana Context|exportFile=^%fullName%.html|titleExport=Export File: %fullName%.html}
{sql:datasource=confluence|output=wiki}
Execute dba.dbo.spc_AuditMacroUse '%fullName%,'SQL Macro Logging example', "%Query%"
{sql}
{sql:dataSource=confluence|output=wiki}
%Query%
{sql}
{run}
{replace-body}{replace-and-render}
It would be a great day to ditch this mess for logging purposes.