/build/static/layout/Breadcrumb_cap_w.png

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


0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 1 month ago
Red Belt
0

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 

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