I need to query sys_dictionary table and list all columns that reference to sys_user table. The challenge here is to list column only once. I do not want to list the child tables in my list. For example, column defned in cmdb_ci_servers should be l...
I need to export any CIs created on the 20th February from the cmdb_ci table and I also need to include the sys_id of each record in the exported data. I cannot seem to find a way to include the sys_id field in to the list view. Any assistance would ...
Hello, looking for some suggestions/ideas to accomplish this: In the properties of a Computer Object in Active Directory, there is a General tab. On this tab, there is a field called Description. This field is configured with unique information fo...
I need to convert Business Service to Application Service and for that I referred to this https://docs.servicenow.com/bundle/sandiego-servicenow-platform/page/product/service-mapping/concept/convert-bus-to-app-svc-intro.html#convert-business-service...
Hello, Re: Unable to resolve target record, coalesce values not present: sys_import_state_comment I have 135 records with this same error out of the 854 in my JAMF (not SG, using scripts before my time) ISET.' Why does it do this for only a certai...
Hi Team, Can anyone help me with the following related to CMDB Health Dashboard? 1. How the total CI number is calculated? i.e. in every KPI, there is a notation like Recommended 10/100 10%..then how the 100 is calculated.. 2. For Staleness, I found ...
Hello All, I need to know from where is Most recent discovery populated in CMDB. Is there a way to check from where I can get this information? Thanks in advance!
why I am getting install count is 0 and status is installed in software package table cmdb_ci_spkg. I got this script in system UI > script include > SoftwareLicenseManager /** * Install counts / License count management of the following three ta...
Hi! Whike looking at plugins I noticed this one this https://store.servicenow.com/sn_appstore_store.do#!/store/application/97e04562072020107add6a77c4a9351a/1.0.3 Observability Commons for CMDB The summary doesn't say much: Summary Contains t...
Hi Folks!!My client has requested to set up a permanent filter on Lookup List for Product Line when I select Manufacturer or Vendor to show only manufacturer or vendor from the core_company table, which is not possible as of today by me. To give a li...
We're attempting to incorporate Mac and iOS devices into the CMDB via the Service Graph Connector for Jamf. We've walked through the Jamf SG setup, everything went fine until we tested the connection. When using the Pro API, we get the following erro...
Attribute Name is - Validated systems. Field type- Drop down Choice values- true/false classes in which we need to add the field-- Servers and Network class
Hi All I have an interesting scenario where a customer wants to manage the operations of a number of non -IT items in the CMDB. I would like to know where should i extend off? Some more criteria/ background There is no need to generate a dependency...
Hello existing users of Multisource CMDB. I know we are not supposed to ask licensing related question on this forum, but ....... We are looking to use Multisource CMDB. We do not have a Discovery License. Our ServiceNow Account manager is telling us...
Hi, I'm trying to run a csv data source through IH ETL but its only previewing and updating 100 records out of 814 in the csv file..Anyone else had this problem? Its working fine when I just run it as a normal import set. Thanks, JW
