Query Builder not working
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-13-2023 01:13 AM
Hello gurus
Why Query results is No records found even there is relation between server and offering (picture2 below)?
No filter used for server neither for Offering.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-13-2023 05:48 AM
One thing to check is whether your CI relationships are Depends on::Used by and not Uses::Used by. Otherwise the CMDB query looks like it should work (as an aside, the relationships themselves are not aligned to the CSDM, which I would also take a look at -- you're missing the Application Service that should come in between the Offering and the Server.)
The opinions expressed here are the opinions of the author, and are not endorsed by ServiceNow or any other employer, company, or entity.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-13-2023 10:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-13-2023 10:33 PM
Now I got it right when started by Service Offering not with Server then created exactly same query than previously but when system complains about starting node cannot have incoming connections and changing Starting node to Server and running query everything works ok. I still wonder why it didnt worked in the first place when started creating query with Server ? Strange 😉
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-14-2023 05:40 AM
Unfortunately Query Builder is just a very buggy tool and it's something not a lot of people talk about but should. I think one of the main reasons is that it's so hard to consistently nail down the errors and reproduce them so we can report them, but needless to say, they persist.
The opinions expressed here are the opinions of the author, and are not endorsed by ServiceNow or any other employer, company, or entity.