StratexSystems

Enterprise Governance, Risk and Compliance Software
  • Who We Are
    • Our Company
  • Products
    • StratexPoint
    • On-Premise
    • Cloud
    • StratexStudio
  • How We Can Help
    • RBPM
    • GRC
    • ERM
    • BSC
    • ORM
  • News & Resources
    • News
    • Blog
    • Events
    • Resources
    • Videos
    • Newsletter
  • Contact
    • FAQ
    • Help Desk
    • Contact us
    • 30 Day POC
  • Log in
  • Our Company
  • StratexPoint
  • On-Premise
  • Cloud
  • StratexStudio
  • RBPM
  • GRC
  • ERM
  • BSC
  • ORM
  • News
  • Blog
  • Events
  • Resources
  • Videos
  • Newsletter
  • FAQ
  • Help Desk
  • Contact us
  • 30 Day POC
  • Log in

Blog

  • News
  • Blog
  • Events
  • Resources
  • Videos
  • Newsletter
  • All
  • Aldermore Bank
  • Balanced Scorecard
  • Bank failures
  • Bank of England
  • Banking regulation
  • Barclays
  • Careers
  • Client Successes
  • Clients
  • Commission on Banking
  • Conduct Risk
  • Culture
  • CultureOfAccountabilities
  • Developers
  • Disclaimer
  • Enterprise Risk Management
  • Events
  • Excel
  • FDIC
  • FSA
  • FSA Fines
  • GDPR
  • General BI
  • GRC Reporting
  • HML
  • Institute of Operational Risk
  • IT Risk Management
  • KCIs
  • KPIs
  • KRIs
  • Microsoft
  • News & Updates
  • Operational Risk
  • Operational Risk Events
  • Partners
  • Partners
  • Press release
  • Projects Issues
  • Reputation Risk
  • Risk Appetite
  • Risk Loss Events
  • Risk-based Performance Management
  • Senior Managers Regime
  • SharePoint
  • Sir John Vickers
  • SMR
  • Solvency II
  • Strategy Map
  • Stratex Benchmarking
  • Stratex Development preview
  • Stratex Events
  • Stratex Reports
  • Stratex Timebox
  • StratexHub
  • StratexLive
  • StratexPoint
  • StratexPoint 2010
  • Timebox
  • video
  • Webinars
  • Whitepaper
  • Windows 10
  • Windows Azure
  • Windows Mobile
Powershell2.jpg

The Power of Powershell

Eliza Hawthorn November 12, 2013

We here at StratexSystems believe in utilising tools that help perform tasks efficiently and ultimately make our daily work with SharePoint easy.

One such tool is SharePoint Management Shell or as it is more commonly referred to 'Windows Powershell'. This is used to manage SharePoint through the use of command lines - custom command-lets, instead of going through SharePoint Central Administration.

We came across a situation in one of our Client projects recently where, we were processing a large amount of data into one SharePoint environment, which was then to be imaged onto a second SharePoint environment. There was redundant data, for example primarily thousands of rows in the Recycle Bin that were unnecessarily taking space and time to process for the image of the second SharePoint environment.

A quick solution to was to use Powershell to clear the bulk data from the Recycle Bin. Here is the process and command script we used:

  1. Open SharePoint Management Shell (right click and select Run as Administrator)

  2. Modify Site collection Url in following script and execute:

$sitecollectionUrl = "ENTER YOUR SHAREPOINT SITE URL" $siteCollection = New-Object Microsoft.SharePoint.SPSite($sitecollectionUrl) write-host("Items to be deleted : " +$siteCollection.RecycleBin.Count.toString()) $now = Get-Date write-host("Deleting started at " +$now.toString()) $siteCollection.RecycleBin.DeleteAll(); $now = Get-Date write-host("Deleting completed at " +$now.toString()) $siteCollection.Dispose();

Process time will obviously depend on the amount of data to be cleared, once the script has finshed some stats will appear to help give an analysis.

This is a prime example, one of many in Powershell where going through Site Settings in SharePoint or through Central Administration is not practical or feasible.

TagsSharePoint
  • Blog
  • Older
  • Newer

Categories

  • Bank of England (1)
  • Barclays (1)
  • Commission on Banking (1)
  • Disclaimer (1)
  • FDIC (1)
  • GDPR (1)
  • General BI (1)
  • Institute of Operational Risk (1)
  • KCIs (1)
  • KPIs (1)
  • Operational Risk Events (1)
  • Reputation Risk (1)
  • Risk Loss Events (1)
  • Sir John Vickers (1)
  • Solvency II (1)
  • Strategy Map (1)
  • Stratex Benchmarking (1)
  • Stratex Timebox (1)
  • StratexHub (1)
  • Whitepaper (1)
  • Windows 10 (1)
  • Windows Azure (1)
  • Aldermore Bank (2)
  • Bank failures (2)
  • Careers (2)
  • Conduct Risk (2)
  • Culture (2)
  • FSA Fines (2)
  • HML (2)
  • KRIs (2)
  • SMR (2)
  • Stratex Reports (2)
  • StratexLive (2)
  • Windows Mobile (2)
  • Balanced Scorecard (3)
  • Client Successes (3)
  • CultureOfAccountabilities (3)
  • Developers (3)
  • Partners (3)
  • video (3)
  • Clients (4)
  • Excel (4)
  • FSA (4)
  • IT Risk Management (4)
  • News & Updates (4)
  • Events (5)
  • GRC Reporting (5)
  • Microsoft (5)
  • Press release (7)
  • Stratex Events (7)
  • Banking regulation (8)
  • Stratex Development preview (8)
  • StratexPoint 2010 (8)
  • Risk Appetite (9)
  • Operational Risk (10)
  • Senior Managers Regime (10)
  • SharePoint (11)
  • Webinars (11)
  • Enterprise Risk Management (14)
  • Risk-based Performance Management (14)
  • StratexPoint (24)
email

WHO WE ARE
Who We Are
Our Company
EXPLORE
Explore
StratexPoint
StratexLive
StratexStudio
SOLUTIONS
Solutions
Governance & Compliance
Enterprise Risk Management
Balanced Scorecard
Operational Risk Management
NEWS & RESOURCES
News & Resources
News
Blog
Events
Resources


© 2013 All Rights Reserved.

 

StratexSystems

Enterprise Governance, Risk and Compliance Software

We are one of the only software companies in the world to provide an integrated, Risk-based Performance solution powered by Microsoft's SharePoint platform.

Our goal is simple – to help businesses execute strategy while operating within their acceptable level of risk exposure.

Very few organisations are capable of obtaining a single enterprise-wide view of their performance and risk management information. Instead the tendency is to employ multiple tools that operate in silos; rarely communicate with one another; provide conflicting information; and contribute to poor decision-making.

We believe performance and risk are essentially different sides of the same coin.  To effectively manage either, they must be managed as an integrated process with a single, integrated solution. StratexSystems provides that solution. 

StratexSystems | 156 Blackfriars Road, London, SE1 8EN

email