Reporting on retired services - past 7 days

[Mike Foreman]

I'm looking to add a widget to a dashboard that shows how many services have been retired in the past 7 days. I've tried a condition of operational_status = retired AND updated_on the past 7 days. But it feels like this is not accurate enough. I really don't want to have to add a new field for the date change if avoidable. Any ideas?

[Mark Manders · Accepted solution]

You are correct, because any update to the record will show when you use 'sys_updated_on'. However, your 'I really don't want to add....' will prevent you from reporting on this. The date/time of operational status is not tracked on the record (it is in the audit table, but absolutely don't ever report on that). 

If you have PA you can see if you can use that to collect the daily 'retired' ones, but it won't give you the exact ones that are retired. If your services are integrated from another system and the integration stops on retirement, you could use the last recovered date/time stamp, but not sure if you have that.

Then you are stuck with metrics. OOB you can't have metrics on non-task tables, but you can update the table reference qualifier to enable other tables as well. Then you can create your metric to be set when the status changes. You just need to add the metric event BR to the table to enable it.

Most simple way: create that field. If it is important enough to report on, it's is worth the limited work to create the field and update it on retirement.

[Mike Foreman]

Excellent advice and concise summary - thank you very much!