Return
-
Title
Unable to find ASSET_DATA_VIEW* after upgrading to 10.2 -
Description
Any queries to the Kace MySQL database involving the ASSET_DATA_VIEW will no longer work. -
Cause
These views have been removed as of version 10.2. This has been documented in the release notes which can be found here. -
Resolution
All the same information can still be found within the asset tables. You will need to re-build your MySQL queries to work with the tables that are available.
If you look at the: ASSET_FIELD_DEFINITION table, this should help you figure out which ASSET_DATA_1* tables to use to find the same information you were using in the views.