Share via

Azure Resource Graph-exempelfrågor för Azure Orbital Ground Station

  • Artikel

Den här sidan är en samling Azure Resource Graph-exempelfrågor för Azure Orbital Ground Station. En fullständig lista över Azure Resource Graph-exempel finns i Resource Graph-exempel efter kategori och Resource Graph-exempel efter tabell.

Exempelfrågor

Lista kommande kontakter

Sorterad efter reservationsstarttid

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

Sorterad efter markstation

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

Sorterat efter kontaktprofil

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

Visa en lista över kontakter från de senaste x dagarna

Sorterad efter reservationsstarttid

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

På en angiven markstation

Den här frågan hjälper kunder att spåra alla tidigare kontakter sorterade efter reservationsstarttid för en angiven markstation.

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

På angiven kontaktprofil

Den här frågan hjälper kunder att spåra alla tidigare kontakter sorterade efter reservationsstarttid för en angiven kontaktprofil.

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