last login

%3CLINGO-SUB%20id%3D%22lingo-sub-961172%22%20slang%3D%22en-US%22%3Elast%20login%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-961172%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Experts%3C%2FP%3E%3CP%3EI%20want%20to%20pull%20all%20my%20users%20who%20have%20powerbi%20license%20assigned%20and%20visio%20license%20assigned%20with%20last%20time%20used%20or%20logged%20in%2C%20is%20it%20possible%20to%20export%20this%20information.%20using%20the%20below%20syntax%20i%20can%20export%20the%20license%20but%20how%20can%20i%20get%20the%20last%20time%20used%20or%20logged%20in%20information.%3C%2FP%3E%3CP%3EGet-MsolUser%20-All%20%7C%20Where-Object%20%7B(%24_.licenses).AccountSkuId%20-match%20%22VISIOCLIENT%22%7D%20%7C%20Export-Csv%20c%3A%5Coutput.csv%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-961172%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExchange%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Groups%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-963985%22%20slang%3D%22en-US%22%3ERe%3A%20last%20login%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-963985%22%20slang%3D%22en-US%22%3EHi%20Roger%2C%3CBR%20%2F%3EYou%20can%20get%20and%20export%20the%20users%20logins%2C%20(%20only%20for%20PowerBi%20or%20another%20apps%20)%2C%20thorugh%20the%20Azure%20Admin%20Center%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-bi%2Fservice-admin-access-usage%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-bi%2Fservice-admin-access-usage%3C%2FA%3E%3CBR%20%2F%3EI%20guess%20this%20is%20what%20you're%20looking%20for...%3CBR%20%2F%3EBest%20Regards.%3C%2FLINGO-BODY%3E
Frequent Contributor

Hi Experts

I want to pull all my users who have powerbi license assigned and visio license assigned with last time used or logged in, is it possible to export this information. using the below syntax i can export the license but how can i get the last time used or logged in information.

Get-MsolUser -All | Where-Object {($_.licenses).AccountSkuId -match "VISIOCLIENT"} | Export-Csv c:\output.csv

1 Reply
Hi Roger,
You can get and export the users logins, ( only for PowerBi or another apps ), thorugh the Azure Admin Center: https://docs.microsoft.com/en-us/power-bi/service-admin-access-usage
I guess this is what you're looking for...
Best Regards.