Jump to content


Hornbill Developer
  • Posts

  • Joined

  • Last visited

  • Days Won


SamS last won the day on August 31

SamS had the most liked content!

Profile Information

  • Gender
  • Location
    Hornbill Offices

Recent Profile Visitors

1,790 profile views

SamS's Achievements


Mentor (12/14)

  • Very Popular Rare
  • Dedicated Rare
  • First Post
  • Collaborator
  • Posting Machine Rare

Recent Badges



  1. Hi @ljbrown, The eternal problem with "time spent" is what one means by that. 1) IF what is meant is the time between logging the request and the time it was resolved, then showing those fields and calculating the difference will give one the answer. This would also hold that if a request is logged on Friday 16:45 and resolved on Monday 09:15, the time spent will include the weekend. 2) IF what is meant is SLA time (i.e. the clock stops at Friday 17:00 and starts at 09:00 on Monday), then the h_fixtime field keeps track of the SLA seconds between logging and resolving (1800sec = half-an-hour). Naturally h_fixtime only has a relevant value if the call has actually been resolved with an SLA. 3) IF what is meant is how long someone has actually worked on the request, then the Timesheet Manager would keep track of that. There is probably another way of interpreting "time spent", so please let me know if I haven't covered your specific requirement.
  2. Hi @RIchard Horton, Behind the scenes, the Board Manager boards are located in the h_boardmanager_board, h_boardmanager_lanes, and h_boardmanager_card tables. There are no triggers that fire on modification of a card on the board, with exception of the Webhooks which would require a middle layer/glue application that you would need to create yourself - and it is a little overkill as ALL movement for ALL cards on ALL boards will trigger and not just the "few cards" you are interested in.
  3. Hi @aykut.boyraz, From what I can make out, the full BP definition(*) can be up to 4GB. (*) that is all the node configurations and links between them. The hard-coded/variabled text will be part of the node-definition. My previous estimate was (wildly) off - War and Peace will likely fit, as that only comes in at about 3Mb. I would advise against storing text of the W&P length, though - the text box to modify the text in is not made for easy management of such large texts.
  4. Hi @aykut.boyraz, Whatever you fill in in those fields (whether hard-coded or a variable name) will be stored together with full iBridge operation in a large text field - which is quite large (but I wouldn't think War and Peace would fit, though). So, hard-coded text will take up more space than a variable. WHEN the iBridge node is PROCESSED - i.e. when data is handed over to SN over the iBridge, and the variable is translated to actual text, then that part does not have any limits on it (as far as I can tell - again, it would be the receiving end which would instill the limit). So, if you fill in a Short Description of "Shall I compare... to thee" or have that information come in via a variable, then all of that will be sent to SN - which in turn might reject/truncate it.
  5. Hi @aykut.boyraz, First: Which iBridge operation are you talking about? Second: Any limitations are more than likely imposed by the RECEIVING end. Third: what limitations are you specifically talking about? Amount of characters? Character CodePages?
  6. Hi @Mark (ESC), You should be able to run the script with the -forcerun parameter - that should close off the old log. Another issue might be that the API key has expired, you might want to double-check that - as well as perhaps the local log file.
  7. Hi @Martyn Houghton, The Hornbill Export Tool uses: reporting:reportRun reporting:reportRunGetStatus reporting:reportRunDelete
  8. Hi @Kevin Kennedy, If you look at the history of the page, you will realise you didn't miss it.
  9. Hi @Kevin Kennedy, The following wiki page should answer your questions: https://wiki.hornbill.com/index.php?title=XMLMC_API_Quickstart
  10. Hi @BillP, You might want to try the following instead ( https://api.hornbill.com/xmlmc/apps/com.hornbill.core/Task?op=getEntityTasks ): <methodCall service="apps/com.hornbill.core/Task" method="getEntityTasks"> <params> <objectRefUrn>urn:sys:entity:com.hornbill.servicemanager:Requests:SR00######</objectRefUrn> <counters>true</counters> <taskStatus>1</taskStatus> <rowstart>0</rowstart> <limit>10</limit> </params> </methodCall> (naturally, modify URL to your own instance)
  11. Hi @s_devoy, I was referring to the settings (via the Administration area). The tool is specifically to import translations to Services (en masse). For just a rename of a colulmn, you can do it manually. Admin > Appications > Service Manager > Translations > user.view.asset.computer.h_public_ip_address
  12. We are using the following endpoint: https://__instance__.service-now.com/api/sn_customerservice/case According to the API documentation, the account must have the csm_ws_integration, sn_customerservice.customer, or sn_customerservice.consumer role
  13. Hi @s_devoy, Yes, you CAN rename it - just change the label using the translation tool within Sevice Manager (translation key: user.view.asset.computer.h_public_ip_address ). The potential downside is that it will be renamed for ALL of the assets of that particular generic (computer, mobileDevice, pritner etc), not just a particular asset (sub)type (eg Desktop, Laptop).
  14. Hi @Adam Toms, I will add "removal of all roles for listed users"-functionality just below "removal of all roles of archived users" on the list. I might create a separate utility for it - to keep it at arms length from data preserving functionality. I will not implement a "remove all roles for all users"-functionality - only because no one would be able to log in to undo the damage. Yeah, this is going to be a separate utility - so it cannot be accidentally confused/triggered with the data import.
  15. Hi @LouiseT, As it happens there is currently an undocumented (read: unTESTED) feature within the DB Asset Import tool (it's been in there since v1.16.0) which allows one to connect the imported asset to a Supplier and/or a contract. It would be setting field names for "DBSupplierColumn" and "DBContractColumn" (respectively) within the "AssetIdentifier"-section - configured in the same way that "DBColumn" is defined. In a couple of weeks it will likely be tested (possibly tweaked) and documented and officially "released". Please look out for the next version (i.e. later than v2.0.0). Although if it works for you in v2.0.0, then please let me know - I can skip a step in testing;-)
  • Create New...