CMDB classes

[Dikshmalik]

Hi Team

I have a requirement to find out the list of all the available classes in CMDB_CI and other child tables related to it so that we can use the same when using baseline functionality for various CI. We have more than 1 million CI records so its not possible to take the extract of all the records in excel and then sort the data. Can somone please let me know how i can manually get the list of all the CI classes without taking extract of such huge data.

I tried running background script :

var ab= new GlideRecord('cmdb_ci');

ab.query();

var cn=ab.getRowCount();

while(ab.next())

{

gs.print(ab.sys_class_name);

}

But this resulted in few classes even though the CI number was same to the number of CI's in the system but i am unable to get the full list of classes. I also tried the group By option but it only results in records that has CI's and i need empty classes.I tried it in my PDI.

Thanks and Regards

Dikshit Malik

Message was edited by: Dikshit Malik Please see the attached image to get a better understanding.

[Chuck Tomasi]

Hi Dikshit,

Take a look at this page...

http://wiki.servicenow.com/index.php?title=Tables_and_Classes#gsc.tab=0

[Dikshmalik]

Thanks for the reply!

Is there any custom script that can be used to find list of all the classes in CMDB_CI table along with its child tables?

[Chuck Tomasi]

Take a look at the TableUtils script include.

There is a method or two in there that may help. Particularly, look at getAllExtensions(), and getHierarchy()

[Chuck Tomasi]

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button.   If so, please review How to Mark Answers Correct From Inbox View.

Thank you