While working in the ITBM PPM area, I made a copy of the Portfolio Manager Dashboard and renamed it HR PMO Portfolio Manager dashboard. I did this because I liked the out of box dashboard and wanted to keep it while adding two new widgets to the new ...
Hi all, I've a question which probably has a simple answer: If you are collecting scores for monthly Indicators, how do you ensure that the data which is returned does not include data for the month you are in? So for example, if I ran a job today, ...
Hello! We have a report and have columns with service catalog variables. We have a need to group by variables and cannot find a way to do this (variables do not appear in the group by drop down list). Can anyone show me how to group by variable...
Hello, I'm trying to create a report which shows tickets opened vs. closed for Months and also Years. Any thoughts on what is the best way for this to be set up? Thank you in advance. I'm looking at the Engagement Table in GRC.
How are tables joined (either those out-of-the-box or via customization) for reporting in ServiceNow? I know that custom joins can be achieved with database views. However, are database views the object type that enables joining (i.e., dot-walking)...
Hi All, I want to create a report to see how many incidents and catalog tasks were created each day for the week, Table - Task Type - Would prefer a pivot table Conditions - Task type is Incident or catalog task And created = last week So far i have...
I have a dashboard with multiple content blocks that contain jpeg images within the block. The jpg files are in the blocks as attachments to the block. The images display fine for me and I never had to do anything special to see them, but when I sh...
I've got a requirement (currently using London) which I believe is a simple use of metrics, however I'm not finding any relevant examples and I haven't done a lot with metrics yet so the answer isn't jumping out at me. Most of the examples revolve a...
Kaplan has the CMDB feature enabled in Service Now. We got discovery running. I need to build a report for all the servers in our network that shows detailed information like running processes and software installations. The CMDB Artifacts- Serve...
When viewing the dashboard, the reports in the first tab,"Tickets completed", loads fine. But when a user clicks the "Tickets created/updated" tab, no reports will load. All reports in all tabs, included the reports that loaded just fine earlier, wil...
Hi, I need to make a report on the alm_hardware asset table where I can see audit made on the assigned to field. Suppose I have an asset which is initially assigned to person 'X' after that it got transferred to 'Y', then 'Z'. I need to see the time ...
Hello experts, I need to know all users who are managers from my Company. To obtain it, I have created a report using table [sys_user] with fields:company,department and manager. But the problem is that I obtain duplicated reports (as many as the nu...
I am building reports using the Resource Aggregate Monthly table and would like to create calculated fields that provide % of Utilization as in green fields below. Today I have to export the data in my Pivot table into excel and create the % fields ...
In the report, I want to compute a percentage using single score , but i got a number only .How can i get the percentage or where can i calculate the percentage of two numbers?
Hi, I have created a scheduled report while executing this it is sent from servicenow but not received in mailbox. While investigating this i found that 'User' field in email log is empty that is why it is not getting triggered in mailbox. How can i...
