Jump to content

Gareth Cantrell

Hornbill Users
  • Posts

    140
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by Gareth Cantrell

  1. Is there a history of search terms in the portal that is stored somewhere?

    I came across the table: h_sm_portal_search_history, however it seems it stopped recording data over a year ago (which in our case, was before we went live).

    We would really like to see what users are searching for in order to improve our catalogue and knowledge base, however without this data, we cannot even begin to analyse anything.

    • Like 1
  2. I have noticed that when a request is resolved or closed, the sub-status field is still showing in the employee portal.

    It would make it less confusing if this field could be removed from the display after resolution, much like it is in the agent view.

    As you can see from the below screenshot, it looks a little confusing when in "Awaiting Progress", albeit the request is already Closed.

    Screenshot_2024-04-29_at_15_22_16.png.6617d4d4df98ee46e55f33d9cb623880.png

  3. 1 hour ago, Berto2002 said:

    @Gareth Cantrell that is very useful to know and it makes sense as a design. So the only storage issue we may therefore have is the 245 versions of our generic workflow 🙂

    I have a handy little SQL query that can give you a rough idea of storage requirements for workflows (incl. autotasks) if you have access to the Database Direct tool:

    SELECT count(*) AS "amount", 
            "modified instances" as "type",
            sum(length(h_xml))/1048576 AS "size_mb"
    FROM h_bpm_instance
    WHERE h_xml is not null
    UNION
    SELECT count(*),
            "workflows (inc. all versions)",
            sum(length(h_xml))/1048576
    FROM h_bpm_processes

     

    • Thanks 1
  4. @Berto2002 from my perusals through the system, an instance of the workflow is not created for each request, rather, a link to the specific workflow version is stored in the bpm_instance table.

    If you make modifications to an in-process workflow instance, only then is a copy of the original version taken from the bpm_processes table and the modified workflow stored in the bpm_instance table.

    So, the only storage is each version of your workflow in bpm_processes and any modifications made to a live instance.

    For data retention purposes, I don't believe I've seen any option to delete historic versions of a workflow.

  5. We've had similar issues (dark red highlights) due to previous customisations of the following 2 settings (which worked fine in the old UI):

    • webapp.view.ITSM.serviceDesk.requests.list.unreadColour
    • webapp.view.ITSM.serviceDesk.requests.list.onHoldFontStyle

    Reverting these settings to defaults has solved the issues for us.

  6. Just to followup on this, I tried to synchronise the asset status from Certero, however the import utility is completely ignoring that field as well.

    It almost appears to be ignoring any integer fields in the source data.

    Also, the import utility completely ignores the software inventory for Apple devices, even though the configuration is nearly identical to the Windows configuration.

  7. It seems at some point, when saving workflows, random nodes had their result references cleared (you can't do this intentionally as you will get a warning and the workflow will refuse to save).

    Nodes with empty result references tend to behave normally if they are updating a request or locking/unlocking actions, however, it appears a suspend node without a result reference will never meet the condition to "un-suspend" and so the workflows end up suspended indefinitely.

    This is particularly the case where a suspend for resolution has had its result reference cleared and a resolution has been set.

    Manually resuming these is the only option, however, if any future node relies on the outcome of a suspend node, the workflow will fail.

  8. I have noticed a large number of in-flight requests suddenly missing the result reference in numerous BPM nodes.

    Some of these cleared result references are in stages not even reached yet.

    For example, this is from a process currently suspended in an earlier node, however once it reaches this particular node, it will fail as the result reference has mysteriously been cleared.

    image.png.d9fdcc61a98739de5380dac5f582e97e.png

    Finally, is there a bulk way to identify all requests with these issues and fix them?

    I really cannot be spending weeks going through all the in-flight requests to identify issues like this!!

  9. I'm trying to test an asset import configuration from Certero and am wondering why certain values refuse to update into Hornbill.

    Even though configured, the following attributes are not populating (even though data is present when I run the "Expand" query directly against Certero):

    • h_external_id
    • h_memory_info
    • h_max_memory_capacity

    ... and none of the Software Inventory is loaded at all.

    My test config looks as follows:

    {
        "KeysafeKeyID": 22,
        "LogSizeBytes": 1000000,
        "HornbillUserIDColumn": "h_attrib8",
        "SourceConfig": {
            "Source": "certero",
            "Certero": {
                "Expand": "ComputerSystemInventory($expand=OperatingSystem,ADUser($select=AccountName,LastLogonTimestamp)),ComputerSystemProcessorInfo,Object($select=LocationId,Status;$expand=Location,FieldDataItems($expand=Field)),AppleSystemSystemInfo,AppleSystemPhysicalMemoryArray,AppleSystemApplications($expand=AppleApplication),WindowsSystemBio,WindowsSystemPhysicalMemoryArray,WindowsSystemSystemEnclosure,WindowsSystemSoftwareProducts($expand=SoftwareProduct)"
            }
        },
        "AssetTypes": [
    	{
            "AssetType": "Laptop",
            "OperationType": "Both",
            "PreserveShared": false,
            "Query": "contains(ComputerSystemInventory/Manufacturer, 'Apple') and ComputerSystemInventory/ComputerName eq 'LONML11744'",
            "AssetIdentifier": {
                "SourceColumn": "{{.ComputerSystemInventory.ComputerName}}",
                "Entity": "AssetsComputer",
                "EntityColumn": "h_name"
            },
            "SoftwareInventory": {
                "AppIDColumn": "{{.AppleApplication.Name}}",
                "ParentObject": "AppleSystemApplications",
                "Mapping": {
                    "h_app_id":"{{.AppleApplication.Name}}",
                    "h_app_name": "{{.AppleApplication.Name}}",
                    "h_app_vendor":"{{.AppleApplication.Publisher}}",
                    "h_app_version":"{{.AppleApplication.Version}}",
    				"h_app_install_date": "{{.LastModified}}"
                }
            }
        }],
        "AssetGenericFieldMapping": {
            "h_name": "{{.ComputerSystemInventory.ComputerName}}",
            "h_asset_tag": "{{.ComputerSystemInventory.ComputerName}}",
            "h_description": "From Certero: {{.ComputerSystemInventory.Manufacturer}} ({{.ComputerSystemInventory.Model}})",
            "h_used_by": "{{if .ComputerSystemInventory.ADUser}}{{.ComputerSystemInventory.ADUser.AccountName}}{{else}}{{.ComputerSystemInventory.Username}}{{end}}",
            "h_room": "{{index (index .Object.FieldDataItems 4) \"Value\"}}",
            "h_external_id": "{{.ComputerSystemObjectId}}",
            "h_external_source": "Certero"
        },
        "AssetTypeFieldMapping": {
            "h_name": "{{.ComputerSystemInventory.ComputerName}}",
            "h_model": "{{.ComputerSystemInventory.Model}}",
            "h_manufacturer": "{{.ComputerSystemInventory.Manufacturer}}",
            "h_description": "From Certero: {{.ComputerSystemInventory.Manufacturer}} ({{.ComputerSystemInventory.Model}})",
            "h_serial_number": "{{if .WindowsSystemBio}}{{.WindowsSystemBio.SerialNumber}}{{else}}{{.AppleSystemSystemInfo.SerialNumber}}{{end}}",
            "h_mac_address": "{{.ComputerSystemInventory.MacAddress}}",
            "h_net_ip_address": "{{.ComputerSystemInventory.IpAddress}}",
            "h_net_computer_name": "{{.ComputerSystemInventory.ComputerName}}",
            "h_subnet_mask": "{{.ComputerSystemInventory.SubnetMask}}",
            "h_os_description": "{{.ComputerSystemInventory.OperatingSystem.Caption}}",
            "h_os_version": "{{.ComputerSystemInventory.OperatingSystem.VersionString}}",
            "h_cpu_info": "{{.ComputerSystemProcessorInfo.Model}}",
            "h_cpu_clock_speed": "{{.ComputerSystemProcessorInfo.ClockSpeed}}",
            "h_physical_cores": "{{.ComputerSystemProcessorInfo.Cores}}",
            "h_memory_info": "{{if .WindowsSystemPhysicalMemoryArray}}{{.WindowsSystemPhysicalMemoryArray.TotalMemory}}{{else}}{{.AppleSystemPhysicalMemoryArray.TotalMemory}}{{end}}",
            "h_max_memory_capacity": "{{.WindowsSystemPhysicalMemoryArray.MaxCapacity}}",
            "h_last_logged_on_user": "{{if .ComputerSystemInventory.ADUser}}{{.ComputerSystemInventory.ADUser.AccountName}}{{else}}{{.ComputerSystemInventory.Username}}{{end}}",
            "h_last_logged_on": "{{if .ComputerSystemInventory.ADUser}}{{.ComputerSystemInventory.ADUser.LastLogonTimestamp}}{{end}}"
        }
    }

     

  10. When trying to update an existing FAQ (in any service), we are getting an error about a missing "userLanguage" property:

    image.png.d03ee458456d3f341e24e78d05a41b69.png

    When trying to select one of our existing languages from the drop down, no options are presented so we are unable to save any changes..

    image.png.2f984f897bc1ce54a559a4f38c906ff2.png

     

    When adding a new FAQ, all the configured language options are given, however, once the FAQ has been initially saved, only the "default" language is displayed which means we cannot translate the FAQ into any of the other configured languages.

  11. 1 hour ago, David Hall said:

    @Gareth Cantrell

    Just checking is this happening every single time you use apply to email or on occasions?  Also are the emails in these cases correctly moving to the archive folder you expect?

    If that all looks correct then it might be better to log this with support so that we can take a look at your instance and diagnose the exact issue as I'm not currently able to replicate in our environment. 

    Kind regards,

    Dave

    You're right - this was happening for a different mailbox which didn't have the folder specified in application settings - not sure why it was working before this though.

    • Like 1
  12. 1 hour ago, Gareth Cantrell said:

    We are seeing the same issue and we're using the standard SR/IN reference format.

    image.thumb.png.6395ceb112797eb114d9aa57c2447f54.png

    On further investigation, it appears that the action did update the request multiple times, however the error about failing to apply the update is shown, even though successful.

  13. I have just noticed that the Entity Explorer has disappeared under all applications from the Advanced Tools & Settings section.

    Only the Platform Entity Explorer menu item is still available.

    Please could you urgently reinstate these as we rely on them for building our reports!

  14. We have been notified of some accessibility issues in all 3 modes (Light, Dark & High Contrast) in the new UI request list.

    In Light mode, links are rendered as blue text on a light blue background rendering the text almost impossible to read for users with colour blindness.

    In Dark mode, links in unread requests are also rendered in the same blue text on a blue background, also rendering these illegible to colour blind users.

    In High Contract mode, links un unread requests are rendered in yellow on a light yellow background and the rest of fields are rendered in white - this is illegible to all users.

    I have tried playing around with the webapp.view.ITSM.serviceDesk.requests.list.unreadColour application setting, and it has no discernible effect in any mode, except for light mode.

×
×
  • Create New...