According to the structure of the database, you want the ActionLog class and the Comment is in the field "Description", the kind of record entry field is "Title", and who made the log entry field is "EnteredBy."
If you want to see this directly, here's the query for the CMDB:
select *
from dbo.Relationship as rel with (nolock)
join dbo.RelationshipType as rtype
on rel.RelationshipTypeId = rtype.RelationshipTypeId
join dbo.MT_System$WorkItem$TroubleTicket$ActionLog as ttlog
on rel.TargetEntityId = ttlog.BaseManagedEntityId
where rel.SourceEntityId = '918D97AF-43B8-F3CD-C3DB-BF9F6ED65E3E' -- BaseManagedEntityId of your Incident
order by rel.TimeAdded
-
Edited by
Foothill1
Monday, August 31, 2015 7:58 PM