In cmdb_ci table how to identify from where the fields data is coming
In CMDB need to check all the fields data and from which source the field data is coming. How can we check that
Forum Posts
cmdb_rel_user_type out of the box data?
We are considering the types of CMDB user relationships we have been building and in out instances it seems we have exactly one out of the box relationship defined (Log reviewed by::Reviews logs for) and found some knowledge articles talking about th...
After running tenable integration jobs we have run not all job then also ip address & ci creating ?
why unmatched ci are creating we have run these four job only not that three??after running this three jobs Tenable.sc Open Vulnerabilities Integration:- this will pull all the vulnerability for servicenow from tableTenable.sc Fixed Vulnerabilities I...
azure service account
Hello I start to get familiar with Azure Cloud discovery. I could discover using my master subscription / service account. Now I have created a second azure subscription / add a second SN service account and when I create / test discovery job: bu...
CMDB_CI table database view
Hi, I am trying to build database view between "cmdb_ci" table with "cmdb_ci_business_app", "cmdb_ci_desktop_software", "cmdb_rel_ci", "cmdb_ci_server" I am stuck with what needs to be the where clause condition. I don't have exposure to CMDB tables ...
Integration via ServiceGraph Connector
Hi Team, I got a requirement to integrate Workspace ONE UEM with CMDB using Service Graph Connector. There are so many devices are there in the Workspace , the client required only mobile devices and scanners. How I can filter out or not to query fo...
Resolved! SCCM SGC not consistently updating to the target record
Hello!Continuing to work on our SCCM SGC integration, we have run into an issue with the Computer Identity data source where we run a full load (have limited the SQL statement down to one record), transform that load using the robust transformer, and...
Resolved! Child CI Location = Empty
Hi, Is it by design that some 'lower level' CIs do not pick up the location details, from its parent discovery run?Example: apache webserver/tomcat/MS SQL Database/Disk/MSSQL cluster node/disk.I could go on but basically we discovered our first DC (l...
Cancel a Change Request on Insertion If Requester Has Many open CRs
Hello,I have a business requirement to deny and Cancel any new change request of a given requester if they have 5 or more open CRs until they close/work on them. This is to ensure they close their CRs. I am using the below script but it is not workin...
Inbound Email Signature translated into hyperlink
Hi All,What needs to be done to avoid inbound email signature icons/images to be translated into a hyperlink.Please see images below:
Identification and Reconciliation(IRE) implementation on scheduled Jobs
Hi All, I have created a scheduled Job that is fetching data from a third party using Rest Message and creating or updating records in a 'cmdb_ci_computer' table.Could anyone please guide how can I implement IRE in the scheduled job? Thanks.#cmdb #in...
Set location of discovered CI based on IP address
Hi, Is there a way to automatically set the location of a discovered CI based on the IP address of the CI? I guess I would need a table which maps IP ranges to locations but not sure if that is the best way to do this.
Populating CI's from ITRS OP5 Monitor(monitoring tools) to ServiceNow CMDB
Hi All, I want to populate CI's from OP5 monitoring tool to ServiceNow CMDB, has any done this please help.Or do we have any connector for CMDB, i understand we have for event management
Resolved! Hi All , I need to update "impersonate " role in 1000 user records level ? please help
Hi All , I need to update "impersonate " role in 1000 user records level ? please help
Modify a parent table form and replicate on child/extended tables
Hi Community! We're on the need to change a few forms for a big amount of tables.To no do it manually bc of the time that could take that action, We're thinking on faster methods. We think that a script maybe could work, but if you know an OOB method...
