how to do classification of data in cmdb? & how we can hide data from others?

[Ginuix]

i have lots of data messed up need to filter out the old data. dont want to delete the data but need to filter out so i can i hide the data or only high privillage can access

[haseena ayesha · Accepted solution]

Hii Ginuix,

CMDB classifications are groups of configuration items (CIs) that share attributes and are stored in their own table. Classifications allow administrators to define the hierarchy of CIs within the CMDB. A CI class refers to the actual table name in the instance database. In that context, CI Type is a friendly name that a CI is known by, such as computer, router, or printer.

The Base Configuration Item [cmdb] table uses the table per partition extension model, which has different behaviors for replicating and deriving information than other extended tables. See Table extension and classes.

Key tables in the configuration management database (CMDB)

• The Base Configuration Item [cmdb] table which is the core CMDB table for non IT CIs (descending classes are non IT CIs).
• The core Configuration Item [cmdb_ci] table, which stores the basic attributes of all the CIs. 
• The CI Relationship [cmdb_rel_ci] table, which defines all relationships between CIs.

The Configuration Item table is extended to other tables, such as Database [cmdb_ci_database] and Computer [cmdb_ci_computer].

The Computer table is extended to the Server [cmdb_ci_server] table, which is extended to the UNIX Server [cmdb_ci_unix_server] table, etc..

Please go through the below links:

 CMDB 101 - What is a configuration management database and why do you need one?.

https://docs.servicenow.com/bundle/london-platform-administration/page/administer/table-administration/concept/table-extension-and-classes.html

Thanks & Regards

Haseena  

                                                            Please: Hit like, Helpful or Correct depending on the impact of the response