The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Adding a report favorite via script

Brandon_Brown
Tera Contributor

‎12-14-2023 08:02 AM

Our organization has a need to take a series of reports and add them as a "report favorite" for a group of employees. What field marks a report as a report favorite (the star in the report system)? I looked the sys_report table and did not see a boolean field that would mark this.

 

What field in what table makes a report a 'favorite'?

0 Helpfuls
  • 475 Views
5 REPLIES 5

Dr Atul G- LNG
Tera Patron
Tera Patron

‎12-15-2023 03:23 AM

Hi @Brandon_Brown 

 

The favorites are stored in the Bookmark (sys_ui_bookmark) table.

 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0684479#:~:text=The%20favorit....

 

 

LearnNGrowAtul_0-1702639374708.png

 

*************************************************************************************************************
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]

****************************************************************************************************************

Brandon_Brown
Tera Contributor
In response to Dr Atul G- LNG

‎12-18-2023 08:24 AM

Actually I am looking for 'report favorites'. Is that in the same location?

0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to Brandon_Brown

‎12-18-2023 10:03 AM

Hi @Brandon_Brown 

 

I think, yes, give a try. 

*************************************************************************************************************
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]

****************************************************************************************************************
0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to Dr Atul G- LNG

‎12-19-2023 04:15 AM

Hi @Brandon_Brown 

 

@BalaG  clear my doubts and provided a way.

 

Goto user preference's -->

 

LearnNGrowAtul_0-1702988106893.png

 

*************************************************************************************************************
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]

****************************************************************************************************************