DORA - Time to Restore

[Guy Geron]

I'm trying to create a widget that will provide me with one of the DORA measures: Time to Restore.

The way I'm thinking to approach it is:
- Find all the sev1 in my JSM project
- Make sure it's for the right system (we support many systems, and we use Assets to differentiate between the various systems)
- get the start date and the end date 
- plot it on a timeline 

My challenge is that I cannot find a way to connect (JOIN) an issue with an Asset via the scheme.

Did anyone solve that?

[Tracy Chow · Accepted solution]

Hi Guy,

There's a table in the Atlassian Data Lake schema called `asset_object_issue_mapping` which contains data that maps an Asset object to a Jira issue. https://support.atlassian.com/analytics/docs/schema-for-asset-and-configuration-management/#Assets-object-issue-mapping 

If you don't see it in your schema browser, you may need to toggle the "Show full schema" option from your visual mode query. Let me know if this helps.

Best,
Tracy

[Guy Geron]

Hi @Tracy Chow , 

Thanks for the helping. I did find the 'asset_object_issue_mapping', and it wasn't ticked on to be available for querying.
However, when I ticked this on and re-sync the scheme, the table was ticked off again.

Am I missing anything?
For reference, I did choose a Limited data connection

[Tracy Chow]

Hi Guy,

The "Visible" checkbox on the data source Schema tab determines whether the table is listed in the full schema view.

If a table has the checkbox unchecked, the table will only appear when "Show full schema" is toggled on in the visual mode schema browser. The toggle on the bottom is what I was referring to:

If you toggle it on, you can see all the tables, including the mapping tables. When you sync the schema, it resets back to the default checkbox settings from Atlassian Data Lake. I recommend either not synching the schema frequently or just using the "Show full schema" toggle to access the table.

Hope this clarifies things!

[Guy Geron]

Hi @Tracy Chow ,

Thanks again for your guidance. I've played with it a bit more and realised that the table is available when I tick the boxes for Visible under the Scheme tab and don't click the Sync Scheme button.

It's only when I sync it that the Visible checkbox disappears. I'm not sure if it's meant to do that. Is it due to the Limited data connection I chose when creating the dataset?

Anyway, I can use it now. I appreciate your help and guidance 🙏🏼

[Tracy Chow]

Yes, if you hit the "Sync Schema" button it goes back to the default Visible checkbox settings. This is the standard behavior, not only for connections with Limited data. Regardless, there shouldn't be many circumstances where you need to sync the schema.

Glad you can use the new table now! 🙂