UCMDB and UD Practitioners Forum (Previously CMS)
cancel
Showing results for 
Search instead for 
Did you mean: 

Database Table Name which contains CI information

Highlighted
Ramprasad KM
Regular Collector

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
Frequent Visitor

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
Super Collector

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.

//Add this to "OnDomLoad" event