Share via

SCSM ticket action logs - extract via SQL script

Tiffany Davis 20 Reputation points
2025-07-10T17:17:51.3566667+00:00

Is there a way to extract the action log entries of tickets via a SQL script? I cannot find the database table (or tables) where this information is stored, but would like to be able to add this to the SQL query we are currently using.

System Center Service Manager
0 comments

Answer accepted by question author

Dieter Gasser 496 Reputation points
2025-07-11T09:37:33.1866667+00:00

Take a look at the following tables:

  • MT_System$WorkItem$TroubleTicket$ActionLog
  • MT_System$WorkItem$TroubleTicket$AnalystCommentLog
  • MT_System$WorkItem$TroubleTicket$UserCommentLog

I hope this helps.

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.