Share via

Consultas de ejemplo de Azure Resource Graph para Azure Orbital Ground Station

  • Artículo

Esta página es una colección de consultas de ejemplo de Azure Resource Graph para Azure Orbital Ground Station. Para obtener una lista completa de ejemplos de Azure Resource Graph, vea Ejemplos de Resource Graph por categoría y Ejemplos de Resource Graph por tabla.

Consultas de ejemplo

Enumerar los próximos contactos

Ordenado por hora de inicio de reserva

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

Ordenado por estación terrestre

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

Ordenado por perfil de contacto

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

Enumerar contactos de días anteriores 'x'

Ordenado por hora de inicio de reserva

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

En una estación terrestre especificada

Esta consulta ayudará a los clientes a realizar un seguimiento de todos los contactos anteriores ordenados por hora de inicio de reserva para una estación terrestre especificada.

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

En el perfil de contacto especificado

Esta consulta ayudará a los clientes a realizar un seguimiento de todos los contactos anteriores ordenados por hora de inicio de reserva para un perfil de contacto especificado.

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