Dan Munns

Hi, We are using the API to log a request and it seems to have come up with an error I have not seen before (rare since I seem to have caused most of them before): The tickets are marked 'In Progress' on the BPM management view, hovering over the request in the request list shows the correct information and for all intents and purposes the ticket seems to be fine. Apart from I cant open it. The ticket fails to render at all, just presenting the error and nothing else. I cant even select the tickets from the request view to cancel them. So....erm....help please?

@SamS works spot on (*cough* once I added the missing brackets *cough*) Thanks for tidying up the SQL as well. Learnt something so its a win all round.

To add some context here: We have a number of processes which require multiple requests. Project drops down to change which drops down to service request and vice versa. If a user has raised something as a service request which requires a change to be logged, it may be another user logging the change (dependant on job roles etc). If they could log the change and add the SR reference, it would allow me to automatically link the requests rather than having people looking through request questions and linking requests manually. The detail would be like this: User raises a review request (request for improvements to be investigated and made to existing processes), leg work is assigned to Lean Six Sigma green belt to investigate (collaboration licence only, details sent by email). Green belt finds improvements can be made and raises a change request for the central change team to make the process changes. They add the current review request reference number to the PC. BPM links the two requests together so the change team doesn't have to do it manually so when the new change request is assigned the analyst has all relevant info at the start.

Thanks @NeilWJ

Thanks @NeilWJ

@James Ainsworth thanks this fixed it. Needed to put a service details node in. Thanks again.

Thanks @SamS Ill give it a spin

@Steve Giller this is on a ticket type with a set supporting teams list. There are maybe 12 teams on the supporting teams list but in the PC it shows all teams.

Hi, A number of teams have been asking about the assignment node in PC showing all teams in the list. As far as I was aware this would only show teams that had task assignment turned on? Is this correct or am I wrong in thinking that? Thanks, Dan

+1 seemingly very slow at the moment

Thanks @Daniel Dekel

Hi @Daniel Dekel The user has Windows 7 and was accessing the conversations from the panel on the right. Tried on IE. Browser refresh, Ctrl + F5 refresh, logging out and closing all have no effect. Conversations work in IE if access via the Home panel but an error was received when trying to add a user to a conversation she started: Conversations work in Chrome.

Hi all, I have at least one user who gets this error when trying to open conversations. They have been using it fine up to today. Thanks Dan

Thanks @AlexTumber

@AlexTumber dont suppose you have any ideas on this?

Ok thanks @Steve Giller I will add a resized image to our library.

@Deen did you manage to have a look at this?

Anybody?

Thanks @James Ainsworth

Hi all, I have some (frankly awful I am sure) SQL for a widget we use for QA. SELECT h_pk_reference, h_summary, h_datelogged, h_resolvedby_username, h_source_type, h_fk_team_name, ROW_NUMBER() OVER (PARTITION BY h_resolvedby_username) AS 'ANALYSTS' FROM h_itsm_requests WHERE h_pk_reference LIKE '%IN%' AND h_status = 'status.closed' AND (h_datelogged >= LAST_DAY(NOW() - INTERVAL 2 MONTH) + INTERVAL 1 DAY) AND (h_datelogged < LAST_DAY(NOW() - INTERVAL 1 MONTH)) AND (h_source_type <> 'Autoresponder' AND h_source_type <> 'Email' AND h_source_type <> 'Self Service') AND (h_summary NOT LIKE '%Password Reset%' AND h_summary NOT LIKE '%Account Unlocked%') AND (h_fk_team_name = 'IT Service Desk' OR h_fk_team_name = 'IT Infrastructure' OR h_fk_team_name = 'IT TEAM 3' OR h_fk_team_name = 'IT TEAM 4' OR h_fk_team_name = 'IT TEAM 5' OR h_fk_team_name = 'IT TEAM 6') ORDER BY ANALYSTS LIMIT 40 This produces the below list in a widget: This is better than what I did have (in that it shows a wider group of users), which was 30 completely random requests from within the filter but what I really want is a random list which only shows a max of say 5 entries per analyst. I am sure this is possible and that my SQL skills leave much to be desired but can anyone help me out with this? Thanks, Dan

Hi, Can we have the permissions around service/CI creation looked at please? When adding a default mailbox to a service I can only see ones to which I have access, which means I have to go and add myself to the mailbox and then set up the default mailbox and then go and remove myself afterwards. Being able to add the mailbox as a default without having to do this would be much better from an ease of use and security point of view. Thanks, Dan

Hi, Can we have the ability to add a linked request via the BPM using a variable? I am trying to have a user add the existing reference to a field in the PC and then get the BPM to add the request as a linked request. Thanks, Dan

Hi @James Ainsworth, Are we waiting for anything else to make this live? I get this error when clicking the hyperlink to view the subscriptions:

Thanks @James Ainsworth Very quick turn around there!

Hi, I have recently been asked this question by quite a few people using the SM application: "Is there a way to make the on-hold requests text easier to read?" I am assuming no as I cant find a setting for it, so would it be possible to add a setting to change the level of greying out of the on hold requests in the request list please? Thanks, Dan