Thanks so much for reaching out here on the community.
Were you able to find a resolution to this issue? If yes, I would greatly appreciate if you could share it with the community.
If you are still facing an issue, why not open a support ticket here
Thanks again for investing your time in LANDESK.
1 of 1 people found this helpful
LANDESK doesn't have a natural/easy way to do this I'm afraid. I believe there are some unsupported scripts produced by consultants around that give a database view of the data, but generally LD support don't hand those out. Worth asking though.
What you can do is rework your process so that every action someone takes drops summary data into your own audit trail collection and then use that consolidated view of the data to write a query against.
The following SQL might be of help:
,(select md_title from md_business_function f inner join tps_audit_trail a2 on a2.tps_function_id=f.md_guid where a2.tps_audit_id=max(a.tps_audit_id)) as lastaction
from im_incident i
inner join tps_audit_trail a on a.tps_object_guid=i.pm_guid
where tps_is_automatic_action=0 and a.tps_type=0
group by i.im_id
order by i.im_id