Why doesn't the Bamboo audit log (in build and deploy) show the year?

Miranda LeBlanc

When using the plan configuration to look at build plan audit logs, or using the deploy project audit log, I'm curious why the timestamp displays without the year? Is there a reason for that? We have plans that have been in use for many years and it's hard to go back through the history when trying to troubleshoot errors. 

 

Thanks!

Daniel Santos_157bm4

Hi @Miranda LeBlanc

That is indeed a good observation, thank you for pointing that out.
I've opened an improvement request to adjust this: https://jira.atlassian.com/browse/BAM-20753.

I'm assuming that you need this information now and you won't be able to wait for this improvement. With that in mind, I suggest you check the Bamboo audit_log table (as a workaround). That table holds the plans, deployment audit logs and more.

This is an example of a query that could be used in Postgres to get the plan related audit logs:

select 
   to_timestamp(TRUNC( CAST(msg_time_stamp AS bigint)/1000)) human_timestamp,
   *
from
   audit_log
where 
   lower(entity_type) like lower('Plan')
   and entity_id like 'PLAN-KEY'
order by msg_time_stamp desc

I hope that helps.

=]