Help me design a logging table

Ok, I bought the Cloud SDK.

Trying to set up a new logging table.

Here are my notes so far, thoughts?

LogID -> BigInt or Guid?

TimeStamp

LogCategory -> For Expansion -> Default -> General 

Severity -> DEBUG, INFO, WARNING, ERROR, FATAL

Project
ProjectDetail

MessageType -> Text, Exception, Structured Data (Json Object)
MessageSubType -> Blank, Custom, or Structured ObjectType Info
Message (Short Message?)
MessageDetail (object or detail)


ExtraDataType -> Text, Structured Data (Json Object), Other
ExtraDataSubType -> Blank, Custom, or Structured ObjectType Info
ExtraData (Short Message?)
ExtraDataDetail (object or detail)


UserID
EmployeeID
SessionInfo (Selected)

CalledFrom (SelectedInfo) BPM.Service.Method.Pre/Base/Post.Name, EFX.LibraryID.FunctionID, etc (standardized), EXT(External)
2 Likes

If y’all don’t like any of that please feel free to propose something new or different as well.

If you plan to integrate with Open Telemetry down the road, this is their recommendation:

4 Likes

This is a nice document. It’s basically what I was looking for yesterday but couldn’t find.

Season 9 Thank You GIF by The Office

2 Likes

5 Likes

You jest, but I’m finally getting my shop cleaned and I can weld and do woodwork…

Looks like a plan!

1 Like