CMDB Query builder logging
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-06-2024 07:39 AM
Hi,
I've a simple query buildt in the CMDB Query builder.
It looks for all the virtual Linux server depending on vCenter Clusters related to ESX Servers.
I've tried to create the same query with only the Linux and the ESX Classes with a relation level of 2
But my second query return around 10 records less than the first one. I've checked the missing records and they are all related to an ESX server via a vCenter Cluster like all the other Linux and the filter applied to the Linux and ESX classes are the same. There is no filter on the vCenter class.
Is it possible to retrieve the query that is passed to the DB in SQL format or, at least, in an encoded Servicenow format?
How can I check why one query is retrieving less CI than the other?
I've activated the logs on the query builder with the sys_properties glide.cmdb.logger.use_syslog.QueryBuilderProcessor and glide.cmdb.logger.use_syslog.QueryBuilderOutput but it is useless.
Thank you