none
Powershell script to force check in the checked out resources

    Question

  • Hi,

    We are using Project Server 2010 and facing an issue where some users get checked in by themselves while submitting the timesheet. So, we are thinking to write a powershell script that automatically force check ins the resource checked out by themselves.

    Any help would be greatly appreciated. Thanks in advance.

    Regards,

    Komal

    Thursday, September 14, 2017 9:17 AM

Answers

All replies

  • There aren't any PowerShell modules available in SharePoint/Project server 2010.   PowerShell in Project Server doesn't really become a viable until SharePoint 2013. 

    PowerShell 2.0 was available in Window Server 2008 R2 very close to the release date of SharePoint 2010.  However its not until PowerShell 3.0 comes out does, SharePoint 2013 start to put useful cmdlets in PowerShell modules.

    With that said, windows PowerShell V2.0 would require you to build cmdlets that can talk to Project Server but it would be easier to migrate to Project Server 2013. 


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Thursday, September 14, 2017 9:37 PM
    Moderator
  • Hello Komal,

     

    I see a script for check-in all projects which you can try customize the script for resources.

    Project Server: PowerShell script to force a checkin of all checkedout projects

    https://gallery.technet.microsoft.com/projectserver/Server-PowerShell-script-981812c2

     

    Cheers!!! Happy Troubleshooting!!!

    Shiva Prasad B C, MCP, MCSA

    whenever you see a reply being an answer to the question of the thread, click "Mark as Answer

    Tuesday, September 19, 2017 2:54 PM
    Moderator
  • Hello Shiva

    Nice find.  That script calls SQL and is a good work around.


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Thursday, September 21, 2017 3:23 AM
    Moderator