Discovery Fields

[mike2agk]

Hello all, do any one know what this fields on the cmdb table mean?

a)sys_class_path

b)Is clustered

for example 

Created:Date and time record was created

Updated:Date and time instance was last updated

Thanks

Mike

[Jeff Currier · Accepted solution]

Sys_class_path: The sys_class_path is used when identifying specific types of CMDB records. In many scenarios, the sys_class_path from the main table (cmdb) is used, but certain kinds of queries, to avoid excess JOINs, will query sys_class_path directly from the partition tables.  In these queries, objects that have certain CMDB types won't appear to have those types and won't appear in the query results.

Is clustered: This indicates the server is part of a cluster, like a Windows cluster for high availability or scaleability

-Hope this helps,

Jeff

[mike2agk]

Thanks for the update Jeff. I really appreciate it. for sys_class_path  i see values like /!!/!Q/!$/!,. still trying to wrap my head around your explanation regarding sys_class_path

Thanks

Mike

[Jeff Currier]

The /!!/!Q/!$/! is a regex pattern to be used to find paths matching that pattern

[mbourla]

Hi Mike,

I doubt if you're still interested in this after all these years but...

sys_class_path says where a particular CI class is within the overall hierarchy of classes.  I don't know *exactly* how ServiceNow works it out, but basically for all the tables extended from a particular parent table, their sys_class_path will start with the sys_class_path of the parent table.

For example, if you consider the Computer table [cmdb_ci_computer], its parents are Configuration Item, then Hardware.  I imagine it could be different for you, but for our instance the image below shows sys_class_path for the Computer table, the two parent tables in the hierarchy, and all the tables extended from Computer.  (Actually, it was only tables on which we have CIs, so there will be some that aren't shown here.)  You can see that sys_class_path for cmdb_ci_computer is /!!/!E/!! and for all the tables listed below it, their sys_class_path starts with that same text of /!!/!E/!!.  The sys_class_path is a list of 2 character strings, separated by a '/'.

This means that if the system needs to find CIs of a given class or a sub-class it doesn't need to work its way down the hierarchy, but can simply look for CIs whose sys_class_path starts with the correct text. 

That's why if you query in a list for Class "Is a" Computer, the breadcrumbs will actually change to a condition involving sys_class_path.

As I say, I'm not sure exactly how ServiceNow assigns the text to use at each level.  I'd have thought that all the immediate child classes for a given class would have sys_class_path being the parent's sys_class_path, with one level of text added on.  But I can see that isn't always the case, so it's not as simple as that.

But, it *does* show where a table is in the overall class hierarchy.

Hope that helps!

Regards
Michael