{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":31079,"path":"it-operations-management/itom-visibility/data-collected-azure-discovery.md","title":"Data collected for Microsoft Azure Cloud Discovery","bundle":null,"doc_type":null,"release":"australia","body":"\n# Data collected for Microsoft Azure Cloud Discovery\n\nDiscovery collects information about cloud resources in Microsoft Azure datacenters. Discovering some of these resources might require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.\n\n## Request apps on the Store\n\nVisit the [ServiceNow Store](https://store.servicenow.com/sn_appstore_store.do#!/store/home) to view all the available apps, and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the [ServiceNow Store version history release notes](https://www.servicenow.com/docs/r/store-release-notes/sn-store-release-notes.html).\n\n## Prerequisites\n\n- **Verify that the applications are up to date**\n - Discovery and Service Mapping Patterns\n - CMDB CI Class Models\n - Visibility Content\n- **Create Azure cloud credentials**\n\n Create Microsoft Azure credentials that can access the Microsoft Azure account. For more information, see [Create Azure cloud credentials](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-operations-management/discovery/create-azure-cloud-credentials.md).\n\n- **Configure a discovery schedule**\n\n [Create a discovery schedule in Cloud Discovery Workspace](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-operations-management/discovery/cloud-operations-disco-create-schedule.md)\n\n\n## Verify the REST API permissions\n\nDownload the [Cloud Discovery patterns spreadsheet](https://downloads.docs.servicenow.com/resource/enus/api/servicenow-discovery-patterns-api-details.xlsx) so you can grant user permissions required for running the Discovery patterns. In addition to permissions, the spreadsheet also includes useful information such as pattern names, types, CI Classes, and links to vendor documentation. New patterns are available quarterly, so check periodically to be sure you have the latest version of the spreadsheet.\n\n## How Discovery finds Microsoft Azure resources\n\nDiscovery uses the Cloud Provisioning and Governance API and Discovery and Service Mapping Patterns to find cloud resources.\n\n\n
\n\nPattern\n\n\n\nDescription\n\n
\n\nAzure DataBase \\(LP\\)\n\n\n\nDiscovers database types of:\n\n- Microsoft.sql/servers\n- microsoft.sql/managedInstances\n- microsoft.dbformysql\n- microsoft.documentdb/databaseaccounts\n- microsoft.cache/redis\n- microsoft.dbforpostgresql/servers\n- microsoft.dbformysql/servers\n- microsoft.dbformysql/flexibleservers\n- microsoft.dbforpostgresql/flexibleservers\n\n Populates the \\[cmdb\\_ci\\_cloud\\_database\\] table.\n\n
\n\nAzure LoadBalancer TD\n\n\n\nRetrieves Microsoft Azure load balancers and populates the cmdb\\_ci\\_lb\\_service table. This pattern is only used by Service Mapping for top-down discovery, not by the Discovery application for horizontal discovery.\n\n
\n\nAzure WebSite \\(LP\\)\n\n\n\nRetrieves Microsoft Azure web servers and populates the Cloud WebServers \\[cmdb\\_ci\\_cloud\\_webserver\\] and IP address \\[cmdb\\_ci\\_ip\\_address\\] tables.\n\n
## Data collected by Discovery during horizontal discovery\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n|Region|region|\n|Object ID|object\\_id|\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n|State|state|\n|Object ID|object\\_id|\n|CPUs|cpus|\n|Disks|disks|\n|Disks size \\(GB\\)|disks\\_size|\n|Memory|memory|\n|Network adapters|nics|\n|VM Instance ID|vm\\_inst\\_id|\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n|Object ID|object\\_id|\n|State|state|\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n|Object ID|object\\_id|\n|Guest OS|guest\\_os|\n|Image source|image\\_source|\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n|State|state|\n|Object ID|object\\_id|\n|Storage type|storage\\_type|\n|Size|size|\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n|State\\*|state|\n|CIDR\\*|cidr|\n\n\\*Not found on VMware vCenter networks.\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n|Status|status|\n|CIDR|cidr|\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n|Netmask|netmask|\n|MAC Address|mac\\_address|\n|MAC Manufacturer|mac\\_manufacturer|\n|Status|install\\_status|\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n|Object ID|object\\_id|\n|State|state|\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n|Provisioning state|provisioning\\_state|\n\n**Note:** This table is only available for Discovery when the Cloud Provisioning and Governance plugin is activated.\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n|Object ID|object\\_id|\n|State|state|\n|Operational Status|operational\\_status|\n|Install Status|install\\_status|\n\n**Note:**\n\n- When a resource group is discovered for the first time, the **State** field is set to **Available**, **operational\\_status=Operational**, and **Status=Installed**; based on the response mapping.\n- When a resource group is terminated on Microsoft Azure, the CMPReconciler scripts set the **State** field to **Terminated**, and **operational\\_status=Non-Operational** and **Status=Absent**.\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n|Object ID|object\\_id|\n|Public IP address|public\\_ip\\_address|\n|Public DNS|public\\_dns|\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n|Object ID|object\\_id|\n|Sku Name|sku\\_name|\n|State|state|\n\n\n
\n\nLabel\n\n\n\nField Name\n\n
\n\nFully qualified domain name\n\n\n\nfqdn\n\n
\n\nName\n\n\n\nname\n\n
\n\nObject ID\n\n\n\nobject\\_id\n\n
\n\nOperational Status\n\n\n\noperational\\_status\n\n
\n\nType\n\n\n\ntype\n\n
\n\nState\n\n\n\nstate\n\n
\n\nVendor\n\n\n\nvendor\n\n
\n\nVersion\n\n\n\nversion**Note:** For NoSQL and MSSQL Managed Instances, the API responses for these databases do not return version data.\n\n
\n\nCategory\\*\n\n\n\ncategory\n\n
\\* Populated only by the Azure SQL Managed Instance license pattern extension. For more information, see the \"Azure SQL Managed Instance license discovery\" section in [Microsoft Azure Cloud discovery using patterns](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-operations-management/discovery-and-service-mapping-patterns/azure-cloud-discovery-patterns.md).\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n|Install status|install\\_status|\n|Vendor|vendor|\n|Fully qualified domain name|fqdn|\n|Operational status|operational\\_status|\n|State|state|\n\n|Label|Field Name|\n|-----|----------|\n|Fully qualified domain name|fqdn|\n|Install status|install\\_status|\n|IP Address|ip\\_address|\n|Name|name|\n|Netmask|netmask|\n|Operational status|operational\\_status|\n|Vendor|vendor|\n\n|Label|Field Name|\n|-----|----------|\n|Life-cycle Stage Status|life\\_cycle\\_stage\\_status|\n|Name|name|\n|Status|status|\n|Serial Number|serial\\_number|\n|Type|type|\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n|Object ID|object\\_id|\n|VCPUS|vcpus|\n\n|Label|Field Name|\n|-----|----------|\n|Name|name|\n|Object ID|object\\_id|\n|Provider|provider|\n|vCPUs|vcpus|\n\n**Parent Topic:**[Cloud resource discovery references](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-operations-management/itom-visibility/cloud-discovery-collected-data.md)\n\n**Related topics** \n\n\n[Microsoft Azure Cloud discovery using patterns](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-operations-management/discovery-and-service-mapping-patterns/azure-cloud-discovery-patterns.md)\n\n[Service Graph Connector for Microsoft Azure](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/servicenow-platform/cmdb-integration-azure.md)\n\n[Agent Client Collector Discovery](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-operations-management/agent-client-collector/acc-discovery.md)\n\n"}}