PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 11/03/2007 12:42 AM by  Rod Weir
Custom Fields defined against assets
 2 Replies
AddThis - Bookmarking and Sharing Button
Sort:
You are not authorized to post a reply.
Author Messages
Daryl Quadros
New Member
New Member
Posts:2
Points:4


--
11/02/2007 5:14 AM
    Hi,

    I'm trying to pull together a report that contains a set of specific assets and which clients they are linked to. In this report, I also need to pull out a specific custom field that is defined against the asset - in which tables can I find the custom field information and how is it linked to the assets?

    Thanks in advance,
    Daryl.
    Daryl Quadros
    New Member
    New Member
    Posts:2
    Points:4


    --
    11/02/2007 9:11 AM
    Never mind,

    i've managed to pull the detail through by modifying the view qryAssetConfigurationDetails
    and copying/inserting one of the existing statements modified as follows:

    CASE tblSystemCodes.Caption WHEN '' THEN detailValue ELSE NULL END

    Daryl.
    Rod Weir
    HelpMaster development team
    Helpdesk Hall of Fame
    Helpdesk Hall of Fame
    Posts:538
    Points:968


    --
    11/03/2007 12:42 AM
    Hi Daryl,

    Good to hear that you've figured it out. You can also find custom asset information in the "qryCrossTabCustomDetails_Asset" view in the database. This view is a cross-tab query that displays all of the custom information is a very easy-to-use format. If you like you can link that view (or a copy of it) into any of the reporting views. Reporting view are those that are prefixed by "rpt".

    Often it's better to query information via a view rather than the base table. The advantage of using a view is that many of the links (if not all) are already defined and all you have to do is reference the view in your reporting solution.

    Hope this helps. Let me know if you need any further help and I'll be glad to help.

    Best regards,

    Rod
    HelpMaster development team
    Check out the HelpMaster roadmap
    You are not authorized to post a reply.


    Allow staff to view all jobs, all skillgroups by Rod Weir in Installation, configuration and upgrading with 0 replies By default, staff members can only view and action jobs that are assigned to the skillgroup(s) that the staff member belong to.  Fine-level contr...

    Building knowledge management and KCS into the workflow by Rod Weir in Using HelpMaster with 0 replies Here's a workflow idea to assist with improved knowledge base articles and knowledge management / KCS As part of a support workflow, build into...

    June 2019 release now available by Rod Weir in Announcements with 0 replies A new release of HelpMaster is now available.  This release builds upon features and stability, particularly in the workflow, and change manageme...

    Workflow email object - email account by Rod Weir in Using HelpMaster with 0 replies The up-coming release of HelpMaster will have a lot of workflow improvements.  One of these is in the email object.  It is now possible to c...

    Change Management by Rod Weir in Using HelpMaster with 0 replies Change Management in HelpMaster is a relatively new feature that is evolving rapidly.  Based off live-use in small and large departments, our &qu...

    Allow staff to view all jobs, all skillgroups by Rod Weir in Installation, configuration and upgrading By default, staff members can only view and action jobs that are assigned to the skillgroup(s) that the staff member belong to.  Fine-level contr...

    Building knowledge management and KCS into the workflow by Rod Weir in Using HelpMaster Here's a workflow idea to assist with improved knowledge base articles and knowledge management / KCS As part of a support workflow, build into...

    June 2019 release now available by Rod Weir in Announcements A new release of HelpMaster is now available.  This release builds upon features and stability, particularly in the workflow, and change manageme...

    Workflow email object - email account by Rod Weir in Using HelpMaster The up-coming release of HelpMaster will have a lot of workflow improvements.  One of these is in the email object.  It is now possible to c...

    Change Management by Rod Weir in Using HelpMaster Change Management in HelpMaster is a relatively new feature that is evolving rapidly.  Based off live-use in small and large departments, our &qu...

    April 2019 release now available by Rod Weir in Announcements A new release of HelpMaster is now available.  This release builds upon features and stability, particularly in the workflow, change management a...

    February 2019 release now available by Rod Weir in Announcements A new release of HelpMaster is now available.  This release builds upon features and stability, particularly in the workflow and web portal. F...

    RE: Job Templates get a new config option for web-based jobs by Rod Weir in Web interface, client self-service and remote access Just further to this topic....if using workflow to log a new job from a job that already contains control sets, and you are using the option to transf...

    November 2018 release now available by Rod Weir in Announcements A new release of HelpMaster is now available.  This release contains lots of fixes, performance tweaks, improved workflow capabilities, improved ...

    Quick Re-assign from an "Unassigned" skillgroup queue by Rod Weir in Using HelpMaster The upcoming November release of HelpMaster contains a small, but very handy new feature. When a job is assigned to the "Unassigned" queu...