This is a step-by-step guide on how to construct a CMDB Query Builder query in ServiceNow to retrieve all Service Instances (cmdb_ci_service_auto) and Servers (Linux and Windows), regardless of whether they are directly related.Although the CMDB Quer...
I have limited experience using CMDB Query Builder, and I was assigned to create the following query. I would greatly appreciate your assistance. RequirementRetrieve all Service Instances (cmdb_ci_service_auto) that are related to Linux and Windows S...
Does ServiceNow support Schema on read with SQL like SELECT CAST(order_amount AS INT)FROM Order_table We need to do type casting in memory where Order amount is stored as String in the database. Our goal is something like this which identifies the fi...
Question about the CMDB IRE and how sys_object_source is used, specifically with the SCCM SGC. https://docs.servicenow.com/bundle/vancouver-platform-administration/page/integrate/cmdb/reference/how-sccm-integration-works.html#d196797e370 makes it sou...
We have recently started to use the AWS Service Graph Connector to bring data into ServiceNow for the use in Service Maps. It works fine and was easy to set up but it has shown us that the amount of data in AWS is too much to manage and is using our...
Hi All As per CMDB health dashboard Orphan CIs are not showing because Orphan rules are not configured. Please give me some examples of Orphan rules that can be setup and what are the best practices to setup Orphan rules?
Hi All,Problem: SLA pause duration seems not working. we tried creating custom script to calculate duration in SLA definition, so with this SLA pause conditions not working? is this known issue?
I'm trying to set the Support Group on several related CIs. I have created a Dynamin CI Group and related CI Group. This is populated via query. This part is working fine. The CI's still have the Support Group set to null. Do I need to create a T...
Hi, i am not able to find the code whoch sets the mananged by field empty, after the life cycle stage status is set from the customer to retired. From my perspective of view this seems to be a schedules script which is triggered every 5min.See the sc...
Recently we have installed the ServiceGraph connector for SolarWinds in one of our client environments and retrieved the Orion Data to the ServiceNow CMDB instance. We have used default data sources and added 2 customer fields to current data sources...
With increasingly complex and dynamic IT environments, the classic approach to Discovery, which relies on probes and sensors, is undergoing change. ServiceNow has launched Pattern Operations, a new and improved approach to exploring your Configuratio...
In the current intricate IT environment, the task of having a correct and current Configuration Management Database (CMDB) is a challenge of monumental proportions. ServiceNow Discovery is the engine that drives the IT Operations Management (ITOM) an...
Hello,I am looking for a report or a tool wich could produce the following report for any given table :Quantity of records in the tableFor each field in the table :- Quantity of distinct values- If the field has less than 11 distinct values, list of ...
On 30th January’26, I passed the ServiceNow CIS – Data Foundations (CIS-DF) certification.Since then, I’ve received several individual requests for the guidance on CIS- DF preparation over LinkedIn and Teams.So, I decided to write a blog which will...
Pls let us know Why active install is false on the lastest SW version, where the old versions show as active install is true. Why active install is false on the lastest SW version, where the old versions show as active install is true.
