TrevorKillick

@yelyah.nodrog You can use the Hornbill iBridge to integrate with Service Now, more details can be found on our wiki: https://wiki.hornbill.com/index.php/ServiceNow Kind Regards Trevor Killick

@Lyonel Apologies for not getting back to you regarding this, we discussed this internally and agreed this is something we will add in the future however it's not currently in our 90 window. One thing you can use for storage usage on entities is the following query: select count(*) as h_total_files, sum(h_size) as h_total_size,h_owner_name,h_raw_dav_store_id,h_owner_type from h_cafs_ext_details group by h_owner_name,h_raw_dav_store_id,h_owner_type If anything changes around progressing this forward I will reply back. Kind Regards Trevor Killick

@Gemma Morrison The role you need is MyLibrary User . Kind Regards Trevor Killick

@Martyn Houghton Visibility levels are described here: https://api.hornbill.com/_types/activityVisibilityType Kind Regards Trevor Killick

@Stuart Torres-Catmur Not at all the pricing model is completely unchanged, Super User Role would give you access to any application including licenced applications without the direct need for a licence providing a back door of sorts to bypass our subscription model. The changed prevent this from being abused in the future by removing access to applications being automatically assigned to the Super User Role, the effect of which for any user that had this role was visibility of some applications would be restricted as the correct roles were never needed to be given as Super User Role gave them full access to everything. I hope this clarifies things for you. Kind Regards Trevor Killick

@Stuart Torres-Catmur @RyanMesser Please accept our apologies for the inconvenience and lack of communication regarding the impact of this change, to clarify the issues with super users logging in and now super users losing full access to all applications stems from us tightening our restrictions around licencing and we clearly hadn't anticipated the level of impact this would lead to for our customers. I will raise the concern regarding lack of communication up the flagpole. Kind Regards Trevor Killick

@SJEaton You will need the Services Manager role. Kind Regards Trevor Killick

@SJEaton One of the recent changes from the platform removed the automatic assignment of all application rights to any user with a Super User role, this is what has happened here you need to assign your self the relevant Service Manager roles, I will get someone from the development team to advise on the exact role for this. This should not affect any other user than those who had the Super User role assigned. Kind Regards Trevor Killick

@Martyn Houghton The team have advised that the following while not very efficient would give you emails sent from a request: h_content LIKE 'Email To: %' Kind Regards Trevor Killick

@Martyn Houghton Yes h_type = 'Email' should give you any emails applied to a request, your right there is no distinction between in and outbound email, I have raised the requestion with our development team to see if they have any ideas. Kind Regards Trevor Killick

@Joyce Perfect thank you, I will let you know what our investigation turns up. Kind Regards Trevor Killick

@Martyn Houghton The table is h_buz_activities and you can join on h_target where its equal to the activity stream id stored against the request, h_itsm_requests.h_activity_stream_id. Kind Regards Trevor Killick

@Joyce @HGrigsby Can you provide the report definition for one of the affected reports please, there is a download button in the top right you can post or PM me the text from inside the file and I will investigate this issue further. Kind Regards Trevor Killick

@samwoo The Actions refer to if the account is being created or updated if Create Only is only applied to new users, Update only is applied to users that already exist, From what I remember Roles are not destructive, the only destructive import property we have is around organisation when you have only one assignment enabled then any other organisations of that type are removed. Kind Regards Trevor Killick

@samwoo Awesome, glad its all working as expected now. Kind Regards Trevor Killick

@JBasey Does the following help: Kind Regards Trevor Killick

@samwoo 3.1.1 is on GitHub for you to give a try, https://github.com/hornbill/goLDAPUserImport/releases/tag/v3.1.1 Kind Regards Trevor Killick

Give me 5 to do a GitHub release.

@samwoo So when it does a regex match at the moment it returns the Last match which I think is wrong so I am going to change this to return the first match that has a value, which means you can use the regex \bOU=(.*?), Which will return OU=Housing, that can then have OU= and the last , replaced. If this makes sense ill do a quick build now for you to test. Kind Regards Trevor Killick

@samwoo Just to another replace using department2 is the value and replace OU= with empty? Yout can chain as many of these actions together as you need.

@samwoo Can you replace ,OU=Specialists,OU=Group,OU=Parent,DC=company,DC=gov,DC=uk with empty then match on OU=* ? Kind Regards Trevor Killick

@Harry I have checked your instance and you shouldn't have been affected by the underlying issue we have here, the fix has not been released to live yet we are still working on it. Kind Regards Trevor Killick

All, Application Subscription option in the Administration tool allows you to see every user currently taking up a licence as well as manually remove and add a user something you shouldn't need to do on a day to day basis. When you add an application role with a user privilege level to one of your co-workers a licence for that application is taken when they next log in. Yesterday we had a bit of an issue with this where users with a Super User role were taking up licences on applications they were not directly assigned to, this is something we are currently working on resolving, we did as a result of this notice incorrect number of licenced users against various applications. @Aaron Summers in your specific case the subscription utilisation shown in the main users list refers to Core "Collaboration" licences this is the base licence every Full user needs to log in, the usage against application subscription for Service Manager is the number of licenced users of the application currently assigned these are needed for each for the Core users to interact with paid for applications. The case of the applicable subscription usage being higher than the core usage is odd we would need to double check on this if @Victor has a login to your instance I can have a nosey about and see why they are not matching. Kind Regards Trevor Killick

@Dan Munns The default variables won't map inside the HTML you will need to use BPM variables from a get request details node in &[] not {{}} Kind Regards Trevor Killick

We have applied a workaround to all known affected customers if anyone else is affected please reply here or raise a support request with @Victor and we can apply the workaround ASAP. We are still working on the underlying issue. Again please accept our apologies for the inconvenience caused this morning. Kind Regards Trevor Killick