samwoo

Thanks @Steve G! ++++1 Thankfully I haven't deployed it and it's currently in a testing phase with myself to discover what can or cant be done via Powershell (which is amazing in my view). I will take all your points in and ensure that I get this to be as secure as possible. I had a thought of the local machine sending a command to a remote "secure" machine which will run the Powershell Script on there - but I dont think this will handle lots of requests very well particularly if loads of users log in at the same time. The other option is to populate a CSV file when someone logs in (there may already be a file for this) and have the Powershell script run every 30 minutes or an hour on a secure machine which reads this file and updates Hornbill accordingly. The final solution would be to create this script which sits in a .exe file... All in all the script will run hidden from the user's view. Thanks, Samuel

Thanks @Gerry!! I really appreciate that. So if it turns out the script is ok to use, I wouldn't want users to find that it doesn't work if they attempt to use it for themselves. Cheers, Samuel

(I just noticed a mistake in the above script, I must have accidentally removed an "else" in the IF statement when I copied it to here... Can't edit my post now so )

Hello, I was wondering if someone can have a look at the following script and let me know if I am overcomplicating things? I understand that using SQL is frowned upon in most cases... but since I dont have a full understanding of Integrations, and our Integrations Officer has left we are unable to proceed with using any proper methods... and I know Powershell to an extent which leads me to writing this. I am trying to create a powershell script that runs during logon (it works!) but i am updating the Computer Assets table using SQL. Can you advise me on what I should have done instead? Or is this actually ok? clear-host Import-Module "C:\users\samwoo\Documents\WindowsPowerShell\Modules\xmlmcmodule\xmlmcModule.psm1" Import-Module ActiveDirectory # Retrieve the Laptop ID $laptopID = $env:computername # Retrieve the current logged on user $currentUsername = $env:USERNAME # Get the current date and time in the right format $dateTimeNow = Get-Date -Format "yyyy-MM-dd hh:mm:ss" # UNUSED - Retrieve the model number ofthe laptop $laptopModel = ($model = Get-WmiObject -Class Win32_ComputerSystem -Property Manufacturer, Model).model # Define instance connection details & API key for session authentication $hbInstance = "(INSTANCE)" $hbZone = "eur" $hbAPIKey = "(API KEY)" Set-Instance -Instance $hbInstance -Key $hbAPIKey -Zone $hbZone # Get the list of users in Hornbill $xmlmcOutput_userList = Invoke-XMLMC "data" "getUserList" # Narrow the list of users to those with the same username as the current logged in user # and retrieve the name of the user set in Hornbill $userDisplayName = ($xmlmcOutput_userList.Params.userInfo | Where-Object {$_.userid -eq $currentUsername}).name # Checks to see whether the user exists in Hornbill if ($userDisplayName -eq $null) { Write-Verbose "User does not exist in Hornbill!" exit } elseif (($userDisplayName | Measure-Object).Count -gt 1) { Write-Verbose "For some bizarre reason this user $currentUsername exists more than once in Hornbill!!" exit } else { $username = $userDisplayName + ":" + $currentUsername } # Update the laptop asset in Hornbill to input the name of the current user and they date / time they last logged in to it Add-Param "query" "UPDATE h_cmdb_assets_computer SET h_last_logged_on = '$dateTimeNow', h_last_logged_on_user = 'urn:sys:0:$username' where h_name like '%$laptopID' LIMIT 1" $xmlmcOutput_updateAsset = Invoke-XMLMC "data" "sqlQuery" -ErrorAction SilentlyContinue if($xmlmcOutput_updateAsset.status -ne "ok") { # API call status not OK - return status and error to console "API Call Status : " + $xmlmcOutput_updateAsset.status "Error Returned : " + $xmlmcOutput_updateAsset.error } Remove-Module xmlmcModule Many thanks, Samuel

Ah nice! Thanks @Victor as always - keep being awesome

Hi @Victor, Many thanks for this - I will keep an eye out for when it's fixed. I just wondered maybe if there should be a section for all pages on the Wiki where one can list known issues / errors with any part of Hornbill? This would then be maintained.

Has anyone got any ideas regarding this? Does this happen to anybody else?

Hi @SJEaton, I've not actually thought about it and I have made changes to some ProCaps while using this node so will assume that it still works as normal? I think as the as the question description remains the same then it works? If you add in new questions then it should still work provided the original question remains unchanged... UNLESS the system is smart enough to know that when renaming a question it's actually reflected in the BPM. (This may or may not be true, but from my perspective, it looks like it is) I cannot give a definite answer here but maybe @James Ainsworth and/or @Victor can provide some insights into how this works? Thanks, Samuel

Hi @dwalby, I'm not able to assist much but we have the same setup as you, however we do not automate this process... but I would think you would need to use Orchestrator/Orchestration for this (we don't use this too...) https://wiki.hornbill.com/index.php/Business_Process_Automation_%26_Orchestration Please correct me if i'm wrong someone. Many thanks, Samuel

