List of CIs that do not start with Generic
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-04-2025 01:05 PM
Hello,
I have a requirement to exclude CIs where the name starts with "Generic" on a field that references the cmdb. Has anyone successfully used "NOT STARTSWITH" in an encoded query? If there is another alternative, I'd appreciate any ideas. Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-04-2025 01:12 PM - edited 11-04-2025 01:13 PM
Hi there @George56
You can’t use NOT STARTSWITH in an encoded query, so it won’t work as-is. Instead, filter using:
nameNOT LIKEGeneric%
This will exclude any CI whose name begins with "Generic". You can add other conditions after it if needed. Simple and works fine for reference qualifiers and GlideRecord filters.