Can anyone tell me if there are any audit reporting features in Umbraco or available as an add-on. The audit trail feature is ok, but I need to able to view the audit trail for the whole site rather than just a single page e.g. Show all pages that were created or modified in the last 24 hours.
I suppose you could write your own CMS page that uses the following SQL:
SELECT * from (SELECT TOP 1000 l.id
,l.userId
,l.NodeId
,l.Datestamp
,l.logHeader
,l.logComment,
u.username,
(SELECT TOP 1 c.text from cmsDocument c where c.nodeId = l.NodeId) as PageName
FROM umbracoLog l INNER JOIN [umbracoUser] u ON u.id = l.userId
ORDER BY Datestamp, userId) as HistoryLog
WHERE PageName IS NOT NULL
Please correct me if this can be made simpler but it was done quickly for this post.
Currently there is no such package available - I'll suggest you try creating your own dashboard in the "Content" section where you can probably make use of the SQL code Jonathan suggests above.
Reporting functionality for auditing
Hello,
Can anyone tell me if there are any audit reporting features in Umbraco or available as an add-on. The audit trail feature is ok, but I need to able to view the audit trail for the whole site rather than just a single page e.g. Show all pages that were created or modified in the last 24 hours.
Any help would be greatly appreciated.
Many thanks
Paul
I suppose you could write your own CMS page that uses the following SQL:
Please correct me if this can be made simpler but it was done quickly for this post.
Hi Paul
Currently there is no such package available - I'll suggest you try creating your own dashboard in the "Content" section where you can probably make use of the SQL code Jonathan suggests above.
You should be able to make the dashboard based on AngularJS following this guide https://www.linkedin.com/pulse/20141112132834-65892830-creating-a-custom-umbraco-dashboard-section
Hope this helps.
/Jan
is working on a reply...