Storing Azure Application in servicenow table

[Akshaya5]

Hi Team,

we have a requirement to store the Azure Ad Application in servicenow table can u please suggest which CMDB table can be used for this purpose. After that they want to sync between the CMDB to Azure AD. Please give some suggestions.

Apart from this they want have 3 more table
1. To store the service Account

FirstName

LastName

DisplayName

SamAccountName

UserPrincipalName

AccountExpirationDate

Account Status

Privileges

LogonWorkstations

Availability

Domain

License Requirement

MFA Enforced

Request/Change Request ID

Created Date

Business Justification

Primary Owner

Secondary Owner

Primary Owner Department

2. To store SAML Application

Application Name

Application ID

Tenant Name

Tenant ID

AccountEnabled

Application Owners

Access Granted to Users/Groups

Assignment Required

Gallery Visible

API Permissions

IdentifierID

Homepage URL

ReplyUrl

LogoutUrl

ClientSecretDescription

ClientSecretStartDate

ClientSecretEndDate

3. To store Azure Tenant

Sl No

Tenant Name

Tenant ID

Primary domain

License

Country or region

Data location

Federated Domain

Purpose (Description)

Tenant build for

Critical

Change Request

When Created

Expiry Date

Remarks

Account Name

Project Name

Primary Owner

Secondary Owner

Tenant State

[J Siva]

Hi @Akshaya5 
As there's no OOB CMDB classes tables to store service account and other details.
So you can create custom CI classes to load/manage those data.
Then for integration you can use, MS EntraID spoke.
Hope this helps,
Siva