script

NIRANJANAH
Tera Contributor

3 weeks ago

Hi,

 

Do we have any background script to run to remove inactive catalog items which are added to favorites in employee center for all users in ServiceNow.

 

or do we have any alternative way to execute this the above task.

 

NIRANJANAH_0-1755281112831.png

 

0 Helpfuls
  • 873 Views
3 REPLIES 3

Shashank_Jain
Kilo Sage

3 weeks ago

@NIRANJANAH , 

 

In servicenow, a user “favorites” a catalog item in the ESC portal, those are stored in:
sp_favorite table.

 

Delete entries from there.

Screenshot (15).png

 

Run a background script on this table, if Reference Document is that inactive catalog delete the record from table.

 

Hope it works!

If you find any difficulty writing background script you can ask me!

 

 

If this works, please mark it as helpful/accepted — it keeps me motivated and helps others find solutions.
Shashank Jain
0 Helpfuls

Shashank_Jain
Kilo Sage
In response to Shashank_Jain

3 weeks ago

@NIRANJANAH , If the above solution helps, please mark the solution as accepted and close the thread.

 

If this works, please mark it as helpful/accepted — it keeps me motivated and helps others find solutions.
Shashank Jain
0 Helpfuls