Jump to content

Steve G

Hornbill Developer
  • Posts

    746
  • Joined

  • Last visited

  • Days Won

    30

Posts posted by Steve G

  1. Hi @Cristian,

    This version of the utility was released back at the start of August, so it's unlikely that the 4.1.1 release caused the above issue. I've not been able to replicate your issue, but on reviewing the code it appears that this issue could be environmental, and caused by a problem with the HTTP proxy setting on the machine running the import.

    I've made some changes to better handle that eventuality, and to output more useful debug information to the log in the event that this doesn't fix your issue, so we'll have more information to assist with the fix.

    v4.2.0 is on GitHub now:

     

     

    Let me know how you get on with this.

    Cheers,

    Steve

    • Thanks 1
  2. Hi @Martyn Houghton,

    The import utilities have been made closed-source as part of a wider strategy around security, API endpoint availability, and import usability improvements. We can't provide the code I'm afraid, but we could (and should, to be fair) add Shared With capabiities to the tool. I'll have the team take a look and get back to you.

    With regards to the Wiki, my team are in the process of porting the data imports documentation from the wiki over to the new documentation platform, and references to open source in the content will not be ported.

    Cheers,

    Steve

    • Thanks 1
  3. Hi @DRiley II, hope you're well!

    Integrations into Hornbill from other platforms can only be done using the Hornbill API - we don't currently provide listener/target services for external webhook requests. There are lots of platforms which do provide webhook targets, that will allow you to make API calls into Hornbill when those are triggered though (Zapier, Azure Automations, Google Cloud Run, etc etc).

    Hope this helps,

    Steve

  4. Hi @RichardD,

    The matchScope input param is your friend here, with a value of any (basically an OR) and each value set as its own exact match search filter, as follows  :) 

    xmlmc.AddParam("matchScope", "any");
    xmlmc.AddParam("searchFilter", new List<XmlmcParam>() {
       new XmlmcParam() { Name = "column", Value = "h_status" },
       new XmlmcParam() { Name = "value", Value="status.onHold" },
       new XmlmcParam() { Name = "matchType", Value="exact" }
    });
    xmlmc.AddParam("searchFilter", new List<XmlmcParam>() {
       new XmlmcParam() { Name = "column", Value = "h_status" },
       new XmlmcParam() { Name = "value", Value="status.open" },
       new XmlmcParam() { Name = "matchType", Value="exact" }
    });
    xmlmc.AddParam("searchFilter", new List<XmlmcParam>() {
       new XmlmcParam() { Name = "column", Value = "h_status" },
       new XmlmcParam() { Name = "value", Value="status.new" },
       new XmlmcParam() { Name = "matchType", Value="exact" }
    });

    Cheers,

    Steve

    • Like 1
  5. Hi @RichardD,

    searchFilter is unbounded, as per the API reference guide, so you can simply add another searchFilter element to the request as so:

    elem = xmlmc.add_param("searchFilter")
    elem.add_child("column", "h_name")
    elem.add_child("value", "Asset00")
    elem.add_child("matchType", "wildcard")
    elem = xmlmc.add_param("searchFilter")
    elem.add_child("column", "h_class")
    elem.add_child("value", "computer")
    elem.add_child("matchType", "exact")

    You can use print_params() to review the request payload params before it's sent to Hornbill too, as you can see in this really basic example:
    image.png

     

    Hope this helps,

    Steve
     

    • Like 1
  6. @Gareth Cantrell This work is still ongoing, but we have deprecated the old Azure User & Group operations (that required the full Microsoft admin permissions) and replaced them with operations that require much fewer permissions to operate. Details can be found on the Hornbill wiki.

    As and when more operations are replaced to use the new endpoints and fewer scopes, they will be published on the Announcements forum when released.

    Thanks,

    Steve 

  7. Evening @samwoo,

    I've just tested updating those custom fields using the Requests:update API, and it seems to be working fine:

    image.png

    On the right is the call I made in Postman to the API, with the XML payload & JSON content for the custom fields, and the left is the fields as populated by this call, so I'm not sure why it's not working at your end. 

    Looks like you're using the HornbillAPI module, so it'd be worth outputting the content of the Get-HB-Params cmdlet to see what is actually being sent (before the Invoke-HB-XMLMC call, as that clears the params), should help with debugging.

    Let me know how you get on.

    Cheers,

    Steve 

  8. Hi @SteveJM,

    The role you need is Hornbill Service Manager Integrations. It appears that this role was missed from the Data Import Guides, I'll get that corrected.

    Re: the KeySafe Key ID, as per the documentation, if you're importing from CSV files then KeySafe is not used and the value should be 0 or the property can be removed entirely from the configuration:

    image.png

    Thanks,

    Steve

    • Thanks 1
  9. Hi @Rob Gething,

    We've found and fixed the issue, this will be in a platform update during the usual release cycle so please keep an eye on the announcements forum for it appearing in the release notes.

    As a workaround through, before you attempt to do the PUT, have your script make a call to one of the Hornbill service APIs to properly generate a session using the API key to ensure that the dav/session endpoint is available. I'd recommend calling the session:getSessionInfo API, and just disregard the response before performing the PUT request.

    Cheers,

    Steve

  10. Hi @billster,

    We do have a number of Hornbill to SolarWinds integrations in iBridge - check out the Premium Integrations section of the Solution Center on your instance:

    image.png

     

    To get SolarWinds to log/update/resolve incidents in Hornbill you would most likely need to use the Alerts HTTPS function within SolarWinds, and the Hornbill APIs to raise the tickets. We are not SolarWinds experts though I'm afraid so that question would need to be directed to your SolarWinds administrator.

    Hope this helps,

    Steve

  11. Hello everyone,

    The latest update of User Import - Database (v4.0.0) has been released to live and is now available for download on GitHub.

    The change log for this update is as follows:
     

    Features

    • Removed the requirement for plain-text API Key and Instance ID from being hard-coded in the config files - they are now encrypted client-side
    • Removed the ability to store database credentials client-side, and instead store them securely in KeySafe
    • New command-line argument (-creds=true) to check that that API Key has been entered correctly

    Changes

    • Included conf.json example in release archive
    • Closed-source the tool, marked existing repo as private, added auto-publish to a new public repo: hornbill/user-import-database
    • Improved logging output
    • Updated GitHub workflow actions for posting release notes to the Hornbill community forums and internal workspace
    • Removed support for macOS and Linux as we're using Windows cryptographic APIs to encrypt/decrypt the authentication details
  12. Hello everyone

    The latest update of Asset Relationship Import (v2.0.0) has been released to live and is now available for download on GitHub.

    The change log for this update is as follows:

    Features

    • Removed the requirement for plain-text API Key and Instance ID from being hard-coded in the config files - they are now encrypted client-side
    • Added command-line argument (-creds=true) to check that that API Key has been entered correctly
    • Moved the storage of the client-side database connection credentials into keysafe

    Changes

    • Closed-source the tool, marked existing repo as private, added auto-publish to a new public repo: hornbill/asset-import
    • Removed support for macOS and Linux as we're using Windows cryptographic APIs to encrypt/decrypt the authentication details§
    • Added code-signing to build process
    • Added publish and release note automation in GitHub Workflow
×
×
  • Create New...