Hi jha,
cmdb_rel_ci table holds the relationship between ci.
Check this blog to get the ways to get Downstream and Upstream relationships from Script:
https://www.servicenowguru.com/scripting/script-includes-scripting/walking-servicenowcom-cmdb-relati...
For roles:
CMDB Developer:
He is responsible for implementing technical solutions which will help keeping the CMDB as healthy as possible. He is responsible for integrations, discovery and Service Mapping. He is the person to configure health dashboard.
CMBD Admin:
He is a person who will look after the results of health dashboard and check why the CI was not complaint,etc. He is a person who will be doing manual creation of CI is required. He can create reports for stake holders,etc.
-
- The Configuration Management Database (CMDB) Process Lead will have the responsibility for administering the CMDB process within the organization, working closely with other process leads and to ensure that Asset specific information can be gathered and disseminated using efficient and consistently followed processes.
-
- This role will work closely with Event Management, Incident, Problem, Change, Service Request, Disaster
- Recovery specific process managers and also with the customer. The CMDB lead will administer, manage and carry out all aspects of the CMDB process. This role will also ensure data yielded from this process will be of high quality and provide management with the right level of business intelligence and reporting.
Mark my answer correct & Helpful, if Applicable.
Thanks,
Sandeep
