SamS

Hi @Kevin Kennedy, The error message suggests that the DB connection is not functioning (i.e. it is already beyond the "Sites" bit). I would expect the "Database" section in the configuration file to have the "Authentication" set to "SQL" of "Windows". I'd also double-check the settings in KeySafe for the ID given.

Hi @Berto2002, Is there any way of perhaps getting data from the Azure/Teams side? i.e. Has the API call reached Teams? and what happened there? From your results, there WAS some processing on the MS side as a message ID of 1673879753495 was returned!

Hi @Kevin Kennedy, The utility needs access to the SCCM database, it does NOT need to reside on the SCCM server itself. The utility "talks" to Hornbill over HTTPS (by default port 443). IF you are using proxy servers, then you would need to look into using the environment settings HTTP_PROXY & HTTPS_PROXY (details should be in the utilities' documentation on the wiki.

@Rob Gething Having had a look in the code, it appears that a CatalogItem ID of 77 and a Service ID of 5 are the defaults in the script which should have been replaced by the PowerShell script - with the IDs given under the "I Need Help"-topic. Could you please confirm you imported/uploaded the RESULTING HornbillPVA_v1_2_0_0.zip file (assuming you are using the latest script (as of this writing)) and NOT the template HornbillPVASolution.zip file?

Just to be clear, the correct Service ID can be obtained from the URL bar and the Catalog Item ID can be grabbed by hovering over the Catalog Item in question. Please note that he Catalog Item needs the BP and IC configured.

Hi @Sam P, The Reporting section will only (currently) allow you to select a SINGLE field to group on - whereas you want to effectively group on two columns (Team & Type). That being said, it IS possible to sneak in the grouping on a SECOND column - within the "Output Formats"-section. The catch: the results are in a chart and not a number. In your case, you would want to set up a "Grouped list/count of data" report, "Group By" the Team on the "Ordering"-section and finally, in "Output Formats", select the Request Type field in the "Group Section Chart Options" (selecting a Chart Type in the process).

Hi @Martyn Houghton, I'll add it to the list, but I wouldn't expect it added before Q2 of 2023.

Hi @QEHNick, The withinfix field is only valid/populated once the timer is marked (i.e. very likely at resolution/closure in the BP). Prior to closure it's like Schrödinger's cat.

Hi @Sam P, Once you start linking to a table with more than a single record linked to it, then you get that behaviour. With a "JOIN" you are literally asking for every instance where the IDs match, so if a request has 15 questions against it, then you would see 15 lines with the same/repeated request data and only differing in the parts with the questions and answers. The Questions table is the likely culprit here. I suspect that two of your questions contain a question with the blanked out phrase in the question. Might I suggest that you filter on the form ID and Question ID instead? They would match the form and fields names set in the Intelligent Capture. IF you want to have BOTH those answered questions ON THE SAME LINE as the call data, then that is also possible. For that you will need to use a LEFT JOIN to the questions table FOR EACH question/answer you wish to show. That being said, there is currently a minor bug(*) in the way fields can be selected to show in the end-result with the LEFT JOIN method. IT should be fixed within 2 weeks. (*) it is already in line for deployment, so expect it working within a fortnight.

Hi @Alisha, Yes, you should be able to set up an API key in your keysafe with the instance details you are logged in and use that in the BP for testing (or even for LIVE purposes). I've just confirmed it works on my (test) instance. What error(s) are you getting? Are you sure that the API key belongs to an account which is able to do the actions you are trying to do? Also: What are you trying to do? As of this writing, the Hornbill iBridge offering does not include nodes to request customer data - there is some request details under Common / Get Request Details (within Service Manager).

Hi @QEHNick, I am very unsure what you are attempting to do with either the query and within the context. Context: by the looks of it you are counting trying to count a tables instead of counting over a field which is contained in table/sub query?. Query: 1) your query doesn't result in what you are counting over 2) the subquery in your query appears to be used as a field even though it would result in a substantial amount of results. That being said, I doubt it is possible to use a subquery as a field even if the subquery results in a single result. Might I suggest you contact Care and use some credits for some assistance? Alternatively, there are a few advanced SQL topics covered in : https://www.w3schools.com/sql/

Hi @Hiten, The area you are looking for is the "Service Portfolio" - within there you have Services and within those - per request type - the "Catalog Items". https://wiki.hornbill.com/index.php?title=Services_Request_Configuration

Hi @Paul Alexander, The following should do the trick: https://wiki.hornbill.com/index.php?title=SQL_User_Import

Hi @Andrew Tasker, There are few online resources which I can direct you to: https://wiki.hornbill.com/index.php?title=Integration For traffic into(*) Hornbill, the topic "Web Services API" is of interest under: Advanced Integrations For traffic to the third party: iBridge for which new candidates can be suggested via: https://community.hornbill.com/forum/139-hornbill-ibridge-integration-requests/ To aid the developers, I would suggest to include a link to the API of the third party tool (which in this case appears to be: https://developer.servicechannel.com/basics/introduction/overview/ ) (*) please note that you already have the ability to use AutoResponder to auto log/update emails please see this and related articles.

Hi @Hiten, There is a h_datelastmodified field in the h_itsm_requests table. I believe it is "Requests->Data Modified" in the entities view.

Hi @Hiten, I appreciate that the calculation of "time since last update" can be done via Database Direct, but my 15/06 statement that it can NOT be done is refering to the regular Report interface - i.e. the one to be used for scheduling reports. It would require a new feature of calculated fields. The BEST one can do is just a list of calls with the "last updated on" field visible among the other fields you wish to show.

@Frank Reay, The Azure Import utility is not a generic user update utility. Such ("update all users with ..."-)utility does not exist (or, perhaps better stated: is not one we have released on github). You, or others so inspired are welcome to fork our tools on github and adapt them for your own purposes. In the meantime, the DB Import Utility is the closest we have to what you are looking for, you will just need a list of User IDs in a csv/text file - BUT I would suggest that the Azure utility is probably the quickest/easiest for you to implement -i.e. just run and "yes", connect to Azure in the process to get the list of user ids from there.

Hi @Frank Reay, A combo of: AzureConf.Search = "users" with AzureConf.UserFilter should work - they are highlighted in the "Filtering"-section : https://wiki.hornbill.com/index.php?title=Azure_User_Import

Hi @Frank Reay, Firstly, you are right in assuming that OnlyOneGroupAssignment set to true should limit the amount of groups to a single of that type (dept, division etc) to a particular person. On order for that to work, the old connection would have to be removed. The statement about not removing any department connections is a little dated (obviously predates the OnlyOneGroupAssignment-functionality addition). I would suggest you try out an import with a couple of accounts you know the configuration of in both sides (Azure & Hornbill) to check that it works as expected.

Hi @Jamie A, If you would like some consultancy, please get in touch with Customer Success ( https://success.hornbill.com/hornbill/ ) who can provide you with your options.

Hi @billster, ASSUMING you are using this in the BP, there are a couple of things you need to know. The engine behind the scenes is ECMAScript and the RegEx you are likely going to want is: ([.\s\S]*)^=====respond to email above this line=====$ With the following flags: gm

@nasimgFYI

@QEHNickit is a clone/fork of MySQL - by the creator of MySQL after he sold MySQL to Oracle.

Hi @QEHNick, The hint was here: https://wiki.hornbill.com/index.php?title=Hornbill_Cloud_and_Platform - under the header: Instance Storage Quota

@Paul Alexander The table h_sys_accounts_api_keys appears to be available in the Reports section.