I am trying to find out all the analyst comments logged for an particular incident, I tried querying the cmdb table  MT_System$WorkItem$TroubleTicket$AnalystCommentLog but it requires Basemanagedentity id, in order to search bmeid I queried incident table but no luck the bmeid from incident table does not return any output in analystcommentlog, any help would be greatly appreciated. 

You want/need to query the SQL database? Or does a PowerShell Script works for you as well?

The SQL for that is:

select cLog.DisplayName, 
	cLog.Comment_AECE7B96_331B_498C_2F77_AEA4376EFFF1, 
	cLog.EnteredBy_A14C9A28_2F82_D1F2_BCCD_A4E3745179B5
from dbo.MT_System$WorkItem$Incident as ir
inner join dbo.Relationship as rel
on ir.BaseManagedEntityId = rel.SourceEntityId
inner join dbo.MT_System$WorkItem$TroubleTicket$AnalystCommentLog as cLog
on rel.TargetEntityId = cLog.BaseManagedEntityId
where ir.Id_9A505725_E2F2_447F_271B_9B9F4F0D190C = 'IR#'

The SQL for that is:

select cLog.DisplayName, 
	cLog.Comment_AECE7B96_331B_498C_2F77_AEA4376EFFF1, 
	cLog.EnteredBy_A14C9A28_2F82_D1F2_BCCD_A4E3745179B5
from dbo.MT_System$WorkItem$Incident as ir
inner join dbo.Relationship as rel
on ir.BaseManagedEntityId = rel.SourceEntityId
inner join dbo.MT_System$WorkItem$TroubleTicket$AnalystCommentLog as cLog
on rel.TargetEntityId = cLog.BaseManagedEntityId
where ir.Id_9A505725_E2F2_447F_271B_9B9F4F0D190C = 'IR#'

• Marked as answer by Nikhil Lotia 1 hour 27 minutes ago

The SQL for that is:

select cLog.DisplayName, 
	cLog.Comment_AECE7B96_331B_498C_2F77_AEA4376EFFF1, 
	cLog.EnteredBy_A14C9A28_2F82_D1F2_BCCD_A4E3745179B5
from dbo.MT_System$WorkItem$Incident as ir
inner join dbo.Relationship as rel
on ir.BaseManagedEntityId = rel.SourceEntityId
inner join dbo.MT_System$WorkItem$TroubleTicket$AnalystCommentLog as cLog
on rel.TargetEntityId = cLog.BaseManagedEntityId
where ir.Id_9A505725_E2F2_447F_271B_9B9F4F0D190C = 'IR#'

• Marked as answer by Nikhil Lotia Sunday, August 23, 2015 5:48 AM

The SQL for that is:

select cLog.DisplayName, 
	cLog.Comment_AECE7B96_331B_498C_2F77_AEA4376EFFF1, 
	cLog.EnteredBy_A14C9A28_2F82_D1F2_BCCD_A4E3745179B5
from dbo.MT_System$WorkItem$Incident as ir
inner join dbo.Relationship as rel
on ir.BaseManagedEntityId = rel.SourceEntityId
inner join dbo.MT_System$WorkItem$TroubleTicket$AnalystCommentLog as cLog
on rel.TargetEntityId = cLog.BaseManagedEntityId
where ir.Id_9A505725_E2F2_447F_271B_9B9F4F0D190C = 'IR#'

• Marked as answer by Nikhil Lotia Sunday, August 23, 2015 5:48 AM

The SQL for that is:

select cLog.DisplayName, 
	cLog.Comment_AECE7B96_331B_498C_2F77_AEA4376EFFF1, 
	cLog.EnteredBy_A14C9A28_2F82_D1F2_BCCD_A4E3745179B5
from dbo.MT_System$WorkItem$Incident as ir
inner join dbo.Relationship as rel
on ir.BaseManagedEntityId = rel.SourceEntityId
inner join dbo.MT_System$WorkItem$TroubleTicket$AnalystCommentLog as cLog
on rel.TargetEntityId = cLog.BaseManagedEntityId
where ir.Id_9A505725_E2F2_447F_271B_9B9F4F0D190C = 'IR#'

• Marked as answer by Nikhil Lotia Sunday, August 23, 2015 5:48 AM

Thank you so much Andreas for your time and help.