/****************************** Module Header ******************************\
* Module Name: Program.cs
* Project:     GetClassicVMInfo
* Copyright (c) Microsoft Corporation.
* 
* Managing Azure in Role instance may be difficult, because it requires a client 
* certificate. This sample will show how to use the base64 string certificate 
* instead of getting the certificate from Certificates store
* 
* This source is subject to the Microsoft Public License.
* See http://www.microsoft.com/en-us/openness/licenses.aspx#MPL
* All other rights reserved.
* 
* THIS CODE AND INFORMATION IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, 
* EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED 
* WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE.
\***************************************************************************/
using System;
using System.Linq;
using System.Security.Cryptography.X509Certificates;
using System.Xml.Linq;
using System.Net;
using System.IO;
namespace GetClassicVMInfo
{
    class Program
    {
        public static string credentialsPath = @"your.publishsettings";
        public static string subscriptionId = "subscriptionId";
        public static string cloudServiceName = "cloudServiceName";
        public static string deploymentName = "deploymentName";
        static void Main(string[] args)
        {
            XElement x=XElement.Load(credentialsPath);
            var Base64cer = (from c in x.Descendants("Subscription")
                                where c.Attribute("Id").Value == subscriptionId
                                select c.Attribute("ManagementCertificate").Value).FirstOrDefault();
            X509Certificate2 cer = null;
            if (Base64cer != null)
            {
                cer = new X509Certificate2(Convert.FromBase64String(Base64cer));
            }
            if (cer != null)
            {
                GetHostedServicesByRESTAPI(subscriptionId, cer);
            }
            Console.ReadLine();        
        }
        static void GetHostedServicesByRESTAPI(string subscriptionId, X509Certificate2 certificate)
        {
            string uri = string.Format("https://management.core.chinacloudapi.cn/{0}/services/hostedservices/{1}/deployments/{2}", subscriptionId, cloudServiceName, deploymentName);
            HttpWebRequest request = (HttpWebRequest)WebRequest.Create(new Uri(uri));
            request.Method = "GET";
            request.ClientCertificates.Add(certificate);
            request.ContentType = "application/xml";
            request.Headers.Add("x-ms-version", "2016-06-01");
            try
            {
                HttpWebResponse response = (HttpWebResponse)request.GetResponse();
                // Parse the web response.
                Stream responseStream = response.GetResponseStream();
                StreamReader reader = new StreamReader(responseStream);
                string xml = reader.ReadToEnd();                
                XDocument doc = XDocument.Parse(xml);
                XNamespace ns = doc.Root.Name.Namespace;
                XElement roleInstanceList = doc.Root.Element(ns + "RoleInstanceList");
                if (roleInstanceList != null)
                {
                    foreach (XElement roleInstance in roleInstanceList.Elements())
                    {
                        Console.WriteLine("InstanceName:"+roleInstance.Element(ns + "InstanceName").Value);
                        Console.WriteLine("InstanceStatus:" + roleInstance.Element(ns + "InstanceStatus").Value);
                    }
                }
                // Close the no longer needed resources.
                response.Close();
                responseStream.Close();
                reader.Close();
                Console.ReadKey();
            }
            catch (WebException ex)
            {
                Console.Write(ex.Response.Headers.ToString());
                Console.Read();
            }
           
        }
    }
}

Resources
| project name, location, type
| where type =~ 'Microsoft.ClassicCompute/virtualMachines'
| order by name desc