/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Is it possible to access the Asset field

08/24/2020 159 views

Is it possible to access the asset field in a custom rule 

I cant find the field listed anywhere. 



0 Comments   [ + ] Show comments

Comments


All Answers

0

Yes, the asset tables are accessible. I recommend using a tool like MySQL Workbench and connecting to the database to view the tables.

ASSET - this is the main table for assets and includes the asset names and data common to all asset types.

ASSET_DATA_x - where x is the asset type ID for each type of asset. Most of the data about an asset is stored here. The column names are generated dynamically and will be in the form FIELD_y where y is the ID of the field.

ASSET_FIELD_DEFINITION - contains the field definitions for the assets, handy to use as a reference to figure out the column names in the ASSET_DATA_x tables.


Answered 08/25/2020 by: chucksteel
Red Belt

0

Asset relationships represent non-hierarchical relationships between assets due to replacements, upgrades, or other circumstances. Relationships appear in the Primary Assets and Related Assets related lists on asset records.

Answered 08/25/2020 by: prince0052
Yellow Belt

  • Thanks. That link between a HD ticket and the asset only works if the data is entered into the one and only asset field. We have other fields (e.g. Vehicle Asset) which provides a selection list based on that asset type. However when you go to the vehicle record there is no related HD ticket. If I enter the vehicle record into the Asset field that comes with Service Desk it creates that link. The reason we are using a unique asset field for Vehicles is that we want it only to list the vehicles (not the 25000+ assets). There is no way to build a rule to select only the vehicle asset type in the Asset record (If there was I would use the default Asset field)
    • Are you using the asset field for another purpose for those tickets? If not, then you could create a rule that sets the asset field to the asset selected in your vehicle field.
      • Thanks Chucksteel. I have managed to do that but the Fleet number field (which is using the Vehicle asset name) when I use a rule to put it into the Asset field it seems to try and look for the unique asset id. E.g. if the Fleet number is 157 but the unique asset id for that record is 25045. When I get the custom rule to put the value (157) into the Asset field it seems to go and find the asset with a unique Asset id of 157.
      • Your rule needs to be something like this:
        UPDATE HD_TICKET
        SET ASSET_ID = (SELECT ID FROM ASSET WHERE NAME = HD_TICKET.CUSTOM_FIELD_VALUEx and ASSET_TYPE_ID = y)
        WHERE ID in (<TICKET_IDS>)

        The x in CUSTOM_FIELD_VALUEx needs to match the value of the custom field column in the database, these are zero indexed, so custom field 1 is CUSTOM_FIELD_VALUE0.

        The y in ASSET_TYPE_ID = y is the ID of the asset type for your vehicle assets.
This content is currently hidden from public view.
Reason: Member has been banned from the site SPAMMER For more information, visit our FAQ's.
0

These ways include bookmarking assetsaccessing assets from the History node, tagging ... In the asset's Create view, in the Name field, enter a name for the asset. ... The following characters are not allowed: single quote ('), double quote (") 

Answered 08/29/2020 by: prince0052
Yellow Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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