K1000 Newbie here: After an asset is renamed, how do you locate the asset via service tag in the machine table?
I'm not even sure if I'm asking this question the right way. Basically I have an asset from the ASSET table with ID 188. I cannot link this ID with anything in another table to find the original service tag ID. I'm fairly new to K1000 and any help would be appreciated. I've located the original order number but unfortunately so many laptops were ordered on that day, I can't narrow down which one is the one I'm looking for. I feel like I've searched and searched for answers but there may not even be a way to do what I want.
Please log in to answer
Posted by: chucksteel 4 years ago
So, there are a few things going on here that you should know.
First, the ASSET table contains basic information on all assets in the database, regardless of type. The computer asset type ID should be 5 so if this is a computer then that will be the value in the ASSET_TYPE_ID column.
Next you should check your asset type matching settings for the computer asset type. In the admin console browse to Assets, Asset Type, Computer. Check the settings for Matched Inventory Field and Matching Asset Field. In our environment those are BIOS_SERIAL_NUMBER and NAME, this matches the computer serial numbers to the name of the asset. If that is how your environment is setup then your asset names should be serial numbers (what you might be calling service tag ID).
Once you know how you are matching the fields you know how to relate assets in the ASSET table to computers in the MACHINE table.
The other possibility here is that what you are calling "Service Tag ID" is a custom field in your computer asset type. If that is the case, then that data will be in the ASSET_DATA_5 table (for computers). You can find the field ID in the ASSET_FIELD_DEFINITION table.
Hopefully this is enough to get you started on finding what you need.