Can Prophet show me the last access time for each user?

Usage Reports

Prophet stores the last access time by user activity for the following four functions:

  • Viewed Contact List

  • Viewed Company List

  • Viewed Opportunity List

  • Viewed Prophet Today Dashboard data

This data a can be retrieved by the Administrator via the admin portal under “Usage Reports.”

Prophet CRM: Manage Users View

The frequency of these interactions can be derived from the SQL database via a query

select * from [dbo].[VW_ActivityAudit]

Here is an example:

Prophet CRM: SQL Database Export View

The hit count tells you how many times the user has performed the action. For example, since starting on my current database, Eric has viewed the contact list 423 times. The time shown is in UTC, so it was last loaded on 2/28 at 5:40pm.

How do I remove the red line present in my reports?

If you see a red line on your Basic Report this means your page width is set too wide and the red line indicates where the end of the page/report should be.

Prophet CRM: Report Manager - Remove Redline View

Portrait:

  • The size of the Basic Report in Portrait view should be set to 6.5 inches in total length.

  • Prophet will add an additional 1” to each side of the page.

Landscape:

  • The size of the Basic Report in Landscape view should be set to 9 inches in total length.

  • Prophet will add an additional 1” to each side of the page.

To Fix Red Line/Margins Length of Reports:

  • Open Outlook

  • Select Report Manager folder

  • Under “Choose Report Category” select the appropriate report type

  • Under “Choose Report Name” highlight the appropriate report

  • Click Designer.

    Prophet CRM: Report Manager - Designer View

  • Expand Designer to fit screen size.

    • Double click on the top to expand size or click on the single square box next to the ‘X’.

  • Move mouse over right edge of report until a line with two arrows, one on either end, appears (similar to image below).

    Prophet CRM: Report Expanded View 1

  • Hold down left mouse key.

  • Drag mouse and black line to desired length found along the grid at the top of the page.

  • Let go of mouse key.

  • Select File.

  • Click Save.

  • Exit Designer.

  • Run report as normal.

    Prophet CRM: Report Expanded View 2