nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DORA - Time to Restore

Guy Geron_fidbxy

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?

Accepted answers

Tracy Chow_f2gtzj

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

All comments

Tracy Chow_f2gtzj

Hi Guy,

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_fidbxy

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_f2gtzj

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:

Screenshot 2024-07-18 at 4.03.05 PM.png

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_fidbxy

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 🙏🏼 Screenshot 2024-07-18 at 8.32.13 AM.png