Hi All, Still learning regards reporting and with all the preparation for COVID-19 i need to run a report daily that shows the number of INC Requests/RITMs created on a daily basis associated with our remote working. From an INC point of view is a ...
When you add a list report to a responsive dashboard, you can re-size the widget (just like any other widget), but it holds to the size you set. If your list runs on for twice the size, it won't increase in length. You just scroll. Sometimes, that is...
Is there a way to add an interactive filter for a related list condition?
Hi, I am trying to add another custom option in the dropdown list (next 2 hours for example) which is placed after the filter operator.The filter should look something like:Ordered after next 2 hoursAs I tried to find how to change, I began to get th...
Hello, I need to create a report, that will require data from at least 4 different tables. It was mentioned that I need to use/create a database view. I've never done this. Is this what I need to do? Or is there another way to display data from multi...
I would like to pull a filter or report (prefer filter) I can use on a dashboard that will display everything that I have waiting to approve. I know how to pull all the RITMS that are waiting for my approval however for some reason our company also ...
Hi, I would like to build a report that would show a count of incidents that were open in a previous month. They may be currently closed but would have been open in the chosen time frame. For example, if I run the report for December 2019, the repo...
Hi, today we had an issue with our platform, where the mails in the outbox queue have not been processed for 4 hours. I have created a dashboard to monitor the queue, but it would be great, if i could send out a mail, or even better create an inciden...
I'm trying to create multi-level pivot table on benefit_plan table to the format as below* Tried inserting the required fields in column but it doesn't show as the table above. Wanted to explore multiple data sets to construct this table, but don't...
Hey guys, We need the ability to trend the CMDB Health scores. I'm having a hard time reconciling the denominator in the health calculations. The only one I was able to line up was the denominator in the duplicate calculation. Where are these numb...
Hi all I created a line graph report for the number of incidents received by the Service Desk over a 5 month period (see below). I would like to add a trend line (a line that shows the mean number of incidents over that 5 month period). I would be...
Hello all, Background: I have formula indicators set up that show the following: (([[SOM - Number of new incidents > Priority = 1 - Critical]]) * 125) + (([[SOM - Number of new incidents > Priority = 2 - High]]) * 25) + (([[SOM - Number of new incide...
I am attempting to create a breakdown that looks at certain records on the metric_instance table and breaks down on the ID.User field. Can someone provide some guidance on how I would make a script dot-walk through a document ID field?
I noticed in CI Class Manager ---> Configuration Item under attributes. If I make IP Address Mandatory, every CI is required to have that field. We are working with the CMDB Health Scorecard, which is making even apps, and everything that does not ha...
Hi , I want to export an entire dashboard in the body of an email. Is it possible ? I don't want it as an attachment, I want the report to be in the body of the email. Thank you.