Azure Log analytics query question

%3CLINGO-SUB%20id%3D%22lingo-sub-815025%22%20slang%3D%22en-US%22%3EAzure%20Log%20analytics%20query%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815025%22%20slang%3D%22en-US%22%3EI%20am%20looking%20to%20get%20a%20list%20of%20computer%20names%20and%20all%20the%20add-ins%20on%20that%20computer.%20The%20canned%20query%20for%20this%20returns%20an%20aggregated%20list%20of%20add-ins%20which%20is%20helpful%20at%20viewing%20the%20complexity%20of%20this%20task.%20Beyond%20that%20I%20need%20to%20see%20which%20PC's%20have%20which%20add-ins.%20I%20was%20able%20to%20get%20close%20with%20a%20query%2C%20but%20it%20did%20not%20list%20all%20computers%20in%20the%20environment%20and%20all%20of%20each%20computers%20add-ins.%20I%20suspect%20this%20is%20not%20terribly%20complicated%20for%20someone%20advanced%20with%20this%20query%20language.%20he%20canned%20query%20search%20in%20(UAOfficeAddIn)%20OfficeAddInName%20!%3D%20%22%22%20%7C%20summarize%20AggregatedValue%20%3D%20count(Computer)%20by%20OfficeAddInName%20%7C%20sort%20by%20AggregatedValue%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-815025%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor
I am looking to get a list of computer names and all the add-ins on that computer. The canned query for this returns an aggregated list of add-ins which is helpful at viewing the complexity of this task. Beyond that I need to see which PC's have which add-ins. I was able to get close with a query, but it did not list all computers in the environment and all of each computers add-ins. I suspect this is not terribly complicated for someone advanced with this query language. he canned query search in (UAOfficeAddIn) OfficeAddInName != "" | summarize AggregatedValue = count(Computer) by OfficeAddInName | sort by AggregatedValue
0 Replies