How to identify if a server is hosted in cloud vs onprem in cmdb_ci_server table.....

[Suggy]

We have servers hosted in on premise, few on google cloud, few in Azure, few in AWS etc.

If we go to cmdb_ci_server table, is there a way to identify where the server is hosted?

[Slava Savitsky]

Look at the CI relationships and check what data center your server is related to. For cloud resources, there are tables like AWS Datacenter [cmdb_ci_aws_datacenter], Azure Datacenter [cmdb_ci_azure_datacenter], and others that extend Logical Datacenter [cmdb_ci_logical_datacenter] table. For on-premise systems, there is Data Center [cmdb_ci_datacenter] table that represents physical data centers of your organization.

[Suggy]

Hi @Slava Savitsky  Our requirement is to track this from cmdb_ci_server table. We thought of creating custom attribute to track this, meanhwile posted here to see if there is any other way to identify them directly from server table.

[Slava Savitsky]

In the base system, there is no attribute for that on the server-level. By default, this information is supposed to be stored at the data center level, but you can definitely create a custom attribute in the server table if needed.

[SteveMacWWT]

This may sound like a silly question but... does it need to be tracked at the server level or does it need to be reported from the server level?

If it only needs to be reported (or viewed in a list) you could use CMDB Query Builder to show that information along with the rest of the CI info. That is one of the main intents of Query Builder so that you do not need to add custom attributes that can be 'retrieved' from elsewhere.