Ukázkové dotazy Azure Resource Graphu pro azure Orbital Ground Station

  • Článek

Tato stránka je kolekce ukázkových dotazů Azure Resource Graphu pro azure Orbital Ground Station. Úplný seznam ukázek Azure Resource Graphu najdete v ukázkách Resource Graphu podle kategorií a ukázek Resource Graphu podle tabulky.

Ukázkové dotazy

Seznam nadcházejících kontaktů

Seřazeno podle času zahájení rezervace

OrbitalResources  
| where type == 'microsoft.orbital/spacecrafts/contacts' and todatetime(properties.reservationStartTime) >= now()
| sort by todatetime(properties.reservationStartTime)
| extend Contact_Profile = tostring(split(properties.contactProfile.id, "/")[-1])
| extend Spacecraft = tostring(split(id, "/")[-3])
| project Contact = tostring(name), Groundstation = tostring(properties.groundStationName), Spacecraft, Contact_Profile, Status=properties.status, Provisioning_Status=properties.provisioningState

Seřazeno podle pozemní stanice

OrbitalResources 
| where type == 'microsoft.orbital/spacecrafts/contacts' and todatetime(properties.reservationStartTime) >= now() 
| sort by tostring(properties.groundStationName) 
| extend Contact_Profile = tostring(split(properties.contactProfile.id, "/")[-1]) 
| extend Spacecraft = tostring(split(id, "/")[-3]) 
| project Contact = tostring(name), Groundstation = tostring(properties.groundStationName), Spacecraft, Contact_Profile, Reservation_Start_Time = todatetime(properties.reservationStartTime), Reservation_End_Time = todatetime(properties.reservationEndTime), Status=properties.status, Provisioning_Status=properties.provisioningState

Seřazeno podle profilu kontaktu

OrbitalResources 
| where type == 'microsoft.orbital/spacecrafts/contacts' 
| where todatetime(properties.reservationStartTime) >= now()
| extend Contact_Profile = tostring(split(properties.contactProfile.id, "/")[-1]) 
| sort by Contact_Profile 
| extend Spacecraft = tostring(split(id, "/")[-3]) 
| project Contact = tostring(name), Groundstation = tostring(properties.groundStationName), Spacecraft, Contact_Profile, Reservation_Start_Time = todatetime(properties.reservationStartTime), Reservation_End_Time = todatetime(properties.reservationEndTime), Status=properties.status, Provisioning_Status=properties.provisioningState

Výpis kontaktů z minulých x dnů

Seřazeno podle času zahájení rezervace

OrbitalResources  
| where type == 'microsoft.orbital/spacecrafts/contacts' and todatetime(properties.reservationStartTime) >= now(-1d)  
| sort by todatetime(properties.reservationStartTime)  
| extend Contact_Profile = tostring(split(properties.contactProfile.id, "/")[-1]) 
| extend Spacecraft = tostring(split(id, "/")[-3]) 
| project Contact = tostring(name), Groundstation = tostring(properties.groundStationName), Spacecraft, Contact_Profile, Reservation_Start_Time = todatetime(properties.reservationStartTime), Reservation_End_Time = todatetime(properties.reservationEndTime), Status=properties.status, Provisioning_Status=properties.provisioningState

Na zadané pozemní stanici

Tento dotaz pomůže zákazníkům sledovat všechny minulé kontakty seřazené podle času zahájení rezervace pro zadanou pozemní stanici.

OrbitalResources 
| where type == 'microsoft.orbital/spacecrafts/contacts' and todatetime(properties.reservationStartTime) >= now(-1d) and properties.groundStationName == 'Microsoft_Gavle' 
| sort by todatetime(properties.reservationStartTime) 
| extend Contact_Profile = tostring(split(properties.contactProfile.id, "/")[-1]) 
| extend Spacecraft = tostring(split(id, "/")[-3]) 
| project Contact = tostring(name), Groundstation = tostring(properties.groundStationName), Spacecraft, Contact_Profile, Reservation_Start_Time = todatetime(properties.reservationStartTime), Reservation_End_Time = todatetime(properties.reservationEndTime), Status=properties.status, Provisioning_Status=properties.provisioningState

V zadaném profilu kontaktu

Tento dotaz pomůže zákazníkům sledovat všechny minulé kontakty seřazené podle času zahájení rezervace pro zadaný profil kontaktu.

OrbitalResources  
| where type == 'microsoft.orbital/spacecrafts/contacts'  
| extend Contact_Profile = tostring(split(properties.contactProfile.id, "/")[-1])  
| where todatetime(properties.reservationStartTime) >= now(-1d) and Contact_Profile == 'test-CP'  
| sort by todatetime(properties.reservationStartTime)  
| extend Spacecraft = tostring(split(id, "/")[-3])  
| project Contact = tostring(name), Groundstation = tostring(properties.groundStationName), Spacecraft, Contact_Profile, Reservation_Start_Time = todatetime(properties.reservationStartTime), Reservation_End_Time = todatetime(properties.reservationEndTime), Status=properties.status, Provisioning_Status=properties.provisioningState