Forum Discussion
Azure Log Analytics for Server Uptime
Hello, Been working on this Kusto query. Just was wondering how do I get a specific order of columns. I want Computer as first column, Availability as second, Total_Hours as third, and Available_Ho...
You can add this as a last line source
| project-reorder Availability, Total_Hours, Available_HoursHowever that will leave Computer as the final column (there seems to be an issue with Computer as it was used in the summarized command e.g. you can only reorder columns that don't follow a 'by' operator); I'll ask internally as this isn't working as i'd expect or I'm not understanding the usage.
Go to Log Analytics and Run Query
| Availability | Total_Hours | Available_Hours | Computer |
|---|---|---|---|
| 33.60215053763441 | 744 | 250 | On-Premise-16S |
| 33.60215053763441 | 744 | 250 | OnPremise-12S |
@t does seems like this is actually to do with extended columns, I'm talking to the Product Group next week about this, and will keep you updated.
How much of an issue is it tmitchel ?
CliveWatson Running into this myself... was there ever a resolution for the extended columns not sorting?
