Can I use the App ID in the Teams Admin Apps Usage report to find what Team is using it?

%3CLINGO-SUB%20id%3D%22lingo-sub-1860976%22%20slang%3D%22en-US%22%3ECan%20I%20use%20the%20App%20ID%20in%20the%20Teams%20Admin%20Apps%20Usage%20report%20to%20find%20what%20Team%20is%20using%20it%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1860976%22%20slang%3D%22en-US%22%3E%3CP%3EAny%20ideas%20how%20I%20can%20use%20the%20report%20to%20look%20up%20which%20Team%2Fs%20are%20using%20a%20particular%20app%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EReport%20spreadsheet%20shows%20me%20I've%2048%20Teams%20using%20Trello%20-%20but%20which%20ones%3F%3C%2FP%3E%3CP%3EId%20%7C%20AppName%20%7C%20ActiveUsers%20%7C%20AppType%20%7C%20ActiveTeams%20%7C%20Publisher%26nbsp%3BVersion%3C%2FP%3E%3CTABLE%20width%3D%22910%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3E49e6f432-d79c-49e8-94f7-89b94f3672fd%3C%2FTD%3E%3CTD%3ETrello%3C%2FTD%3E%3CTD%3E87%3C%2FTD%3E%3CTD%3E3P%3C%2FTD%3E%3CTD%3E48%3C%2FTD%3E%3CTD%3ETrello%3C%2FTD%3E%3CTD%3E1.2%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20Darrel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1860976%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdministrator%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAnalytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1861495%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20use%20the%20App%20ID%20in%20the%20Teams%20Admin%20Apps%20Usage%20report%20to%20find%20what%20Team%20is%20using%20it%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1861495%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F149237%22%20target%3D%22_blank%22%3E%40Darrel%20Richardson%3C%2FA%3E%26nbsp%3B%20%26nbsp%3BI'm%20going%20to%20include%20links%20to%20resources%20that%20will%20describe%20the%20usage%20reports%20available%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fadmin%2Factivity-reports%2Fmicrosoft-teams-device-usage%3Fview%3Do365-worldwide%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fadmin%2Factivity-reports%2Fmicrosoft-teams-device-usage%3Fview%3Do365-worldwide%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoftteams%2Fteams-analytics-and-reports%2Fdevice-usage-report%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoftteams%2Fteams-analytics-and-reports%2Fdevice-usage-report%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBlog%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fmicrosoft-teams-blog%2Fnew-usage-reports-for-microsoft-teams%2Fba-p%2F132614%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fmicrosoft-teams-blog%2Fnew-usage-reports-for-microsoft-teams%2Fba-p%2F132614%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1861871%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20use%20the%20App%20ID%20in%20the%20Teams%20Admin%20Apps%20Usage%20report%20to%20find%20what%20Team%20is%20using%20it%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1861871%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20try%20this%20script%20I%20put%20together%20a%20while%20back%2C%20should%20give%20you%20per%20team%2Fchannel%20info%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.michev.info%2FBlog%2FPost%2F2829%2Freporting-on-teams-apps-and-tabs%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.michev.info%2FBlog%2FPost%2F2829%2Freporting-on-teams-apps-and-tabs%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Contributor

Any ideas how I can use the report to look up which Team/s are using a particular app?

 

Report spreadsheet shows me I've 48 Teams using Trello - but which ones?

Id | AppName | ActiveUsers | AppType | ActiveTeams | Publisher Version

49e6f432-d79c-49e8-94f7-89b94f3672fdTrello873P48Trello1.2

 

Thanks, Darrel

2 Replies

You can try this script I put together a while back, should give you per team/channel info: https://www.michev.info/Blog/Post/2829/reporting-on-teams-apps-and-tabs

@Vasil Michev Thanks Vasil. A little too much for my modest knowledge at this time. I might tackle that once I have some more foundational knowledge.