Sql report setup to add Assets

[lee mcdermott]

Hi

I am trying to create a report to view requests logged against a particular asset that was linked to the call.

Any idea what tables are needed and how they should be joined?

Or is there an easier way to view requests logged against a particular asset

 

Any help would be great

 

thanks

lee

[Steve Giller]

This is very primitive, but should be enough to get you started.

requests-raised-against-an-asset.report.txt

[lee mcdermott]

@Steve Giller

 

thanks steve I will give that a go.