/build/static/layout/Breadcrumb_cap_w.png

Asset Linking

K1000 6.0

So, I'm a support agent for my company and I'm working through kace. I have created asset tables that contain license keys that are dependent on user name. However, some users may have several keys depending on the various software that they utilize for their work. In order to normalize data and also make it easier to track, I decided to split this data into two tables. One Asset table (type) would carry generic user and machine data with standard licenses such as Office or Adobe. While the other table would carry keys for software like Visio, Project, etc.

My question is, is there a way to link these two tables together either by machine name or user? Such that if I in an asset table were to click on the username, it would take me to the first detailed page of the user with the various keys and then below contain a link that would lead to the second table which contained the specialized software keys? I know there is a type field called Link which I can use to point towards the page which contains the other keys, but was wondering if there's an inherent relationship type or ability within KACE that allows an admin to input in user data and have it be linked implicitly?

Thanks for your help.

0 Comments   [ + ] Show comments

Answers (1)

Posted by: h2opolo25 9 years ago
Red Belt
0
You would need to create the link in the asset fields. The SQL database needs a foreign key in it's table to be able to link it to the other table.
 
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