How to determine what columns the sharepoint visitors group has












2















I have this line:



get-pnpgroupmembers -identify "visitors group" | select title, email


The code above gives me all members of the visitors group. I found the column Title and email, how can I find the other columns?



P










share|improve this question























  • In your example, -identify should be -identity.

    – Mike Smith - MCT - MVP
    2 days ago
















2















I have this line:



get-pnpgroupmembers -identify "visitors group" | select title, email


The code above gives me all members of the visitors group. I found the column Title and email, how can I find the other columns?



P










share|improve this question























  • In your example, -identify should be -identity.

    – Mike Smith - MCT - MVP
    2 days ago














2












2








2


0






I have this line:



get-pnpgroupmembers -identify "visitors group" | select title, email


The code above gives me all members of the visitors group. I found the column Title and email, how can I find the other columns?



P










share|improve this question














I have this line:



get-pnpgroupmembers -identify "visitors group" | select title, email


The code above gives me all members of the visitors group. I found the column Title and email, how can I find the other columns?



P







sharepoint-online pnp-powershell






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked 2 days ago









Peter KiersPeter Kiers

1147




1147













  • In your example, -identify should be -identity.

    – Mike Smith - MCT - MVP
    2 days ago



















  • In your example, -identify should be -identity.

    – Mike Smith - MCT - MVP
    2 days ago

















In your example, -identify should be -identity.

– Mike Smith - MCT - MVP
2 days ago





In your example, -identify should be -identity.

– Mike Smith - MCT - MVP
2 days ago










3 Answers
3






active

oldest

votes


















5














For most PowerShell cmdlets, try something like this:



get-pnpgroupmembers -identity "visitors group" | select *


or



get-pnpgroupmembers -identity "visitors group" | Get-Member


As the PNP cmdlets are not populating all of the CSOM properties, you will get an error with "select *", and selecting some of the properties returned by Get-Member like Alerts and Groups will return errors.



While not of the properties all are useful, these are selectable:



AadObjectId,
Email,
Id,
IsEmailAuthenticationGuestUser,
IsHiddenInUI,
IsShareByEmailGuestUser,
IsSiteAdmin,
LoginName,
ObjectVersion,
Path,
PrincipalType,
ServerObjectIsNull,
Tag,
Title,
TypedObject,
UserId



get-pnpgroupmembers -identity "visitors group" | select AadObjectId,
Email,Id,IsEmailAuthenticationGuestUser,IsHiddenInUI,IsShareByEmailGuestUser,
IsSiteAdmin,LoginName,ObjectVersion,Path,PrincipalType,ServerObjectIsNull,
Tag,Title,TypedObject,UserId


As you will see, there aren't too many columns to choose from. What data are you looking for? You may need to query the User Profile Services for more user data.






