UCMDB and UD Practitioners Forum (Previously CMS)
cancel

Database Table Name which contains CI information

Highlighted
Ramprasad KM
Respected Contributor.

Database Table Name which contains CI information

Hi,

 

Can anybody please let me know as to which database table contains the information about the CIs ??

 

Thanks,

-Ram.

2 REPLIES
Rutger
Honored Contributor.

Re: Database Table Name which contains CI information

Hi, there is no such single table, the CMS is built upon a collection of tables which store CI and attribute information with large granularity. Each CI type has a number of its own tables. So 100 CI types means 100 times x tables. I would recommend you pull by using the uCMDB Axis webservice provider.

Angyk
Trusted Contributor.

Re: Database Table Name which contains CI information

Not sure which CIs you're looking for, but I was taking a look through my MSSQL for host CIs, which would be the dbo.CDM_HOST_NODE_1 in the CMDB database. The HOST_NODE can be replaced by other names, you can check it in CI Type Manager, just select a CIT, take a look at details, and use the name you see. For e.g. WIndows would be nt so I query dbo.CDM_NT_1. This works for my purposes. Hope that helps.