Best way to store Email Boxes and Accounts in CMDB Tables

[Nisha30]

Hello Guys,

Please assist what would be best way for this goal:   "We only have ITSM Pro" nothing else

1) We want to store and aware of how many Email Exchanges, Servers, Accounts are present . Any way to discover them by any spoke available within ITSM pro?

2) Which table would be standard to store such information in case manually uploaded.

3) Regarding Power consumption (manually such as Electricity) which table should be best to upload data into.

Thanks

[HIROSHI SATOH]

1. 情報の手動アップロードの標準表:

   • Exchange サーバーまたは一般的なサーバーの場合、通常はcmdb_ci_serverテーブルが使用されます。 
   • cmdb_ci_email_server: A table to store information about email servers.
   • アカウントの場合は、 cmdb_ci_user_accountテーブルを使用できます。   

2. 電力消費データのアップロードに最適なテーブル:
   電力消費データを手動でアップロードする場合は、カスタム テーブルを作成するのが最適です。データを効率的に保存するために、関連するフィールド ( consumption_date、 power_usage など)を含む u_power_consumptionのようなテーブルを作成できます。   

[Nisha30]

sorry i could not understand its all in othre language. can you please translate to english

[HIROSHI SATOH · Accepted solution]

1. Discovering Exchange, Servers, and Accounts with ITSM Pro:
   ITSM Pro does not include the Discovery module, so there is no standard spoke available to automatically discover these items. However, you can use IntegrationHub to integrate with external systems. For example, you could build a custom integration using PowerShell scripts to gather Exchange, server, and account information and then import it into ServiceNow.

2. Standard Table for Manual Upload of Information:

   • For Exchange servers or general servers, the cmdb_ci_server table is typically used.
   • For Mail server, the cmdb_ci_email_server table is typically used.
   • For accounts, you can use the cmdb_ci_user_account table.

3. Best Table for Uploading Power Consumption Data:
   For manually uploading power consumption data, it might be best to create a custom table. You could create a table like u_power_consumption with relevant fields (e.g., consumption_date, power_usage, etc.) to store the data effectively.

[Nisha30]

hi @HIROSHI SATOH thanks for replying .

can not find the table 'cmdb_ci_user_account'  

Thanks