Getting Server Names from the CMDB_CI_CERTIFICATE from the SUBJECT_ALTERNATIVE_NAME Field

[StevenAgFirst]

I am trying to get the server names that are defined on the subject_alternative_name variable in the cmdb_ci_certificate CI. It looks to be a bunch of sys_ids but I cannot figure out how to find the server names from these:

"subject_alternative_name": "5cc0ac753b476e50c63e2f9aa4e45aa5,50c0ac753b476e50c63e2f9aa4e45aa6,54c0ac753b476e50c63e2f9aa4e45aa6,58c0ac753b476e50c63e2f9aa4e45aa6,5cc0ac753b476e50c63e2f9aa4e45aa6,50c0ac753b476e50c63e2f9aa4e45aa7,54c0ac753b476e50c63e2f9aa4e45aa7,58c0ac753b476e50c63e2f9aa4e45aa7,5cc0ac753b476e50c63e2f9aa4e45aa7"

I tried going straight to the cmdb_ci_win_server table and also tried the cmdb_rel_ci table but neither seemed to pull the server name. 

Can someone please help me figure out how to get the server name from this field. I am using visual basic using a get command to put the certificate information.

I appreciate anything you can tell me. Thank you in advance.

[Maik Skoddow · Accepted solution]

Hi @StevenAgFirst 

in the dictionary you can see that mentioned field is of type "List" (comma-separated list of Sys IDs) referencing the the Table Certificate Domain:

However that table does not contain any information about servers.

Maik

[StevenAgFirst]

Thank you Maik. That works perfectly. I really appreciate it.

Steven