Catalog Item hidden from all users
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-23-2025 01:50 PM
We are using SnowMirror to replicate servicenow data for reporting purposes. We notice that we always have 1 less catalog item in our SQL table than in servicenow. When querying all catalog items in the sc_cat_item table, i see there is one removed due to security constraints (regardless of heightened security and admin access). Does anyone know what this catalog item might be (all other related tables like item_option_new, sc_item_option, etc are also out). We would like to try and put a query in to remove this from our exports so we don't constantly have a warning or error that we don't have all the records. I assume its a servicenow only thing? just hoping to maybe try and remove based on sys_id or something.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-23-2025 04:08 PM
@Pam Reid1 - Hi,
The message (Number of rows removed from this list by Security constraints: 1) itself says its been removed. That means it is not even loading with the table. See snip below. All other catalog items have associated sys_id but the restricted one doesn't. So, I don't think you can even view its sys_id.
Alternate suggestion would be to build a suitable filter for your reporting purpose. Or if really needed then "only ServiceNow folks" can help. I don't see any other way.
I created some scripts to see if it fetches any value but no luck.
Regards,
Vikas K
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-24-2025 06:13 AM
Thanks for your reply. Yeah I am hoping maybe a ServiceNow Guru will see my question. I could not find anything and i'm worried that whatever i put in the encoded query could potentially remove something i don't want removed.