share|improve this answer































    3














    I don't know the exact number of user properties in each sharepoint version. But you can use below links to see the list of default user profile properties in SharePoint 2010,2013 and Office 365.
    Using this properties you can query your groups.



    Sources:




    1. Default user profile properties (SharePoint Server 2010).


    2. Default user profile property mappings.


    3. O365 User Profile Property Creation.



    Using 3rd link, follow the steps given and you can navigate to "Manager User Properties" in SharePoint admin center. Where you can see the basic default user profile properties.






    share|improve this answer































      3














      In general you can use wildcards (*) with the select pipe. This works with any variable that has properties. To select ALL properties and see what their values are you can do something like the following:



      get-pnpgroupmembers -identify "visitors group" | select *



      Unfortunately if you have a lot of items in your pipeline from get-pnpgroupmembers you'll get spammed with every property from each item. So if you want to find some specific columns for your object type you could call the function below, find your columns, and replace the * -first 1 with your comma separated list of columns.



      get-pnpgroupmembers -identify "visitors group" | select * -first 1




      An easy example:



      Get-ChildItem . | select * -First 1



      and turned it into the following, after selecting which columns I needed:



      Get-ChildItem . | select BaseName,LastWriteTime,Attributes







      share|improve this answer























        Your Answer








        StackExchange.ready(function() {
        var channelOptions = {
        tags: "".split(" "),
        id: "232"
        };
        initTagRenderer("".split(" "), "".split(" "), channelOptions);

        StackExchange.using("externalEditor", function() {
        // Have to fire editor after snippets, if snippets enabled
        if (StackExchange.settings.snippets.snippetsEnabled) {
        StackExchange.using("snippets", function() {
        createEditor();
        });
        }
        else {
        createEditor();
        }
        });

        function createEditor() {
        StackExchange.prepareEditor({
        heartbeatType: 'answer',
        autoActivateHeartbeat: false,
        convertImagesToLinks: false,
        noModals: true,
        showLowRepImageUploadWarning: true,
        reputationToPostImages: null,
        bindNavPrevention: true,
        postfix: "",
        imageUploader: {
        brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
        contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
        allowUrls: true
        },
        onDemand: true,
        discardSelector: ".discard-answer"
        ,immediatelyShowMarkdownHelp:true
        });


        }
        });














        draft saved

        draft discarded


















        StackExchange.ready(
        function () {
        StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsharepoint.stackexchange.com%2fquestions%2f255467%2fhow-to-determine-what-columns-the-sharepoint-visitors-group-has%23new-answer', 'question_page');
        }
        );

        Post as a guest















        Required, but never shown

























        3 Answers
        3






        active

        oldest

        votes








        3 Answers
        3






        active

        oldest

        votes









        active

        oldest

        votes






        active

        oldest

        votes









        5














        For most PowerShell cmdlets, try something like this:



        get-pnpgroupmembers -identity "visitors group" | select *


        or



        get-pnpgroupmembers -identity "visitors group" | Get-Member


        As the PNP cmdlets are not populating all of the CSOM properties, you will get an error with "select *", and selecting some of the properties returned by Get-Member like Alerts and Groups will return errors.



        While not of the properties all are useful, these are selectable:



        AadObjectId,
        Email,
        Id,
        IsEmailAuthenticationGuestUser,
        IsHiddenInUI,
        IsShareByEmailGuestUser,
        IsSiteAdmin,
        LoginName,
        ObjectVersion,
        Path,
        PrincipalType,
        ServerObjectIsNull,
        Tag,
        Title,
        TypedObject,
        UserId



        get-pnpgroupmembers -identity "visitors group" | select AadObjectId,
        Email,Id,IsEmailAuthenticationGuestUser,IsHiddenInUI,IsShareByEmailGuestUser,
        IsSiteAdmin,LoginName,ObjectVersion,Path,PrincipalType,ServerObjectIsNull,
        Tag,Title,TypedObject,UserId


        As you will see, there aren't too many columns to choose from. What data are you looking for? You may need to query the User Profile Services for more user data.






        share|improve this answer




























          5














          For most PowerShell cmdlets, try something like this:



          get-pnpgroupmembers -identity "visitors group" | select *


          or



          get-pnpgroupmembers -identity "visitors group" | Get-Member


          As the PNP cmdlets are not populating all of the CSOM properties, you will get an error with "select *", and selecting some of the properties returned by Get-Member like Alerts and Groups will return errors.



          While not of the properties all are useful, these are selectable:



          AadObjectId,
          Email,
          Id,
          IsEmailAuthenticationGuestUser,
          IsHiddenInUI,
          IsShareByEmailGuestUser,
          IsSiteAdmin,
          LoginName,
          ObjectVersion,
          Path,
          PrincipalType,
          ServerObjectIsNull,
          Tag,
          Title,
          TypedObject,
          UserId



          get-pnpgroupmembers -identity "visitors group" | select AadObjectId,
          Email,Id,IsEmailAuthenticationGuestUser,IsHiddenInUI,IsShareByEmailGuestUser,
          IsSiteAdmin,LoginName,ObjectVersion,Path,PrincipalType,ServerObjectIsNull,
          Tag,Title,TypedObject,UserId


          As you will see, there aren't too many columns to choose from. What data are you looking for? You may need to query the User Profile Services for more user data.






          share|improve this answer


























            5












            5








            5







            For most PowerShell cmdlets, try something like this:



            get-pnpgroupmembers -identity "visitors group" | select *


            or



            get-pnpgroupmembers -identity "visitors group" | Get-Member


            As the PNP cmdlets are not populating all of the CSOM properties, you will get an error with "select *", and selecting some of the properties returned by Get-Member like Alerts and Groups will return errors.



            While not of the properties all are useful, these are selectable:



            AadObjectId,
            Email,
            Id,
            IsEmailAuthenticationGuestUser,
            IsHiddenInUI,
            IsShareByEmailGuestUser,
            IsSiteAdmin,
            LoginName,
            ObjectVersion,
            Path,
            PrincipalType,
            ServerObjectIsNull,
            Tag,
            Title,
            TypedObject,
            UserId



            get-pnpgroupmembers -identity "visitors group" | select AadObjectId,
            Email,Id,IsEmailAuthenticationGuestUser,IsHiddenInUI,IsShareByEmailGuestUser,
            IsSiteAdmin,LoginName,ObjectVersion,Path,PrincipalType,ServerObjectIsNull,
            Tag,Title,TypedObject,UserId


            As you will see, there aren't too many columns to choose from. What data are you looking for? You may need to query the User Profile Services for more user data.






            share|improve this answer













            For most PowerShell cmdlets, try something like this:



            get-pnpgroupmembers -identity "visitors group" | select *


            or



            get-pnpgroupmembers -identity "visitors group" | Get-Member


            As the PNP cmdlets are not populating all of the CSOM properties, you will get an error with "select *", and selecting some of the properties returned by Get-Member like Alerts and Groups will return errors.



            While not of the properties all are useful, these are selectable:



            AadObjectId,
            Email,
            Id,
            IsEmailAuthenticationGuestUser,
            IsHiddenInUI,
            IsShareByEmailGuestUser,
            IsSiteAdmin,
            LoginName,
            ObjectVersion,
            Path,
            PrincipalType,
            ServerObjectIsNull,
            Tag,
            Title,
            TypedObject,
            UserId



            get-pnpgroupmembers -identity "visitors group" | select AadObjectId,
            Email,Id,IsEmailAuthenticationGuestUser,IsHiddenInUI,IsShareByEmailGuestUser,
            IsSiteAdmin,LoginName,ObjectVersion,Path,PrincipalType,ServerObjectIsNull,
            Tag,Title,TypedObject,UserId


            As you will see, there aren't too many columns to choose from. What data are you looking for? You may need to query the User Profile Services for more user data.







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered 2 days ago









            Mike Smith - MCT - MVPMike Smith - MCT - MVP

            4,0792417




            4,0792417

























                3














                I don't know the exact number of user properties in each sharepoint version. But you can use below links to see the list of default user profile properties in SharePoint 2010,2013 and Office 365.
                Using this properties you can query your groups.



                Sources:




                1. Default user profile properties (SharePoint Server 2010).


                2. Default user profile property mappings.


                3. O365 User Profile Property Creation.



                Using 3rd link, follow the steps given and you can navigate to "Manager User Properties" in SharePoint admin center. Where you can see the basic default user profile properties.






                share|improve this answer




























                  3














                  I don't know the exact number of user properties in each sharepoint version. But you can use below links to see the list of default user profile properties in SharePoint 2010,2013 and Office 365.
                  Using this properties you can query your groups.



                  Sources:




                  1. Default user profile properties (SharePoint Server 2010).


                  2. Default user profile property mappings.


                  3. O365 User Profile Property Creation.



                  Using 3rd link, follow the steps given and you can navigate to "Manager User Properties" in SharePoint admin center. Where you can see the basic default user profile properties.






                  share|improve this answer


























                    3












                    3








                    3







                    I don't know the exact number of user properties in each sharepoint version. But you can use below links to see the list of default user profile properties in SharePoint 2010,2013 and Office 365.
                    Using this properties you can query your groups.



                    Sources:




                    1. Default user profile properties (SharePoint Server 2010).


                    2. Default user profile property mappings.


                    3. O365 User Profile Property Creation.



                    Using 3rd link, follow the steps given and you can navigate to "Manager User Properties" in SharePoint admin center. Where you can see the basic default user profile properties.






                    share|improve this answer













                    I don't know the exact number of user properties in each sharepoint version. But you can use below links to see the list of default user profile properties in SharePoint 2010,2013 and Office 365.
                    Using this properties you can query your groups.



                    Sources:




                    1. Default user profile properties (SharePoint Server 2010).


                    2. Default user profile property mappings.


                    3. O365 User Profile Property Creation.



                    Using 3rd link, follow the steps given and you can navigate to "Manager User Properties" in SharePoint admin center. Where you can see the basic default user profile properties.







                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered 2 days ago









                    Ganesh SanapGanesh Sanap

                    2,1153724




                    2,1153724























                        3














                        In general you can use wildcards (*) with the select pipe. This works with any variable that has properties. To select ALL properties and see what their values are you can do something like the following:



                        get-pnpgroupmembers -identify "visitors group" | select *



                        Unfortunately if you have a lot of items in your pipeline from get-pnpgroupmembers you'll get spammed with every property from each item. So if you want to find some specific columns for your object type you could call the function below, find your columns, and replace the * -first 1 with your comma separated list of columns.



                        get-pnpgroupmembers -identify "visitors group" | select * -first 1




                        An easy example:



                        Get-ChildItem . | select * -First 1



                        and turned it into the following, after selecting which columns I needed:



                        Get-ChildItem . | select BaseName,LastWriteTime,Attributes







                        share|improve this answer




























                          3














                          In general you can use wildcards (*) with the select pipe. This works with any variable that has properties. To select ALL properties and see what their values are you can do something like the following:



                          get-pnpgroupmembers -identify "visitors group" | select *



                          Unfortunately if you have a lot of items in your pipeline from get-pnpgroupmembers you'll get spammed with every property from each item. So if you want to find some specific columns for your object type you could call the function below, find your columns, and replace the * -first 1 with your comma separated list of columns.



                          get-pnpgroupmembers -identify "visitors group" | select * -first 1




                          An easy example:



                          Get-ChildItem . | select * -First 1



                          and turned it into the following, after selecting which columns I needed:



                          Get-ChildItem . | select BaseName,LastWriteTime,Attributes







                          share|improve this answer


























                            3












                            3








                            3







                            In general you can use wildcards (*) with the select pipe. This works with any variable that has properties. To select ALL properties and see what their values are you can do something like the following:



                            get-pnpgroupmembers -identify "visitors group" | select *



                            Unfortunately if you have a lot of items in your pipeline from get-pnpgroupmembers you'll get spammed with every property from each item. So if you want to find some specific columns for your object type you could call the function below, find your columns, and replace the * -first 1 with your comma separated list of columns.



                            get-pnpgroupmembers -identify "visitors group" | select * -first 1




                            An easy example:



                            Get-ChildItem . | select * -First 1



                            and turned it into the following, after selecting which columns I needed:



                            Get-ChildItem . | select BaseName,LastWriteTime,Attributes







                            share|improve this answer













                            In general you can use wildcards (*) with the select pipe. This works with any variable that has properties. To select ALL properties and see what their values are you can do something like the following:



                            get-pnpgroupmembers -identify "visitors group" | select *



                            Unfortunately if you have a lot of items in your pipeline from get-pnpgroupmembers you'll get spammed with every property from each item. So if you want to find some specific columns for your object type you could call the function below, find your columns, and replace the * -first 1 with your comma separated list of columns.



                            get-pnpgroupmembers -identify "visitors group" | select * -first 1




                            An easy example:



                            Get-ChildItem . | select * -First 1



                            and turned it into the following, after selecting which columns I needed:



                            Get-ChildItem . | select BaseName,LastWriteTime,Attributes








                            share|improve this answer












                            share|improve this answer



                            share|improve this answer










                            answered 2 days ago









                            KGlasierKGlasier

                            80418




                            80418






























                                draft saved

                                draft discarded




















































                                Thanks for contributing an answer to SharePoint Stack Exchange!


                                • Please be sure to answer the question. Provide details and share your research!

                                But avoid



                                • Asking for help, clarification, or responding to other answers.

                                • Making statements based on opinion; back them up with references or personal experience.


                                To learn more, see our tips on writing great answers.




                                draft saved


                                draft discarded














                                StackExchange.ready(
                                function () {
                                StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsharepoint.stackexchange.com%2fquestions%2f255467%2fhow-to-determine-what-columns-the-sharepoint-visitors-group-has%23new-answer', 'question_page');
                                }
                                );

                                Post as a guest















                                Required, but never shown





















































                                Required, but never shown














                                Required, but never shown












                                Required, but never shown







                                Required, but never shown

































                                Required, but never shown














                                Required, but never shown












                                Required, but never shown







                                Required, but never shown







                                Popular posts from this blog

                                Сан-Квентин

                                8-я гвардейская общевойсковая армия

                                Алькесар