Pulling my hair out this week - I’m trying to curate a custom CSV dataset using graph in Powershell which basically gives me a list of users, their associated groups, and other useful information so I can create some visuals for reporting about users/groups in my organisation. Any advice? Cheers
@@microsoftgraphExplorer thanks - so I’m looking to compile a csv file with the following schema UserID,username(s),mail,userprincipalname,groupId(s) they belong to, group description - and any other useful information. The goal is to put this dataset into power bi and create a one page dashboard that gives info on users and group - any ideas would be appreciated thanks
Im trying to get the user ids of all the users and the user presence using graph api and powershell. Could you help me with that? And can youplease add the code in the description that you used for this video?
Pulling my hair out this week - I’m trying to curate a custom CSV dataset using graph in Powershell which basically gives me a list of users, their associated groups, and other useful information so I can create some visuals for reporting about users/groups in my organisation. Any advice? Cheers
You can use groups endpoint with members endpoint, or if you give me more details probably I can help you in better way.
@@microsoftgraphExplorer thanks - so I’m looking to compile a csv file with the following schema UserID,username(s),mail,userprincipalname,groupId(s) they belong to, group description - and any other useful information. The goal is to put this dataset into power bi and create a one page dashboard that gives info on users and group - any ideas would be appreciated thanks
Can we schedule the PS Script to run as a scheduled task using the above authentication?
Yes that can be done since we are using the Client Credentails flow
Im trying to get the user ids of all the users and the user presence using graph api and powershell.
Could you help me with that?
And can youplease add the code in the description that you used for this video?