Audit Reports and Queries

Modified on Mon, 20 Apr at 6:11 AM

Synergetic has Crystal Reports to extract and display various user activity


Crystal Reports

Crystal Report : SysPortalD

Report Description Portal Usage Details


This Crystal Report displays Community Portal Page access . Currently only key finance and Administration pages are recorded and displayed


image.png

Crystal Report : SysPortalSum

Portal Usage Summary


This Crystal Report displays Community Portal Usage in Summary graph format

Currently only key finance and Administration pages are recorded and displayed


image.png



Crystal Report : SYSCRS

Crystal Report Usage Summary

This Crystal Report displays a summary of Crystal Report Usage by date and user

image.png



Crystal Report :  SYSCRU

Crystal Report Usage by User

This Crystal Report displays Crystal Report Usage by date and user


image.png




 

Database Queries

The following Database tables and views can be used to retrieve user and audit details


dbo.Communitylogins

contains the last logindate of a community Portal User


dbo.Communityloginhistory

contains a history of logins for each community Portal User


dbo.PublicAccount

contains login details of Application Dashboard portal users


dbo.MessageLog

contains trace and message log data such as system messages and user responses to the these messages.
Refer -
Synergetic MessageLog

History and maintenance Tables

Most Synergetic Maintenance screens contain a Maint tab signifying an audit of modifications to key data, who made the change and a date/time stamp of the change :Synergetic Maintenance Tabs


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article