Find azure servers from the cmdb_ci_server table

[Nikita Kale]

Hi all

Is there a field from which we can determine that a server is an azure server in the cmdb_ci-server table?

I know that there is a field called 'is virtual', but that would help to distinguish between physical & virtual servers.

I would like to get all the azure servers from that table. 

Any help would be appreciated!

Thanks

[Syedmd08]

Yes, there is a field in the cmdb_ci_server table that can be used to determine if a server is hosted on Azure. The field is called "discovery_source" and it stores the name of the discovery probe that was used to discover the server.

If the server was discovered using the Azure discovery probe, then the value of the discovery_source field will be "Azure". You can use this information to filter the cmdb_ci_server table and retrieve all the servers that were discovered using the Azure probe.

Here's an example query that you can use:

SELECT * FROM cmdb_ci_server WHERE discovery_source = 'Azure'

This query will retrieve all the servers from the cmdb_ci_server table that were discovered using the Azure probe.

Please mark my reply as Helpful and/or Accept Solution, if applicable. Thanks!

[Nikita Kale]

Hi @Syedmd08 

Thanks for the information. Unfortunately, I can't see records with discovery_source = 'Azure'. Majority of them have discovery_source = 'ServiceNow'. Few have SCCM, but that's it. 

Thanks,

Nikita Kale

[alkindis]

Was this ever solved, I have the same requirement and discovery_source doesnt have any entries for Azure!