is there a way to remove duplicates from a report?
I have a report that tells me all users who have a particular role but users can be listed many times (depending on how many groups they are in that the role might have been inherited from).
I have a report that tells me all users who have a particular role but users can be listed many times (depending on how many groups they are in that the role might have been inherited from).
If reporting or filtering on record say by created by and selecting ON 'Last 3 months' we get the correct records returned but can we add other options such as:'Last 4 Months''Last 5 Months''Last 7 Months''Last 8 Months''Last 10 Months''Last 11 Month...
Error found in postman : { "error": { "message": "User Not Authenticated", "detail": "Required to provide Auth information" }, "status": "failure" } Does this relate to the permission restrictions I have or is there a d...
I have tagged my projects benefits (benefits plan table) and I would like to create a report/graphic based on tabs (e.g. graphic to differentiate "Achieved" or "Not Achieved" tag. I can include Tag column in the report and include it in the "Group by...
Good Morning: I need to automatically generate reports with 3 days information back.I have looked at options with "relative" but none gives me the data I need.Any ideas?Thank you so much for everything.
Hi Ladies & Gentlemen, I'd simply like to report on both Change request table and change task table and display fields of both tables. For instance, something like: report with the following conditions: on all Changes with Planned end date on Last ...
I am asked to created a report on customer communication for incident. I created a database view to link the journal entry table with task table by element_id in journal entry table with sys_id in task table. But element id from journal entry doesn't...
Is there some documentation on how to write scripts in Performance Analytics, meaning the language, functions, syntax, etc.? All I can find is the following, which presents the concept and a small example but doesn't tell me how to write them: https...
I am trying to create a report that will include the Approval status from the sysapproval_approver table and the requested items variables as columns. I have tried to do database view as described in the article below but I am unable to get the vari...
Hello Experts, I have a requirement to calculate the time difference from 'on hold' to 'in progress' for incident records. I am aware of the duration calculation option in metric definitions, however it just shows the time duration for individual sta...
Hi How do you find the sys_id for a topic in VA? I want to get the current VA conversation using "sn_cs.VASystemObject.getTranscriptById(<conversation sysId>)" But I can't seem to find the conversationID nor run the function at all. Thanks /Jon...
when I create a report and have “additional group by” selected. I can see different graph within Servicenow. But, when I export it, it only exports the current grouped graph. Is there a way, when generating the report, it can show all graphs with var...
Hi All, I'm fairly new to Performance Analytics and would like to see if someone out there has setup a PA report for Incident MTTR. Any help is appreciated! Jody
In my organization we have been building reports and dashboard utilizing tabular models. With this we have been able to give the report users the ability to select multiple items in a breakdown as the report can perform this aggregation on the fly. W...
Hi everyone, Has anyone come across attachment download logs report in ServiceNow instances? There are ways to capture if a file is attached or removed, but I wonder if there is also way to know if a file has been downloaded. Any advice would be...
User | Count |
---|---|
7 | |
6 | |
6 | |
4 | |
3 |