Need an idea how can we reference Business service Table with the Asset Table

[Ediga Sai Chand]

Hello Team , 

Greetings !

I have been struck with a requirement from past few days and tried few things but it didn't work. Need an idea or help from community going forward.

Requirement :-

When an Asset is created / updated (alm_asset) , I want to create a new record in custom table called as Profile Assignment (profile_assignment).  The model category of the asset should be copied to the new created table.

Questions :- 

I am able to copy the model category from alm_asset table to risk profile table because both fields of same table model_category.

Now i am facing an issue like I have a field on asset table that when profile type is product/asset level then the same model category has to be copied to Service field on newly created table (cmdb_ci_service_business). How can we do that because there is no relationship between asset and service table.

[Barry Kant]

@Ediga Sai Chand 

an asset is most likely related to a CI.  (Or the other way around, the Server CI has a related (1:1) related asset. 
For most models when the asset is created it also creates an operational equivalent --> a CI record. 

The CI can be used for the relations.
It might be that the CI is related via Associations as well (if done by Service Mapping --> svc_ci_assoc table). 

BR,
Barry

[simplyrik]

We used Discovery Map using the Relationships in the CMDB Query Builder to relate the Business Service Table, to the downstream CI, then he link to the corresponding Asset.

[Ediga Sai Chand]

@simplyrik @Barry Kant The thing is we didn't come far enough for discovery. The project is from scratch and we don't even have the demo data. It's like a fresh instance with no data and need all relationships build as per the requirement where i have been struck from last one week. 

[simplyrik]

Sounds kind of like either a "Chicken or Egg" or "Cart before the Horse" situation.  Can't see how you could do it without the design first then manually creating those relationships.  

[Diego Peukert]

Hello, Ediga,

If I understand your customization, there is a need to relate the asset model to Business Service. Here's how I would do it following CSDM 4.0.

1 - There are several types of model (cmdb_model) people are more used to hardware, software;

2 - Depending on whether we're talking about an Asset or a CI, the model can be born first in the asset, as is the case with Computers, Physical Servers, Network Equipment, etc.

3 - In the case of Application models, these are usually born from the CI, because Application models such as Database Management Systems, Web Servers, Application Servers, are better discovered and catalogued by tools that automate discovery, such as Discovery-ServiceNow or well-made Integrations;

4 - Business Service are the services that your company provides to internal/external users using technology. This technology that provides the service can have a below-ground infrastructure or be serverless (such as PaaS or SaaS services). The item that should receive the IC relationship (Operational Items, not Assets) is Application Services. These can even be a grouping of CI's using CMDB Group + Dynamic CI Group;

5 - Having explained this, the operational item models are in the Configuration Item layer, which share the same information when that CI is also an Asset, such as (Computers, Servers, Network Equipment, Storage, etc.) as Infrastructure;

6 - Using the correct modeling we have Services (Technical or Business) > Offerings (Technical or Business) > Application Service > Configuration items. Note that because it's something 'in production / deployed' that supports the services and their offerings, we don't relate Assets to Application Services. That's because it doesn't make sense.

7 - Using Query Builder and respecting the CSDM, you can identify all the CI's and their models (which are synced with assets) to tell which Application Services use certain technology models associated with certain offers and services, without the need for customization;

8 - If the requester would still like to see this directly associated with the Business Service, I would follow the path of first adjusting the modeling, then creating an M2M table, with an associated flow to run 1x a day, capturing all the hardware/software/application models of CI's that are associated with an Application Service that serves a certain service and recording this information in this table, adjusting the Business Service related list to see this information. This would ensure that I am respecting the ITAM/ITSM/CMDB and still using the CSDM as the basis for customization.