Jump to content

Report - Assets with Calls


Kelvin
 Share

Recommended Posts

I am trying to create a report that will give me all assets and their calls for a certain asset type. At Insights I was given a starter definition file with the table joins but I have been unable to get this to return any data.

Any help would be greatly appreciated.

assets-with-calls.report.txt

Link to comment
Share on other sites

@Kelvin That's where I'm looking, and I see exactly the same but with Assets visible. I also added an asset to a Request that didn't previously have one and the preview updated to include that request.

Is the Report you're using exactly the same as the one attached in your original post, or have you made any changed - e.g. added any filters? You mention a certain asset type, have you filtered on that? If so, that might be where the problem lies.

Link to comment
Share on other sites

@Steve Giller I thought I would come back to the forum as I can see from the support ticket this is a case of query is to large to complete within 30 seconds.

What I am trying to achieve is a list of calls with the asset type == 15. Do you know if there is a more optimised approach.

Thanks

Link to comment
Share on other sites

@Kelvin I'm not a SQL specialist, bur I believe that grouping is quite intensive (and in your report didn't appear to do very much) so removing that should help.
You can match for asset type == 15 in the Select Filter tab.

Hopefully the more experienced report writers from the Community will take it from here and give their advice.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...