Relation between Category, SubCategory and CI Class

[snow_hard252]

Hi Community

I have couple of questions in Config and Asset management:

Though the cmdb_ci creation is driven by CI Class via the New interceptor in FUJI, I would like to understand the relationship between Category, Subcategory Fields on cmdb_ci and the particular CI Class.

Is the model_id the stitching field/attribute between the cmdb_ci and alm_asset tables , there by reflecting in Asset management and Configuration management?

Appreciate if some body can exemplify the above to questions.

Thanks

Hardy

[christopherluc1]

Hardy - no need to apologize for asking, but your main source of confusion comes from trying to correlate tables/features that aren't directly related to each other.   Response by #:

1) category field in cmdb_ci.do's "Category" and "Subcategory" fields have NO inherent relationship to cmdb_categories category/subcategory fields (requires a custom business rule to populate the cmdb_ci fields with cmdb_categories values based on CI class match)

2) class field in cmdb_categories can reference all tables in sys_class_name table unless it is filtered to only include cmdb_ci classes by an attribute or reference qualifier (try attribute = base_table=cmdb_ci,base_start=true)

3) cmdb_model_categories are a many to one relational record that tie CI classes to asset classes where desired; there is no inherent relationship to cmdb_categories, other then the common CI Class selection.

As for the other questions -

"But when I filter the cmdb_ci.list based on Class, I can see only 30 Class types" - what do you mean by "filter" - does this mean you group cmdb_ci_list.do by class?   If so you'll only see classes with CI's populated in their respective tables

"And when I filter the cmdb_model_category.list based on CI Class, can see 118 CI Class types" - Model Categories only apply to CI's you want to associate with an asset.   For example, ports or dns name CI classes should not have model categories tying them to an asset because no one in their right mind is tracking those as assets.

[jarrejo]

Hi Christoph

Yours is the only good explanation regarding Category /Subcategory that Ive seen.

But although I understand how it works, what are they used for.

Ultimately reporting?

Thanks

Joe

[skylarbarth]

I have a (sub-category) question

1. Why do we have Category on an Incident, and we also have categories on CIs. Wouldn't you want a caller to

        a. log an incident

        b. say what service / ci is having issues

        c. auto populate as much information as possible from the ci (including category and assignment groups)

        d. then just have them enter a short description or area to copy/paste any error codes etc?

Thoughts?

[Dead Blade]

Bump this back up.

skylarbarth asked a good question.  Does anyone have an opinion?

To Add:

On a Change record, what do you think about:

1) Use Category/Subcategory to filter the CI selection

Example:  Cat= Software / Subcat = Application / Ci = Business Application CI Class

2) What would the best method to use as a filter, use a Script Include and Reference Qualifier?  And if so what would that look like?

2) Or, would a client script suffice?  Think about server call to browser etc?

[Shree14]

Hi @Dead Blade 

I know, It's been too long since this thread created. But did you get any solution on this?

We also want to get the Change Reference Qualifier based on the Categories.

Thanks,

Shree