Do you know if these SharePoint site/library settings can be determined via PowerShell?

%3CLINGO-SUB%20id%3D%22lingo-sub-795438%22%20slang%3D%22en-US%22%3EDo%20you%20know%20if%20these%20SharePoint%20site%2Flibrary%20settings%20can%20be%20determined%20via%20PowerShell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-795438%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20a%20requirement%20where%20below%20details%20for%20a%20site%20and%20sub-sites%20beneath%20need%20to%20be%20fetched%20in%20an%20excel%20format%20so%20that%20it%20can%20be%20used%20for%20auditing%20purpose%20.%20As%20I%20explored%20%2C%20using%20the%20REST%20API%2C%20we%20can%20get%20a%20ton%20of%20information%20for%20a%20site%20(web%20object).%20We%20can%20see%20the%20XML%20properties%20by%20going%20to%20the%20site%20and%20appending%20%E2%80%9C%2F_api%2Fweb%E2%80%9D%20to%20the%20end%20of%20the%20URL%3B%20but%20not%20sure%20how%20it%20can%20be%20used%20in%20a%20code%20so%20that%20reports%20can%20be%20generated%20.%20Moreover%20%2C%20as%20mentioned%20below%3B%20we%20need%20to%20fetch%20libraries%20detail%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3ESubsite%20Settings%3C%2FEM%3E%3C%2FP%3E%3CUL%3E%3CLI%3E%3CEM%3EEnableMinimalDownload%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EHorizontalQuickLaunch%20%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EWebTemplate%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EWelcomePage%3C%2FEM%3E%3C%2FLI%3E%3C%2FUL%3E%3CUL%3E%3CLI%3E%3CEM%3ENavigation%20Elements%3C%2FEM%3E%3C%2FLI%3E%3CUL%3E%3CLI%3E%3CEM%3EEnable%20Quick%20Launch%20%26gt%3B%20True%2FFalse%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EEnable%20Tree%20View%20%26gt%3B%20True%2FFalse%3C%2FEM%3E%3C%2FLI%3E%3C%2FUL%3E%3CLI%3E%3CEM%3ENavigation%20%3C%2FEM%3E%3C%2FLI%3E%3CUL%3E%3CLI%3E%3CEM%3EGlobal%26nbsp%3B%20Navigation%20%26gt%3B%20Option%201-3%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3ECurrent%20Navigation%20%26gt%3B%20Option%201-4%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3ECurrent%20Navigation%20%26gt%3B%20Shown%20Subsites%20%26gt%3B%20True%2FFalse%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3ECurrent%20Navigation%20%26gt%3B%20Show%20Pages%20%26gt%3B%20True%2FFalse%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3ECurrent%20Navigation%20%26gt%3B%20Maximum%20number%20of%20dynamic%20items%20to%20show%20in%20this%20level%20of%20navigation%20%26gt%3B%20integer%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EManaged%20Navigation%3A%20Default%20Page%20Settings%20%26gt%3B%20Add%20new%20pages%20to%20navigation%20automatically%20%26gt%3B%20True%2FFalse%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EManaged%20Navigation%3A%20Default%20Page%20Settings%20%26gt%3B%20Create%20Friendly%20URLs%20for%20new%20pages%20automatically%20%26gt%3B%20True%2FFalse%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EStructural%20Navigation%3A%20Sorting%20%26gt%3B%20Option%201%20or%202%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EStructural%20Navigation%3A%20Sorting%20%26gt%3B%20Sort%20Pages%20Automatically%26gt%3B%20True%2FFalse%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EStructural%20Navigation%3A%20Automatic%20Sorting%26gt%3B%20Sort%20by%3A%26gt%3B%20Text%20(drop%20down%20list)%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EStructural%20Navigation%3A%20Automatic%20Sorting%26gt%3B%20Option%201%20or%202%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EStructural%20Navigation%3A%20Editing%20and%20Sorting%20%26gt%3B%20Text%20(List%20of%20headers)%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EShow%20and%20Hide%20Ribbon%20%26gt%3B%20Option%201%20or%202%3C%2FEM%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FUL%3E%3CP%3E%3CEM%3E%26nbsp%3B%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3ELibrary%20Settings%3C%2FEM%3E%3C%2FP%3E%3CUL%3E%3CLI%3E%3CEM%3EWorkflow%20settings%3C%2FEM%3E%3C%2FLI%3E%3CUL%3E%3CLI%3E%3CEM%3EPage%20Approval%3C%2FEM%3E%3C%2FLI%3E%3CUL%3E%3CLI%3E%3CEM%3EStart%20Options%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EApprovers%20%26gt%3B%20Assign%20To%20%26gt%3B%20Text%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EApprovers%20%26gt%3B%20Order%20%26gt%3B%20Text%20(drop%20down%20list)%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EEnd%20of%20First%20Rejection%20%26gt%3B%20True%2FFalse%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EEnd%20on%20Document%20Change%20%26gt%3B%20True%2FFalse%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EEnable%20Content%20Approval%20%26gt%3B%20True%2FFalse%3C%2FEM%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FUL%3E%3CLI%3E%3CEM%3EVersioning%20Settings%3C%2FEM%3E%3C%2FLI%3E%3CUL%3E%3CLI%3E%3CEM%3EContent%20Approval%20%26gt%3B%20Option%201%20or%202%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EDocument%20Version%20History%20%26gt%3B%20Create%20a%20version%20each%20time%20you%20edit%20a%20file%20in%20this%20document%20library%3F%20%26gt%3B%20Option%201-3%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EDocument%20Version%20History%20%26gt%3B%20Optionally%20limit%20the%20number%20of%20versions%20to%20retain%20%26gt%3B%20Keep%20the%20following%20number%20of%20major%20versions%20%26gt%3B%20True%2FFalse%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EDocument%20Version%20History%20%26gt%3B%20Optionally%20limit%20the%20number%20of%20versions%20to%20retain%20%26gt%3B%20Keep%20the%20following%20number%20of%20major%20versions%20%26gt%3B%20Integer%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EDocument%20Version%20History%20%26gt%3B%20Optionally%20limit%20the%20number%20of%20versions%20to%20retain%20%26gt%3B%20Keep%20drafts%20for%20the%20following%20number%20of%20major%20versions%20%26gt%3B%20True%2FFalse%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EDocument%20Version%20History%20%26gt%3B%20Optionally%20limit%20the%20number%20of%20versions%20to%20retain%20%26gt%3B%20Keep%20drafts%20for%20the%20following%20number%20of%20major%20versions%20%26gt%3B%20Integer%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EDraft%20Item%20Security%20%26gt%3B%20Option%201-3%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3ERequire%20Check%20Out%20%26gt%3B%20Option%201%20or%202%3C%2FEM%3E%3C%2FLI%3E%3C%2FUL%3E%3CLI%3E%3CEM%3ERating%20Settings%20%3C%2FEM%3E%3C%2FLI%3E%3CUL%3E%3CLI%3E%3CEM%3ERating%20Settings%20%26gt%3B%20Option%201%20or%202%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EWhich%20voting%2Frating%20experience%20you%20would%20like%20to%20enable%20for%20this%20list%20%26gt%3B%20Option%201%20or%202%3C%2FEM%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FUL%3E%3CP%3E%3CEM%3E%26nbsp%3B%3C%2FEM%3E%3C%2FP%3E%3CP%3EAre%20you%20aware%20of%20any%20CSOM%20script%20which%20is%20capable%20of%20doing%20this%20or%20may%20be%20some%20other%20alternative%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EVimmi%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1070029%22%20slang%3D%22en-US%22%3ERe%3A%20Do%20you%20know%20if%20these%20SharePoint%20site%2Flibrary%20settings%20can%20be%20determined%20via%20PowerShell%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1070029%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%20to%20bump%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F187582%22%20target%3D%22_blank%22%3E%40Vimmi%20Rawat%3C%2FA%3E%26nbsp%3B's%20old%20thread%20from%20Sept%2C%20but%20I%20couldn't%20help%20but%20wonder%20if%20%22HorizontalQuickLaunch%22%3A%20false%20is%20possibly%20able%20to%20finally%20fix%20the%20horizontal%20quick%20launch%20issue%20on%20team%20sites%20in%20the%20Seattle%20layout%20...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWho's%20going%20to%20bring%20the%20depression%3F%20%3B)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi All,

 

