dotnet / arcade

Tools that provide common build infrastructure for multiple .NET Foundation projects.
MIT License
671 stars 346 forks source link

Figure out spending with the Azure Spend Kusto data #12567

Closed missymessa closed 1 year ago

missymessa commented 1 year ago

Using the data from Azure Spend, determine a query to divide the spend data by:

Tasks:

missymessa commented 1 year ago

Kusto query for our spending: https://dataexplorer.azure.com/clusters/azurespendro.westus/databases/CostAggregation?query=H4sIAAAAAAAAA9VYS2/cNhC++1cQvqwNhFmReqNwg8AJUB/SBklzNihyuFYskQuS8iPoj+9I+/baqLPaHKqTVhI/znwz881wp1Py2Vl1ac1JA4HMF/df52BUbWbkggy3l7atagPqgwji+pM14aZ5PPmH3N+AA/K1q7x09TzU1lwpcnFBTrMiy7moCqogkjSJNKOFYhXVuuJRpTIuI31KTghewihyNtz11/svn76At52T8O3LFbkRnpy65YOZs93cT1sBPjh7SqwjB6yjvYtUNp0P4E4HgPO1K3/XLX4k2jn5/YKImT2Ls1T1r33XtsLVP/ATG0RzaX1AbvDpWX97Zb55dU6qxw3AbyfTKbky2omB17q/+ylWzzbO7RM8eQ3BkzXAPs/b13PcKRsMBApmRm+gqR/WhPWsrz17LZo3Yu5vbPCr5e/evSPWNI8EHmofPNHOtoRFU85IsCSecn6IpaNsfJot1tTBOozWUeAGEockcMcBbGvvMR0kZo2zzQ4koUQBJh0oIjTysSB2lOVUdMF6KRoYyucoHqDZje0C9dI6cCNw7zCD7jyPWClmYILP4oSVSZZEeB2OeL0Nebwc6N28xTS1x4OkMxHgXjyOoBBX3tUKXJ9X0llvdXjrQXauDo8rxHpUsGvhwAhP53WLmtXaHdS9jC1/RgGebgXoTbC22abj+W0YH10Y1g+10YpenI9C1YCrsCXQPQcOhRSuvVYwb+zjNTan2UbUxiffWJ1UoEXXoAqAu6slVJ2n99hBO88P83xRZIvoDylNlZHYHOZd1dRyn9K9nPip5tN6JzWAQtiHAwtlScAOt/QwqFXF9slzoDFDM50LebudJYeEoBUGpVOp2t+uInoYmsQmoahH0IaibDpEHYWH/t1bd3svgsQ5yx3o44KoPvS1wawxohlSYJRlT8prDk5bhzxKOJ6utELe4MjZ2NlxjHyp3FasHE/DXmD89Hng8/Wv851zwpNRujabV5vheKLjrIhwwqYJjxVN4pzTMmUpFXHByohxmZR88qbf+YMNf0L4iDM9Je9/fPhrgyFFlaVaxlRFOQJluaJlzDSNy5iDqHALFS8w/ug5/LrQ5c16kWiZpiyhnIkSDSkzWmmhaSpzgFyLOFVsbYMZbMDAQq/EZCmmfoNWJCJLZSloXqAhSaoErVgkaCyYBC2hiLJogbaIH0WSnWj6NrpjFQhRlXGkaKpTThOGBlUpHkOgjLM85UmSQzUha6/o508fN5H4Vcesy36easFN+5NsJ8Nw4pLLh/+jQxdGsZ+FGfi+olZVs+fda+GWYkTvON3I3Fg0fiS4J9W9dJ0u2/TDeO/fWoz2ttHqWJjH9367Yy57nJDSdsPJ47/2GSV1/TWJskrEOcQ0kzxCucPkLlSiaSmyKo8U16DZtjgsJt8o3kURmcAS0BVleQ5YHaCp0ClDwYpRvRiDSqfPoOwOWxNdSKbTOKNclBUKTCVoWWQFLRiTsix4VfHnUHan+EmSR5FOEkZBxoiScETR6JZOZQW8iAFEspCpHZTkF2vVk3/XEOS7xbjc1kZd1Mbg9Ln7P5E1m9XPfLwncdvfE1yA+30HGTYP36z+7BuWoLkBIcPZ2oHzN4vx/YXXDN9fbm+6/wk//xdEo/jDUhQAAA==