- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-11-2024 04:57 AM
how to report on the following for the change table:
changes with a PLANNED END DATE in the last 24 hours
[2]changes with a Planned START DATE in the last 24 hours, current day and next 24 hours same as current dashboard
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-11-2024 05:10 AM - edited 01-11-2024 05:12 AM
To get the planned end date for the last 24 hours, you can utilize below filter when doing a report in the change_request table:
To create the planned start date in the last 24 hours, you can utilize same filter as above, just with "planned start date" instead of "planned end date".
If you instead want to look 24 hours a head, the utilize below condition:
if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-11-2024 05:10 AM - edited 01-11-2024 05:12 AM
To get the planned end date for the last 24 hours, you can utilize below filter when doing a report in the change_request table:
To create the planned start date in the last 24 hours, you can utilize same filter as above, just with "planned start date" instead of "planned end date".
If you instead want to look 24 hours a head, the utilize below condition:
if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-11-2024 05:13 AM
Create 4 different reports
Plan start Date
Plan end date
create these reports and add in Dashbaord.
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************