Hello, In our new Starter Process, we are creating users into Hornbill and complete two separate tasks where the Analyst populates the first task with the username of the New Starter in AD, and the second task with the Email Address of the New Starter in AD (on premise) (would be nice to have a single Human Task which can have multiple inputs!) This has been working flawlessly, except on some occasions (at least 10 we've found so far). We have the option Continue On Error ticked against the Integration Node, yet if the user already exists in Hornbill for one reason or another, the request still falls over. I have to manually remove the user from Hornbill then restart the BPM against the ticket to get it working and the ticket moving. Are we doing something wrong? Thanks, Samuel

@James Ainsworth - is it possible to change the colours of the "unread" row? (if not can I request an enhancement) Maybe pre-specify a list of colours that work with the theme. The reason I am asking is that I've been telling people in my department about this and a lot of them are saying that they cannot see any yellow rows! After trying to figure out why, I eventually came to the conclusion that all users have different contrast / brightness settings on all their monitors (laptop's and freestanding ones). I did a test where on my laptop the yellow row is barely visible (i had to change the angle of the screen to see it), on my second monitor there is no yellow visible at all and on my third (slightly more advanced) monitor the yellow row is abundantly clear. Everyone is comfortable with their settings that most will likely be unwilling to change it for all their devices just to be able to view this yellow row. What do you think? Thanks, Samuel

Hello, I would say option C too - i just wanted to chip in and say how amazing this feature is in Hornbill Wiki: https://wiki.hornbill.com/index.php/Request_Variables To add on to what Victor said, if you don't see the "Variable Picker" then you will need to hold CTRL and Left Click in a text box to bring it up. The beauty is that you can put a single "Get Request Information" -> "Progressive Capture Answers" node at the very front of each stage of the Business Process and you will be able to use the Variable Picker for it anywhere in the BPM. This has totally cleaned up my BPM's, particularly the ones where I had to use loads of Get Request Questions nodes in a single stage. Thanks, Samuel

Any ways of dealing with assets via he Progressive Capture and the Business Processes is a plus in my eyes... +1 Please add me as an interested party.

Might be useful to know in case a developer comes to have a look at this... but have you refreshed the screen after the status has changed?

+1

+1

Hello, I have just lost a large email I was writing from within a request - I was wondering if anyone has had a chance to look at this query? I'm not sure what happened but I had a meeting whilst writing the email, when I got back I ended up on the "Update request" function against the ticket, when clicking the email function my email wasn't there. Thanks, Samuel

+1 for an enchancement we can create new profiles but I don't think we can set them to be used anywhere else in Hornbill. It would be nice to be able to use this outside of call logging and resolving - such as in the Progressive Capture on the IT Portal, or maybe against an asset for instance.

Hello, Just to bump this up a little - is there an update on this? Many thanks, Samuel

+1000 @James Ainsworth could you add me as an interested party to this as well?

+1 this would be useful

+1

Hello, My colleagues have been querying whether or not it's possible to save an email from within the Request List as draft. They envisage there being an option to save an email they are writing from withing the Request List as draft which they can return to at a later stage. This is particularly helpful in scenario's where someone is working on writing an email related to a ticket and suddenly halfway through the email they need look at another ticket (maybe a P1). Most people don't open new windows or tabs and simply go straight to the request list from a ticket they have open. This results in the email they've written being lost. There have been cases where they've accidently closed their laptop or their battery ran out of charge or the internet connection has dropped as well where this would help. The draft would only re-appear for the user who wrote it, and if they get back to the ticket with a draft email and decide not to use it, they can overwrite it or remove it to clear the draft email. The options around this should be customizable: How long to hold a draft email for before being deleted? An option that will determine... If Draft is ALWAYS on or Save Draft button Can the draft options be set per service (as some could be confidential and must not have draft emails at all for instance) Just a thought. Thanks, Samuel

+100 I think this has been discussed before, but it's not currently possible (yet?)

As a starting point though this would be good