CMDB forum
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

database view question

Hi gurus,I'm attempting to create my first database view and between a custom table that looks like this...and the 'Business Application' class...using the following left join......however it returns no records.Any idea what to join on in this case?t...

drslry2_1-1711040948739.png drslry2_0-1711040736599.png
drslry2 by Tera Contributor
  • 1350 Views
  • 7 replies
  • 3 helpfuls

Resolved! what should I do to "retire" a location in the Servicenow?

Dear experts,Currently in my organization, we are having a request from business user.There is a location has been carved out so that the location record in [cmn_location] table is definitely deactivated.But what about all the other records in the sy...

major li by Tera Contributor
  • 1035 Views
  • 2 replies
  • 1 helpfuls

child value is getting empty when discovery runs

A list of windows servers are getting empty child value in cmdb_rel_ci table. the type of the relation is Hosted on :: Host and Runs on:: Runs. how to troubleshoot this issue and scripts that are running for this.

MicrosoftTeams-image.png
daas by Tera Contributor
  • 229 Views
  • 2 replies
  • 0 helpfuls

Resolved! Server CI Cloud Hosted Data

Hi all, We are trying to capture data regarding where a cloud hosted server is hosted. Currently we only have two options (On Prem and Azure). I don't see any OOB fields for this data.  Does anyone have any solutions regarding best practices for capt...

Derek C by Tera Guru
  • 1143 Views
  • 5 replies
  • 2 helpfuls

Export definition filter condition

I have a requirement to create two export definitions in ServiceNow:The first export definition is required to export records created between the 1st and 15th of the month, which will run on 16th of that month.The second export definition is needed t...

Raksha125 by Tera Guru
  • 1035 Views
  • 4 replies
  • 0 helpfuls

Resolved! Setting Class type using Service Graph Connector for SCCM

I recently upgraded our SCCM connector to Service Graph.I'm a little confused on how data is getting mapped for Servers.Can anyone direct me to where in the Robust Transform Class is getting set? I'd like to have the servers coming over from SCCM to ...

EricG by Kilo Sage
  • 755 Views
  • 3 replies
  • 1 helpfuls

Creating a jdbc DB2 connection data source

I attempting to create a JDBC DB2 data source connection. I have followed the steps in the manual and uploaded the jar file db2jcc4.jar.  I fill out the form and update the URL to match the URL in my sql client by adding securityMechanism=13; to the ...

ClarkC by Tera Contributor
  • 831 Views
  • 1 replies
  • 0 helpfuls

Import asset from Excel, update CI

All, I get an Excel file from a Computer vendor containing all the fields I need to create assets from that file. Each new Asset also creates a record on CMDB_CI_COMPUTER and all of the fields we need are populated.I have an issue with the Cost field...

Resolved! Database view with multiple tables

I'm not sure if this is the correct forum, but here we go:I am trying to build a Database View that shows:Servers Related to Application Services that again is related to Business Applications.I am using the cmdb_rel_ci for relations:It will not work...

srv_as_ba.png