Is there a way to create a simple Assets report that can be scheduled and sent weekly?

Question

Does the Assets reporting really suck or am I missing something? I need a very simple report that I can send on a weekly basis. I have a field called "Expiration Date". I want to list all of the objects that have an Expiration Date in the next two months. I can write the AQL - that is simple. But I don't see any way to create a scheduled or saved report.

I can't believe that after all of this time, there is no way to create a simple report like this.

Derek Fields _RightStar_ · Answer

@David Nickell Thanks for the response. I am quite familiar with the REST endpoints and that is my backup solution. I was (am) hoping that Atlassian is going to fix the awful reporting implementation that they have saddled the Cloud version of Assets with. On DC, there is a simple way to execute an AQL statement, save it like a filter, and generate basic reports. Not so for Cloud, which is a huge oversight.

While implementing a REST-based solution isn't difficult, it requires an environment that is external to the Atlassian Cloud to run it. That creates a problem for clients that chose the cloud so that they don't have to maintain their own environments.

David Nickell · Answer

There is always a way.  And if I am answering the question, that way involves the REST API.

Keep in mind the order of your words "A way to Create a Simple Report" not "a Simple way to create a report".  But I digress...

I experimented with this on/off this afternoon....

Step 1 = use the JSM Workspace endpoint to get your Asset Workspace Ids:

https://splitdimedata.atlassian.net/rest/servicedeskapi/assets/workspace

Step 2 =  use Asset Endpoints that are workspace ID Driven from this common Workspace Endpoint (isn't based on your URL)

For purposes of answering this, I cheated and used the endpoint that is "deprecated".  Looks like this:

https://api.atlassian.com/jsm/assets/workspace/356e1f3c-1eae-4243-b211-fc629a02e04f/v1/aql/objects

And the  results were a few assets I create as a test some time ago:

4ACME Downtown 2nd Floor SprinkerFire SprinklerAF-45Jira Conversion StrategyVideoMA-52Power BIApplicationsSVC-21Sprint DetailsSoftware servicesSVC-1

In Summary - -this is not an answer per se, it is an approach or technique.  When I glanced at questions today there was yours about Aseets and someone else look for Confluence Database Content. I have an upcoming Asset project so jumped into yours.

My Point - of the answers I've given over the pasrt several months, a high percentage probably had REST API based solutions.    And -- REST is free.... no plugins. No per seat licenses.  Spend some time learning how to navigate the API layer.  You may find you eliminate dependence on dozens of Plugins   :-)

Assets Endpoints are here:  https://developer.atlassian.com/cloud/assets/rest/api-group-object/#api-group-object

JSM is here: https://developer.atlassian.com/cloud/jira/service-desk/rest/intro/#about