ITNinja

I have a custom inventory rule created to look for the following items from a vendor (Autodesk): Serial Number, Release, Product Name, StandaloneNetworkType, and Program Version.  The custom inventory rule is working, but now I need to create a report based on that criteria.  I'm not sure how to create the SQL report, and I'm looking for any assisyance available?  I know that I need to JOIN the items, but I'm not certain of this process.

Thank you.