In the coming months we are moving from a hosted ITSM solution not an Atlassian product (SQL Backend) to Jira Service Management and I am starting to try and figure out if we can achieve some of the things we do now.
For instance, when we onboard people we record their department (for example: Lighting). In the system we have a lookup table for each department, there is a value for all the major items a person needs for their department. The machine type, the monitor types, software licenses etc etc
In the newstarter table there are custom fields which just writes a the number of those items needed next to the values. Basically I can build an expression from the new starter fields to the look up table to determine what the value per department per new starter is.
Spec B128 - 1
27" Monitor - 1
27" Dreamcolour - 1
Nuke - 1
Mari - .5
Now we do this for all our starters so it builds up a view of all the hardware we need and software licenses for whatever reporting period in the future we want to see. So I can see 2 weeks in advance how many Spec B128 or Spec A96 are needed, how many licenses of Nuke, Office, Houdini etc etc
With Jira being cloud based I am not sure what we are going to be able to build in the cloud when it comes to something like lookup tables, retrieving data to be used in other tables upon incident creation. I leverage this a lot in our current system and would like to know how things like this can be achieved in JSM Cloud.
ok taking another tact, is there ways to export subsets of data out of JSM Cloud that I can then leverage in Power BI. I could have the lookup in Power BI and then with the JSM data come up with the predictive view in a visualisation.
Can there be scheduled exports from JSM?
Not directly, you would need to extract data via the REST API, you have no access to the database.
Exports are possible, but not as a push. A human has to click the "backup and download all the data", or run a filter and hit "export to CSV". The REST API is a pull, you can ask it to run a filter and give you a JSON representation of all the issues you find.
There is also a "data lake" option on the way, it's in Early Access at the moment, with a number of people testing it.
The Early access trial closed a while ago, so they shut down the email.
I don't have any guess as to when it'll be released to the wider audience. But you've posted the question on the conversation, which is the best place for it! I'll see if I can get Atlassian to give us more on the back of that question!
Not directly, it won't do that sort of reporting (yet), but the asset tracking data it holds are what you would use to generate that sort of report. Plain Jira would not really be suitable, because it is an issue tracker, not an asset tracker, and the data wouldn't be the right shape.
Hi Everyone, In this tutorial, we will show you how you can monitor an SLA, and send notifications before or after the SLA has been breached. SLA Threshold Trigger The SLA t...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events