Best way to store Email Boxes and Accounts in CMDB Tables

Nisha30 · ‎08-29-2024

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 · ‎08-29-2024

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.
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.
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.

View solution in original post

HIROSHI SATOH · ‎08-30-2024

' cmdb_ci_user_account' was a CMDB you extended yourself. Create it by extending from CMDB_CI.

Nisha30 · ‎09-02-2024

is it a out -of box table or custom? when we create it be a custom one

HIROSHI SATOH · ‎09-02-2024

This is a custom table that you created by extending CMDB_CI. Tables that are extended from CMDB_CI do not count against the license limit for the number of tables that you can create.