Hello All,Need a point in the right direction for the below. Trying to get an idea of the age of currently open incidents using mi_duration, however when i run a report with the below conditionsAnd specify 2 AG's and Active is true in the filter, my ...
Hello community,i have an issue with the calendar view. I am running a calendar report based on the planned start date of a change request, when the planned start and end dates are longer than a year, it eventually disappears from the calendar report...
I am sure I saw the slush bucket values for date interactive filter show up when first started working with PA dashborads but now when selected it tells me "Related list is empty" If I edit the widget on the dashboard I see the slush bucket and the...
Hi, I need to replicate (or recreate...) many reports from our legacy tool to ServiceNow Helsinki.One report is looking for tickets that have one of a long list (approx 40) of CI's as the Impacted Config Item. Do I really need to separate these into ...
Does anyone know how to enable "Interactive Filters" to work with Custom Charts? Is this even possible?
I am very new to SN and have a very newbie question. I am looking at the User list and I want to only see the users that are in an assignment group with a name that starts with "LMS". I know I need to use dot walking and have read up on it, but I'm f...
Hello,I am trying to make a threshold that checks the specified indicator, hourly and then send a notification when it is reached. I created a threshold and indicator, where the indicator source has a job that runs hourly. This makes the graph on the...
Hi folks!We have a business need to display records based on physical locations (cmn_locations) in addition to the Assigned To/Group fields. For example, a Facility Engineer will need to see Work Orders assigned to themselves along with all other W...
My requirement is to find the % of user who have logged in to Service portal.& find the % of user who have logged in to Instance.I found on "syslog_transaction" table ,there is URL field but i don't know what is the url to get who logged in into Se...
Hi,i have a generel question concerning the data collection process in PA.Where are the historical information stored ? Is there special/separate table for that? e.g.: If i want to collect incident information for the last 3 months Do i have enable t...
calculatedura();function calculatedura() { var taskRec = new GlideRecord('task'); taskRec.addQuery('state', '=', 6); taskRec.addQuery('state', '=', 7); var orCondition = taskRec.addQuery('sys_class_name', 'incident'); orCondition.addO...
I want to create a breakdown that comes from table an auto number, like Project. However, I want the breakdown to be on the project title, not the Project number (for example). Can it be done?
I read the wiki that says you can execute a scheduled report using the following:---------//Execute a scheduled script job var rec = new GlideRecord('sysauto_script'); rec.get('name', 'YOUR_JOB_NAME_HERE'); SncTriggerSynchronizer.executeNow(rec);This...
We have sla related reports reports in our Geneva instance grouped by assignment group that tends to include more results than what seem to be included in the default charting options under the "No. groups" drop down options. Even when changing the...
Hi All,Using Geneva, Patch 9 in our instance.I have a formula indicator:( [[Number of successful changes / By month SUM +]] ) / ( [[Number of successful changes / By month SUM +]] + [[Number of failed changes / By month SUM +]] ) * 100Which is linked...