SOLVED
Home

How to get maximum scores by control Category?

%3CLINGO-SUB%20id%3D%22lingo-sub-1130653%22%20slang%3D%22es-ES%22%3EHow%20to%20get%20maximum%20scores%20by%20control%20Category%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1130653%22%20slang%3D%22es-ES%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3EI%20am%20starting%20to%20use%20the%20MS%20Graph%20connector%20from%20power%20by%20and%20I%20am%20trying%20to%20reproduce%20a%20very%20simple%20graph%2C%20I%20can%20get%20almost%20all%20the%20data%20except%20the%20maximum%20score%20per%20control%20category%3C%2FP%3E%3CP%3EIn%20the%20next%20picture%20I%20can%20get%2024%2F502%20but%20for%20each%20category%20I'm%20able%20to%20obtain%20the%20score%20but%20not%20the%20maximum%2C%20for%20example%20-%26gt%3B%20identity%20(18%2F223)%20I%20can%20get%20the%20score%2018%20but%20not%20the%20maximum%20223%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167429i8786226D82025AAC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3CP%3ELuis%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1130653%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3Ehelp%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1145664%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20get%20maximum%20scores%20by%20control%20Category%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1145664%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F533579%22%20target%3D%22_blank%22%3E%40lvillara%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20style%3D%22line-height%3A%2015.0pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.5pt%3B%20font-family%3A%20'Segoe%20UI'%2Csans-serif%3B%20color%3A%20%23333333%3B%22%3EBelow%20should%20help%20to%20get%20the%20aggregated%20score%20per%20control%20category%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CPRE%20style%3D%22line-height%3A%2015.0pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.5pt%3B%20font-family%3A%20'Segoe%20UI'%2Csans-serif%3B%20color%3A%20%23333333%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CPRE%20style%3D%22line-height%3A%2015.0pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.5pt%3B%20font-family%3A%20'Segoe%20UI'%2Csans-serif%3B%20color%3A%20%23333333%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FPRE%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20'Calibri'%2Csans-serif%3B%20color%3A%20%23201f1e%3B%22%3EThe%20customer%20should%20be%20using%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22text-indent%3A%20.5in%3B%20line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-family%3A%20'Calibri'%2Csans-serif%3B%20color%3A%20%23201f1e%3B%22%3E%3CA%20title%3D%22Original%20URL%3A%20https%3A%2F%2Fgraph.microsoft.com%2Fv1.0%2Fsecurity%2FsecureScores.%20Click%20or%20tap%20if%20you%20trust%20this%20link.%22%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fgraph.microsoft.com%252Fv1.0%252Fsecurity%252FsecureScores%26amp%3Bdata%3D04%257C01%257Cnaynam%2540microsoft.com%257C98691b4eafa74bc3d61a08d7a69b3016%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637161057782784947%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C-1%26amp%3Bsdata%3DuUks2wjLuo0peKoUjiuOUOTmTeSxR7pMGTa46zeUQZM%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.5pt%3B%20font-family%3A%20Consolas%3B%20background%3A%20%23FAFAFA%3B%22%3Ehttps%3A%2F%2Fgraph.microsoft.com%2Fv1.0%2Fsecurity%2FsecureScores%3C%2FSPAN%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-family%3A%20'Calibri'%2Csans-serif%3B%20color%3A%20%23201f1e%3B%22%3ETo%20get%20their%20score%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22controlCategory%22%3A%20%22Data%22%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22controlName%22%3A%20%22Enable%20mailbox%20auditing%20for%20all%20users%22%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22description%22%3A%20%22You%20should%20enable%20mailbox%20auditing%20for%20at%20least%20ninety%20percent%20of%20all%20users%20that%20have%20mailboxes%20in%20your%20tenancy.%20By%20default%20all%20non-owner%20access%20is%20audited%2C%20but%20you%20must%20enable%20auditing%20on%20the%20mailbox%20for%20owner%20access%20to%20also%20be%20audited.%20This%20will%20allow%20you%20to%20discover%20illicit%20access%20of%20Exchange%20Online%20activity%20if%20a%20user's%20account%20has%20been%20breached.%22%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%3CSPAN%20style%3D%22background%3A%20yellow%3B%22%3E%22score%22%3A%2010%2C%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22total%22%3A%20%2269%22%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22count%22%3A%20%2250%22%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-family%3A%20'Calibri'%2Csans-serif%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSTRONG%3E%3CSPAN%20style%3D%22font-family%3A%20'Calibri'%2Csans-serif%3B%20color%3A%20%23201f1e%3B%22%3EAnd%20then%20they%20can%20call%3A%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%20style%3D%22text-indent%3A%20.5in%3B%20line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-family%3A%20'Calibri'%2Csans-serif%3B%20color%3A%20%23201f1e%3B%22%3E%3CA%20title%3D%22Original%20URL%3A%20https%3A%2F%2Fgraph.microsoft.com%2Fv1.0%2Fsecurity%2FsecureScoreControlProfiles.%20Click%20or%20tap%20if%20you%20trust%20this%20link.%22%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fgraph.microsoft.com%252Fv1.0%252Fsecurity%252FsecureScoreControlProfiles%26amp%3Bdata%3D04%257C01%257Cnaynam%2540microsoft.com%257C98691b4eafa74bc3d61a08d7a69b3016%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637161057782789945%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C-1%26amp%3Bsdata%3DPpsM7tA%252FnjqKNbhZJzhbbwcehO4FXw6hI3ED%252BJaBntQ%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20style%3D%22font-family%3A%20'Segoe%20UI'%2Csans-serif%3B%22%3Ehttps%3A%2F%2Fgraph.microsoft.com%2Fv1.0%2Fsecurity%2FsecureScoreControlProfiles%3C%2FSPAN%3E%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSTRONG%3E%3CSPAN%20style%3D%22font-family%3A%20'Calibri'%2Csans-serif%3B%20color%3A%20%23201f1e%3B%22%3ETo%20get%20the%20max%20scores%20per%20control%20and%20group%20by%20control%20category%20an%20it%20should%20give%20max%20socre%20for%20that%20category%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22id%22%3A%20%22MailboxAuditingEnabled%22%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22azureTenantId%22%3A%20%2200000001-0001-0001-0001-000000000001%22%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22actionType%22%3A%20%22Config%22%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22actionUrl%22%3A%20%22%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20'Calibri'%2Csans-serif%3B%20color%3A%20%23201f1e%3B%22%3E%3CA%20title%3D%22Original%20URL%3A%20https%3A%2F%2Fgithub.com%2FOfficeDev%2FO365-InvestigationTooling%2Fblob%2Fmaster%2FEnableMailboxAuditing.ps1.%20Click%20or%20tap%20if%20you%20trust%20this%20link.%22%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fgithub.com%252FOfficeDev%252FO365-InvestigationTooling%252Fblob%252Fmaster%252FEnableMailboxAuditing.ps1%26amp%3Bdata%3D04%257C01%257Cnaynam%2540microsoft.com%257C98691b4eafa74bc3d61a08d7a69b3016%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637161057782799936%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C-1%26amp%3Bsdata%3DqO0Zarcre3MLsZaCIxW7tZ1XEiaX9WPixr2oXA3Ur8c%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%22%3Ehttps%3A%2F%2Fgithub.com%2FOfficeDev%2FO365-InvestigationTooling%2Fblob%2Fmaster%2FEnableMailboxAuditing.ps1%3C%2FSPAN%3E%3C%2FA%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%22%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3CSPAN%20style%3D%22background%3A%20yellow%3B%22%3E%26nbsp%3B%20%22controlCategory%22%3A%20%22Data%22%2C%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22title%22%3A%20%22Enable%20mailbox%20auditing%20for%20all%20users%22%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22deprecated%22%3A%20false%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22implementationCost%22%3A%20%22Low%22%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22lastModifiedDateTime%22%3A%20%222019-12-30T15%3A36%3A00Z%22%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%3CSPAN%20style%3D%22background%3A%20yellow%3B%22%3E%22maxScore%22%3A%2015%2C%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22rank%22%3A%206%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22remediation%22%3A%20%22Running%20the%20PowerShell%20script%20linked%20below%20will%20turn%20on%20owner%20activity%20mailbox%20auditing%20for%20all%20mailboxes%20in%20your%20service.%20By%20default%20all%20non-owner%20access%20and%20administrative%20actions%20are%20recorded%2C%20but%20owner%20actions%20are%20not.%20Enabling%20mailbox%20auditing%20will%20include%20owner%20activity%20in%20the%20audit%20records%2C%20which%20will%20in%20turn%20enable%20you%20to%20investigate%20and%20scope%20a%20compromise%20of%20that%20user's%20account.%22%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22remediationImpact%22%3A%20%22This%20change%20will%20have%20no%20effect%20on%20your%20users.%22%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%22service%22%3A%20%22EXO%22%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22threats%22%3A%20%5B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22Account%20Breach%22%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22line-height%3A%2015.0pt%3B%20tab-stops%3A%2045.8pt%2091.6pt%20137.4pt%20183.2pt%20229.0pt%20274.8pt%20320.6pt%20366.4pt%20412.2pt%20458.0pt%20503.8pt%20549.6pt%20595.4pt%20641.2pt%20687.0pt%20732.8pt%3B%20background%3A%20%23F8F8F8%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.0pt%3B%20font-family%3A%20Consolas%3B%20color%3A%20%23201f1e%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%5D%2C%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1157020%22%20slang%3D%22es-ES%22%3ERe%3A%20How%20to%20get%20maximum%20scores%20by%20control%20Category%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1157020%22%20slang%3D%22es-ES%22%3E%3CP%3EThank%20you%20very%20much%20Nayna%20Sheth%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi everyone,

