Jump to content

Search the Community

Showing results for tags 'query'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Hornbill Platform and Applications
    • OpenForWork
    • Announcements
    • Blog Article Discussions
    • General Non-Product Discussions
    • Application Beta Program
    • Collaboration
    • Employee Portal
    • Service Manager
    • IT Operations Management
    • Project Manager
    • Supplier Manager
    • Customer Manager
    • Document Manager
    • Timesheet Manager
    • Live Chat
    • Board Manager
    • Mobile Apps
    • System Administration
    • Integration Connectors, API & Webhooks
    • Performance Analytics
    • Hornbill Switch On & Implementation Questions
  • About the Forum
    • Announcements
    • Suggestions and Feedback
    • Problems and Questions
  • Gamers Club's Games
  • Gamers Club's LFT

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start








Website URL





  1. I sure this is a simple question, but not able to locate the location where you can setup the Asset Vendor, Product and Version drop downs for the 'Software' Asset Class. Any pointers? Cheers Martyn
  2. Can I request some further information on the change announced in ESP Build 3129 - "Added purging option to delete messages older than a certain age (Default 3 Years and maximum allowed up to 7 Years) in the Deleted Items folder". I presume this is disabled by default when the build is applied? Just confirm it only applies to the 'Deleted Items' folder only and not other folders in the mailbox such as 'Inbox Archive' etc. Cheers Martyn
  3. Hello All, I'm looking to implement the below query to run on a schedule to automatically move specific mail in our mailboxes to sent and deleted items; this is related to how we organize the mailboxes. -- Move Sent and Deleted emails UPDATE h_msg_messages, h_sys_organizations SET h_msg_messages.h_folder_id = h_sys_organizations.h_custom_11 WHERE LOCATE(CONCAT('- ', h_sys_organizations.h_organization_name, ' -'), h_msg_messages.h_msg_subject) > 0 -- Look for '- Name -'' only in subject AND (h_msg_messages.h_folder_id = 113 OR h_msg_messages.h_folder_id = 114) -- Support -> Sent & Deleted Folders AND h_sys_organizations.h_custom_11 IS NOT NULL -- Must have a valid folder AND h_sys_organizations.h_custom_11 <> 172 -- Ignore organisation Currently the script is ran manually however having a feature to run this automatically on a schedule would be ideal. Thanks! Josh M
  4. We have have been asked a question internally, wondered if you have any thoughts: Any information would be appreciated.
  • Create New...