QEHNick

Thanks for the time and thought you put into that @Bob Dickinson. I've modified it to this. The thought being, if they have logged on to the portal, they are likely to be seeking some sort of assistance. It's not perfect by any means as I'm hoping to capture the number of calls logged per department (and some of these may come through the phones etc.) If only you could link tables within a widget. Thanks again Bob.

Yeah I'm going bananas. Forget everything I said.

Am I being bananas here? Does it need converting to another format or am I suffering from the heat?

Good afternoon. I am attempting to run a report to determine if an active directory account is about to expire based on a custom attribute which is imported from the accountExpires attribute. The problem is, the "LDAP Timestamp to Date & Time" conversion produces a date which is backwards (2022-06-03 00:00:00 for example). This makes it impossible to report on in any automatic way using the built in reporting variables ({{DATE:startofweek}} AND {{DATE:endofweek}} etc.) Is my only option to "freehand" it in the SQL Schema Designer and MacGyver some conversion of the date there?

It appears that changing the "Data Label Color" value in the "Chart Settings" has no effect.

That's done the trick, thank you very much.

Thanks guys, sorry for late response. Resampling without a time zone now.,

Thanks Steve, so the Universal Principal Name, got it, cheers.

Oh, how silly of me. I didn't realise the process was split into two parts. So the User ID is which customer field? Would it be their primary email address or their actual "User ID"

I think I may have cracked it, although the date range may be contentious as to the correct results. There might be a better way using a "Filter" but I wouldn't like to guess how.

Quick question, what should be placed in the filed "Chat ID" in the aforementioned integration? Thank you.

Hiya Bob, I'd like it to display a "top ten" count of calls logged by departments for the current week. The department value is currently stored in Customer Attribute 3. This will help us identify developing "hot spots".

I have found the "Customer Coworker" tables, and this is great for reporting. Is it possible to use the same table for Widgets?

I've had a pleasant hour browsing the forums looking for an answer to my requirement (enough to spark several other ideas!),. However I have been unsuccessful in finding out how to report on Customer/User Attributes, or indeed an customer variables. I'm sure it's as plain as the nose on my face, any advice would be welcome - thank you.

Late to the party, but this is something which I would like to do, however there doesn't seem to be a "Design" function on that area now. How is this achieved in the current version?

Made a final tweak to filter out the closed/cancelled ones. This is the final script. Once again, thanks very much Neil. SELECT changereq.h_fk_reference AS Reference, requesttbl.h_summary AS 'Summary', requesttbl.h_status AS 'Status' , DATE_FORMAT(changereq.h_start_time,'%d/%m/%Y @ %h:%m') AS 'Start Time', DATE_FORMAT(changereq.h_end_time,'%d/%m/%Y @ %h:%m') AS 'End Time', changereq.h_change_type AS 'Change Type' FROM h_itsm_changerequests AS changereq INNER JOIN h_itsm_requests AS requesttbl ON requesttbl.h_pk_reference=changereq.h_fk_reference WHERE h_end_time > now() AND requesttbl.h_status IN ('status.open', 'status.new')

@NeilWJ That is just pure magic Neil, thanks very much, just the ticket.

Ok, so I'm working on a widget to be displayed on a dashboard, this will give our service desk team an active list they can glance at (should the effluent hit the rotating blades) and gauges if it's linked to an ongoing Change. Yes, I am aware of the change calendar, and yes, I know how easy it is to flick to it etc, but I want to give them a quick (literal) heads-up on the office flat screen. Anyway, preamble done with, this is my SQL so far. Select h_fk_reference AS Reference, h_custom_j AS 'Summary', DATE_FORMAT(h_start_time,'%d/%m/%Y @ %h:%m') AS 'Start Time', DATE_FORMAT(h_end_time,'%d/%m/%Y @ %h:%m') AS 'End Time', h_change_type AS 'Change Type' FROM h_itsm_changerequests WHERE h_end_time > now() My issue is that the table h_itsm_changerequests does not have any natural way of getting the status of the change request. I've had to fiddle getting the summary across as it is (hence the custom variable). Can anyone guide me as to where I can get these absent fields (summary, Status etc.) which are not in the h_itsm_changerequests table? Many thanks!

Not to worry @Graham I don't think I'll be able to achieve anything with the free version. It's now in the hands of management if they want to spend that much money to get these features.

Still getting... That's when creating a package. I am, however, able to add the "Active Directory Group Management" elements.

As it says in the title. There's a couple of extra "20 seconds" after "30 Seconds". I suspect they should be 40 and 50 seconds.

I'll check it out in a tick, that was quicker than I expected, cheers @Graham

I have a widget which shows average request resolve times on a monthly basis. (See below). You might notice that it is missing a month. That data is also missing from its source measure. I also have a similar measure which is also missing the previous month (May) data. Why do those measures not have the data they are designed to capture? There's nothing explicit in them to say omit this month or the other.

Thanks @neilwj. It does make sense, not what I expected at all. I think I'll set it to daily. Viewers of that widget are expecting it to refresh at the start of the month, and that's not going to happen with those constants; at least refreshing daily it will be. Thanks again for answering the question so promptly.

Simple question. In the example below, I have selected to auto refresh every 1 month. My question is, when in that month will it refresh? One month from the date I have set it, or (as I suspect) the first day of the month? Thanks' for taking the time to answer a (probable) "Duh!!!" question.