Debuging custom report fields in ASSET_DATA_VIEW_Computer_Accessories view
Trying to debug a custom report that pulls data from the ASSET_DATA_VIEW_Computer_Accessories view. In that view there is a field "OWNER_ID," and also a field called "User" that do not match in all cases
the Field Data in "User" matches with the settings > user > associated assets, but I'm trying to work out where "OWNER_ID" is defined, or should i just run an update query to set User > OWNER_ID, or are they supposed to be the same and i've just found another bug in the system?
You may have just found out that this is the difference between a Device Asset record, where User is applied via the inventory and a rule, and any other kind of Asset Type, whereby ownership is defined by adding in a User custom field into the Asset type.
So you may need to select the right one depending on the asset type, or select both for a combined report
A View is an object created with Create View that when referenced produces a result set. A view acts as a virtual table.
For a custom report, you should be using references to the actual DB tables and using the appropriate joins.
What is the asset, user data you are interested in the report output?
If you are not familiar with SQL, our Professional Services group can give you a quote you for assistance.