I am starting to use the MS Graph connector from power by and I am trying to reproduce a very simple graph, I can get almost all the data except the maximum score per control category

In the next picture I can obtent 24/502 but for each category I'm able to obtain the score but not the maximum,  for example -> identity (18/223)  I can obten the score 18 but not the maximum 223

 

clipboard_image_0.png

Thanks in advance

Luis

 

 

2 Replies
Highlighted
Solution

@lvillara 

Below should help to get the aggregated score per control category
 
 

 The customer should be using:

https://graph.microsoft.com/v1.0/security/secureScores

To get their score

                {

                    "controlCategory": "Data",

                    "controlName": "Enable mailbox auditing for all users",

                    "description": "You should enable mailbox auditing for at least ninety percent of all users that have mailboxes in your tenancy. By default all non-owner access is audited, but you must enable auditing on the mailbox for owner access to also be audited. This will allow you to discover illicit access of Exchange Online activity if a user's account has been breached.",

                    "score": 10,

                    "total": "69",

                    "count": "50"

                },

 

And then they can call:

https://graph.microsoft.com/v1.0/security/secureScoreControlProfiles

To get the max scores per control and group by control category an it should give max socre for that category

        {

            "id": "MailboxAuditingEnabled",

            "azureTenantId": "00000001-0001-0001-0001-000000000001",

            "actionType": "Config",

            "actionUrl": "https://github.com/OfficeDev/O365-InvestigationTooling/blob/master/EnableMailboxAuditing.ps1",

            "controlCategory": "Data",

            "title": "Enable mailbox auditing for all users",

            "deprecated": false,

            "implementationCost": "Low",

            "lastModifiedDateTime": "2019-12-30T15:36:00Z",

            "maxScore": 15,

            "rank": 6,

            "remediation": "Running the PowerShell script linked below will turn on owner activity mailbox auditing for all mailboxes in your service. By default all non-owner access and administrative actions are recorded, but owner actions are not. Enabling mailbox auditing will include owner activity in the audit records, which will in turn enable you to investigate and scope a compromise of that user's account.",

            "remediationImpact": "This change will have no effect on your users.",

            "service": "EXO",

            "threats": [

                "Account Breach"

            ],

Highlighted

Thank you very much Nayna Sheth

Related Conversations