I have a custom data registry key that I am successfully pulling in from our Windows devices. The registry key is a string value which contains only integers from -3 to 300. By default the unmodeled data is being captured as an NVARCHAR. This is causing issues when trying to create reports and queries that use the greater than\less than logic.
I attempted to model the data and change the data type to INT. I left every thing else as default and added the data to a new table name. Upon completion, the table in the database and all the inventory data showed all values as 0. Essentially wiping out all of my captured data. I have since used the database doctor to clear out the attribute setting it back to unmodeled data. New scans are starting to repopulate the data as expected, but I am still left with the problem and need to get this set as an INT datatype.