We have a requirement where below details for a site and sub-sites beneath need to be fetched in an excel format so that it can be used for auditing purpose . As I explored , using the REST API, we can get a ton of information for a site (web object). We can see the XML properties by going to the site and appending “/_api/web” to the end of the URL; but not sure how it can be used in a code so that reports can be generated . Moreover , as mentioned below; we need to fetch libraries detail as well.

 

Subsite Settings

  • EnableMinimalDownload
  • HorizontalQuickLaunch
  • WebTemplate
  • WelcomePage
  • Navigation Elements
    • Enable Quick Launch > True/False
    • Enable Tree View > True/False
  • Navigation
    • Global  Navigation > Option 1-3
    • Current Navigation > Option 1-4
    • Current Navigation > Shown Subsites > True/False
    • Current Navigation > Show Pages > True/False
    • Current Navigation > Maximum number of dynamic items to show in this level of navigation > integer
    • Managed Navigation: Default Page Settings > Add new pages to navigation automatically > True/False
    • Managed Navigation: Default Page Settings > Create Friendly URLs for new pages automatically > True/False
    • Structural Navigation: Sorting > Option 1 or 2
    • Structural Navigation: Sorting > Sort Pages Automatically> True/False
    • Structural Navigation: Automatic Sorting> Sort by:> Text (drop down list)
    • Structural Navigation: Automatic Sorting> Option 1 or 2
    • Structural Navigation: Editing and Sorting > Text (List of headers)
    • Show and Hide Ribbon > Option 1 or 2

 

Library Settings

  • Workflow settings
    • Page Approval
      • Start Options
      • Approvers > Assign To > Text
      • Approvers > Order > Text (drop down list)
      • End of First Rejection > True/False
      • End on Document Change > True/False
      • Enable Content Approval > True/False
  • Versioning Settings
    • Content Approval > Option 1 or 2
    • Document Version History > Create a version each time you edit a file in this document library? > Option 1-3
    • Document Version History > Optionally limit the number of versions to retain > Keep the following number of major versions > True/False
    • Document Version History > Optionally limit the number of versions to retain > Keep the following number of major versions > Integer
    • Document Version History > Optionally limit the number of versions to retain > Keep drafts for the following number of major versions > True/False
    • Document Version History > Optionally limit the number of versions to retain > Keep drafts for the following number of major versions > Integer
    • Draft Item Security > Option 1-3
    • Require Check Out > Option 1 or 2
  • Rating Settings
    • Rating Settings > Option 1 or 2
    • Which voting/rating experience you would like to enable for this list > Option 1 or 2

 

Are you aware of any CSOM script which is capable of doing this or may be some other alternative ?

 

Regards,

Vimmi

1 Reply
Highlighted

Sorry to bump @Vimmi Rawat 's old thread from Sept, but I couldn't help but wonder if "HorizontalQuickLaunch": false is possibly able to finally fix the horizontal quick launch issue on team sites in the Seattle layout ...

 

Who's going to bring the depression? ;)