Getting the table names of my assets when connecting to the k1000 database with sql-express DMS
Hello people.
The title says it all. It seems the k1000 doesn't list my asset tables according to
the titles I gave them when creating them.
Are they assigned aliases or something?
How do I know the name of my asset in the k1000 when I connect with a
database management system (SQL express in my case).
Could I get a rule guide on identifying my asset tables?
I have (as an example...) assets called "Company_computers", "company_printers",
"company_phones".
As always, thanks guys
Answers (1)
You just need to know that the main ASSET table contains all the basic details, but it links to the type of asset by ID and they are found in the ASSET_TYPE table and then depending on the asset type ID, for example devices are ID5, then there is an Asset type 5 table with additional field data in.
Simple, right?
So the Asset ID in the Asset table tells you the ID for the type, the ASSET_TYPE confirms the name you gave the asset type and the asset type table of that number contains the asset specific data for that type.
Good luck
