Hi,I want to know if there is any way to have the amount of tickets received during a period of time like 8 am to 5 pm. On the other hand based on the same report filter only the tickets where was assigned for the first time to a respective group. Th...
I need the where clause with 2 conditions :1- tsk_opened_at >= DATE('2017-01-01') but nothing happend.....2- (tsk_sys_class_name ='request' || tsk_sys_class_name ='incident' || tsk_sys_class_name ='catalog task' || tsk_sys_class_name ='ext...
We have a Dashboard which reports on both Incidents and SR's. We want to have a date filter that will apply to all widgets on the page. There are 4 widgets. 2 Incident and 2 against the Service Catalog.When creating a new interactive filter it asks y...
Does anyone have any suggestions/best practices for creating a Red/Yellow/Green stoplight-like widget using PA (or base Reporting) for display on a dashboard? We have a portfolio which contains several programs, each of which has an Overall Status (R...
I have been building PA dashboards for senior since early this year and have been creating most of the indicators we want. There is one request form I want to create an indicator in which the "variable field1" contains a push down list of categories ...
Is it possible to create report on the audit history of a set of records (i.e. a portfolio and all projects, milestones etc. belonging to the portfolio)?Basically I need an aggregation of History [sys_history_line] items for a collection of records, ...
The totals of the POs are based on created date, but add together day over day.I have a report based on created date but the ask is to see the line continuing to increase over the life of the project - basic math, day one = $5.00, day two =$5 so the ...
I am sure this has a solution but as of now I cannot find one. I am trying to build a bar chart report showing count of incidents resolved in the past 30 days / 7 days/ 1 day for every technican. Ideally the report would become interactive with the a...
Has anyone used (and has examples) analytics to preform ServiceNow license management? Maybe a dashboard, that shows what is owned, what is in use, users with roles that have not logged in, in over 90 days?I am trying to get out of using reports, the...
When our Service Desk Manager attempts to download a pdf of a customised Service Desk stats dashboard I made for him, some reports in the downloaded PDF have not 'completed' and show as 'loading report', despite the report actually being loaded in th...
We have a custom attribute, Committed SLA (u_eta), which is a date field type. We want to create a report that shows incidents where u_eta > closed.Closed is a date/time field, so it does not appear as an option to compare to the date (only) field,...
My question is around incident reporting and particularly around meeting/failing SLA's.I run a report each month against the Incident database and group them by 'Made SLA'. To me, this should show a bar chart and each bar split into met and failed ...
Hi There - Is this something that exists in the toolset? We were thinking of exporting the report definitions if possible to something like XML and putting them in Team Foundation server. I know you can export the data, but what about the report de...
I'm attempting to gather data on the gaps in our coverage for a specific System Center Agent on our Windows servers. We're running the latest patch on Istanbul. SNOW has this data, but I can't expose it correctly. I'm able to return where the a...
Hi a PA Collector job is showing this message.Any advice will be welcome..Thanks
