Azure Orbital Ground Station에 대한 Azure Resource Graph 샘플 쿼리

이 페이지는 Azure Orbital Ground Station에 대한 Azure Resource Graph 샘플 쿼리 모음입니다. Azure Resource Graph 샘플의 전체 목록은 범주별 Resource Graph 샘플 및 테이블별 Resource Graph 샘플을 참조하세요.

샘플 쿼리

예정된 접점 나열

예약 시작 시간별로 정렬

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

지상국별로 정렬

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 

접점 프로필별로 정렬

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

지난 'x'일의 접점 나열

예약 시작 시간별로 정렬

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 

지정된 지상국에서

이 쿼리는 고객이 지정된 지상국에 대한 예약 시작 시간을 기준으로 정렬된 모든 지난 접점을 추적하는 데 도움이 됩니다.

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 

지정된 접점 프로필에서

이 쿼리는 고객이 지정된 접점 프로필에 대한 예약 시작 시간을 기준으로 정렬된 모든 지난 접점을 추적하는 데 도움이 됩니다.

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