Hi,I need to create SLA PA indicators for SLA achievement per HR Service. SLA data is stored in task_sla table and hr services are stored in sn_hr_core_service table. Is there any way to do that differently than creation of database view?I tired to c...
Hello community,I need to understand what the Territory_admin role gives the user, but I couldn't find what capability it offers.
Hello community! I'm trying to create a new interactive filter for my dashboard and the information it shows is all the data that my clients have uploaded to each company's portal. How can I generate a single information panel with a client filter an...
I was given the option by ServiceNow to default large files to be emailed to me. At that time it was a lot easier to get an email so I defaulted to that rather than waiting. That way I could keep working. However I'm now finding that in some cases th...
Today in PA Academy we discussed using Database Views to join regular tables to other places we need to gather data. Here are a couple of examples which work in my implementation. Join Incident/Task to custom table (the table is used to accommodate a...
Hi all, I am new to ServiceNow. I am trying to generate a report that shows the inflow of incidents to a particular group and outflow of incidents from that particular day on a daily basis. I am fine if these reports are separate as well. This must b...
Here is my script unsure what could be causing it to not update the report filtering on first namethe report I am targeting does have follow interactive filter on:Order guide Variable "first name" preview: Dashboard preview: Code:<?xml version="1.0" ...
Hey SNC, I came upon the case the other day where I needed a breakdown by the CI Class on Configuration Items in PA. Therefore I decided to share how I solved this case:1. create a new manual breakdown, in my case called 'CI.Class'. Leave 'display' u...
I have been asked to create a report showing any time our MSP group has touched a ticket thru out the lifecycle. Its easy to show if they opened or resolved a ticket but how do I report if they touched it in the middle- ie, assigned to initial group ...
Does anyone know what determines which fields are available for selection when choosing the Distinct Count option in Reporting? My scenario is that I am reporting using a database view that has multiple rows per change request. I created a trend repo...
Hi, I'm trying to make a report from table "Computer (cmdb_ci_computer)" but I'd like to add columns from another table "requested Item (sc_req_item)" like this ones: Number, name, activity for, item, etc.. But if I go to the colomn selector and ad...
Hi there, I'm wondering if there is any way (perhaps an iFrame or Java Script) to embed a list report (example incident.list) with that list's standard every field filtering functionality into a dashboard? I do know that interactive filters are avai...
Hello,I followed this great article (https://www.servicenow.com/community/performance-analytics-blog/embed-list-reports-in-a-scheduled-report-email/ba-p/2269771) to create the business rule, scheduled report with type selected as Png .For the Message...
Hello all, We have a dashboard with widgets which are normally visible to most users with whom the dashboard is shared.However one user sees placeholder widgets as if they have not been configured somehow in this dashboard.I could understand if a use...
Hello Community,I am checking Platform Analytics on Utah.I understand that for Line Data Visualization:- Multiple Group By is not possible- it is not possible to set a grouping on the Trend By (previously "Per"), e.g. the trend by Created is only by ...