Jump to content

Frank Reay

Hornbill Users
  • Posts

    293
  • Joined

  • Last visited

  • Days Won

    5

Posts posted by Frank Reay

  1. Many thanks @Met. This is similar and achieved the same goal

    ^(.|\s){0,255}$

    Inside the () (standard brackets) means

    . (anything except a line break)

    | (OR)

    \s (whitespace character which includes space, tab, carriage return)

    ie basically anything! Which I think is the same as [\s\S] in square brackets

    I really don't like Regex!!!!

  2. In some of our Contract fields we have a Regex like this:

    ^(.|){0,255}$

    This is meant to limit the number of characters to 255. If it fails (ie more than 255 characters) then we output an error message. That is all good.

    BUT some of our users have found that if they enter 1 character, then return and then enter another character - they get the error message. see below

    image.png.d70c2600585802d6111a622242d1ba9a.png

    I don't understand this or how I stop it. Can anyone help please?

  3. Yes that is sort of what you put in the Command Line but at the front you need put in the location of the file (so something like c:\....). Also you need to point to the json file in the Command Prompt - not the csv (the json file then points to the csv)

    I have to use the Task Scheduler as my Security Team have taken away access for the Command Prompt to do these things. But the Task Scheduler is a work around (just don't tell anyone!).

  4. I have exactly the same requirement! I don't believe you can use the Licence Expiry field.

    This is why I raised an enhancement for Scheduled Requests (see below) which has now been rolled out. That is great but in its current state it would be too difficult to manage for my purposes (see below again). In any event it is not currently linked to Asset Management which would be even more fantastic as it would enable some really useful automation.

     

     

    • Like 1
  5. You are correct.
    You need the download in CSV which I get from running a report. Take care if you have leading zeroes etc when manipulating CSV's.
    The template file is actually for Uploading new assets - it is just offering you to download it!
    I use this file to ensure I have the correct column names for my upload file which I do via the Import Utility.

  6. Many thanks for the delivery of this functionality which is very useful. We have taken an initial look and have these observations:

    • As previously mentioned a calendar view is definitely required.
    • A Filter and ability to Sort on the list is also required. Our list will rapidly become unmanageable. An example 'use case' is if we load in SR's for say 50 future SSL Certificate Expiry Dates (less 2 months to allow time to renew off the back of the raised SR). We have expiry dates spread throughout the year. The process will work but management of the list will not be possible.
    • When an entry has been completed I don't think we have a link to the created Request. Clearly needed for audit and management reasons.
    • I guess this is more tricky but can we have a bulk upload of the entries - example is if we want to enter say 50 SSL Certificate renewal entries. Not something I want to do manually!
    • Like 1
  7. Earlier this year the new Role was added called 'All Request Access'. This is causing us some confusion for 2 reasons...

    1. This is the description of the new role below...

    image.thumb.png.c2e2136b7479eb678c7c587b504664d3.png

    It looks like this contradicts itself. It says:

    'it grants underlying access to all requests, not just those inside an individual user's service subscription model.'

    but then says:

    'with this role a user will not see requests outside of their service subscription model'

    (it feels like the word 'not' in the second sentence should be removed?)

    2. We have senior managers who have Agent Licences and want to be able to see any Request in the system (but not be assigned a Request). Previously we gave these people the usual Roles plus Service Desk Admin (but not added to any Resolving Team). This worked well but it no longer seems to work. The Service Desk Admin role description includes this statement:

    ' Please be aware that assigning this role gives the user the ability to see the details and perform actions on any request on your instance, regardless of their team visibility. This is effectively a Request "Super User" role.'

    Am I right in thinking that this has actually been removed from Service Desk Admin and is now in 'All Request Access'? I have tested this on a Senior Manager and swapped 'Service Desk Admin' for 'All Request Access'. That seems to have fixed our problem but I am uncertain of this as the wording in the Role Descriptions is so confusing!

  8. When viewing an asset there is this at the bottom of the page:

    image.png.39d7b1c098662cccd0bfa8ce7698e754.png

    By default it is switched Off. Is there a Setting to change the default to On?

    Typically for us the Request will be closed and as such it is not possible to see if there are any linked requests without moving this slider. Personally I am not bothered about seeing Cancelled requests due to their very nature but for some reason they are combined in this situation with Closed.

  9. I did it myself using the wiki and of course Google! If you can just use the Report 'Entity' option then that is easier but for the query above you need to Join tables so have to use SQL Schema Designer (and probably also Database Direct under Platform Configuration)

    But it needs some time and effort. You will need some SQL Coding knowledge so it depends how technically minded you are (or if you have someone who can help).

  10. I think this is similar to my previous issue with the Contracts screen.

    I don't seem to be able to update the Contacts form. I reckon I should be able to because when I download the Template for Import Supplier Contacts it shows 5 possible Custom fields. I need these as I want to add a couple of Dropdown fields to the form.

  11. You have to join a few tables so you need to use a Report Type of SQL Schema Designer.

    h_sys_account_groups tells you the Org Units linked to a person.

    h_sys_groups tells you which of the Org Units is a Department (ie Type 2).

    You have to join the above to something like the Requests table depending on the criteria (ie Filter) you are basing your report on.

    • Like 1
  12. In the screen to view all Contracts (shown below) it is not seem possible to display the Description or Notes fields (they are not in the Preferences pop-up). I know these are free text and can be quite big but we can show the Notes field in the Suppliers View screen which seems to undermine that possible constraint. Strangely Customised fields can be displayed.

    In particular we then want the Search option to include the Description and Notes fields (currently the Search only seems to look at the Name field). I appreciate that this may not be possible with Customised fields but Description and Notes are standard.

    • Like 1
  13. I may be wrong but I recall being able to search for Assets via Asset Tag under Financial Information. However it is certainly not working now.

    I am going into All Assets or any specific Asset Type (as Financial Info is General across all assets) and entering a known value for an Asset Tag in the Filter Search box. It doesn't return anything so has this functionality regressed or maybe I am just getting too old and losing my memory!

    image.png.0b3e000af0a38ecb653b2d1f2f9fbd02.png

  14. Mmm well I can still do it as described by Jim.

    Basically I changed the State from Operational to Retired (I have used Translations to give me different label names) but did NOT click on the green tick. The Sub-state box is then empty but if I click on it I get the drop down for the new State of Retired (but the State box above defers back to the previous Operational). So I can save this combination which should not be allowed...

    image.png.8d94b04b866fdc0ca2e273289abd41ff.png

×
×
  • Create New...