SQl-qurey-Asset

SQl-qurey-Asset

I have defined a few Asset in the printer category and Requests and problem are defined on these assets.
I want to write a Qurey on assets table  that categorizes assets by problem.(Like the attached picture)
for example :
select Asset 
FROM Resources
WHERE Problem.title="" ...

                New to ADSelfService Plus?