Adding Asset Owner to asset reports
I'm trying to have a report for any selected Resource Type also include the Asset Owner, including records that do not have an Asset Owner (i.e. Instock status assets).
I used the Query Builder and adding the built-in Resource Type Association: [Asset User Owners] to [User] and then adding the field [User].[Name].
This succeeds in giving me the Asset Owner for each asset record, but it fiters out all asset records with NO Asset Owner. I've tried every variation of SQL Joins available via the drop down (except Cross since that just makes the console explode) and I either get no results or the same filtered results.
I converted the report to raw SQL then changed all the inner/outer/left/right joins to just JOIN and still not getting the results I want.
I just want a report of ALL assets under that resource type that includes the Asset Owner field, blank or not.
Suggestions? Symantec Enterprise Technical Support via our Advanced Access support contract hasn't been able to figure it out and honestly I find this need to be a very simple and likely common one. Having an asset database isn't just for inventory but also for accountability. Why wouldn't most want to have the Asset Owner showing up in a report? The Resource Type Association related to Asset Owners is already baked into Altiris 7.1 so I'd like to think there's a simple step I'm missing that prevents the report results from filtering out any asset records.