Skip to content
Gallery
Connectwise Decoupling
Overview
The CCR Team Member
USER REFERENCE STANDARDS
More
Share
Explore

icon picker
USER REFERENCE STANDARDS

STANDARD WE NEED TO GET TO

TABLES (filter by tables included with an Audit Log)

Need columns [UserReferenceID] & [UserReferenceTypeID]

TRIGGER

Need to reference p_FOC.dbo.AuditLog_UserReference
Insert into values into [UserReferenceID] & [UserReferenceTypeID] columns
Add Optional User Tracking

PER DATABASE

In AuditLog table > need columns [UserReferenceID] & [UserReferenceTypeID]AuditLog

Sprint 3 Objectives
Adding p_FOC database & TranformationDb to get up to outlined Standard
Including update Transformationdb.dbo.AuditLog to include [UserReferenceID] & [UserReferenceTypeID]
ONLY ADDING, up next: Developers have cutover, then old columns can be removed and audit logs & triggers cleaned up

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.