I want to execute a task or command on the SharePoint Server.
What Nintex product provides for this functionality?
Please include additional resources available regarding this topic.
None of the default actions will call PowerShell.
Dataone have a product that works with Nintex Workflow. Most of their site is not in English but they do have some English content here http://de.slideshare.net/DataOneGmbH/data-one-poweractivity
I have not tried these my self.
I'm pretty new to the products and have just gone through training. I too wondered about firing a powershell script from a workflow. I haven't tried this, but couldn't you use an Execute SQL task to fire a T-SQL xp_cmdshell command that fires the Powershell script?
There are definitely some assumptions made in this scenario: this assumes you have an MSSQL server available and that xp_cmdshell is enabled (a big "if", since that can be a security consideration). Also, I'm not sure whether you'd be able to actually return any information to the workflow using this method. But even if it can just simply fire a script, that may suffice for some needs.
If your DBA is serious, most likely you'll get denied at attempting to execute xp_cmdshell on a production SQL server as that would be a security breach.
I've purchased the DataOne Power Activity but have not been able to get it to function properly. Initially they were responsive to my requests, but subsequent issues that I've submitted have received no response. I'm left to ditch this product and try the CodePlex solution mentioned here.
I wanted to update my notes about DataOne's PowerShell tool for Nintex Workflow. Once we reconnected they have gone to great lengths to ensure we got the product up and working. There were numerous issues and discoveries on both sides. The net result is that we are now going into production using their tool and are very grateful for their diligence in getting this working in our environment.
I tend to challenge the software limits of products that I use so technical support becomes vital to a company's efforts to win my loyalty. Both Nintex and DataOne have done that for me.
Thought I should pass that on.
First of all, I wouldn't recommend to allow freeform PowerShell scripts in any sort of a Workflow Activity. Otherwise, each workflow publishing iteration would require a thorough security and stability review.
Otherwise, I think it's possible to use Nintex SDK to create wrapper actions for specific allowed PowerShell cmdlets such as Get-Process, Get-ADUser, whatever is appropriate for your organization.
...I wouldn't recommend to allow freeform PowerShell scripts in any sort of a Workflow Activity. Otherwise, each workflow publishing iteration would require a thorough security and stability review.
This depends on the practices within your organization. Being a financial services company, my organization operates with a high degree of security, however I'm allowed the latitude & trust to introduce scripts that perform needed operations without said review. Depending on personnel abilities, resources and the level of acceptable risk, it can be entirely appropriate.
Well, Ryk, what can I say? Congratulations, you must have deserved it somehow.
And, quite possibly, you may have withheld some formal or unspoken limitations of what you may or may not include in those scripts. Are they enforced in any way?
Do you believe it will be exactly the same with the next Chief Security Office occupant or anyone that might take your place when you decide to move on?
Don't forget that an upset IT admin is a major insider threat, they must be keeping you pretty happy at work, huh? ;-)
Ryk McDorman I put together a custom action to execute PowerShell scripts that allows the administrators to determine whether or not each script has to be approved or not. You can find the details here.
Excellent! Thanks so much, Eric.
Kerry Dirks here's a free custom PowerShell Action for Nintex.
When I delpoy the solution and use the aciton in a workflow I get the following error: Error executing PowerShell Unrecognized activity encountered: Error executing PowerShell Unrecognized activity encountered: PSActivity.Activity.
Can anyoner help?
Which version of SharePoint are you using Darren Jones?
Sorry, should have mentioned my version of SP and Nintex workflow ver. I'm using SP 2013 with Nintex workflow 2013. Works fine in my dev environment.
I see the solution has been deployed to all my three servers, howerver one is an app server and not runing the:
Microsoft SharePoint Foundation Web Application Microsoft SharePoint Foundation Workflow Timer Service
Does think this would matter though as the workflow will we picked up by the other two
If you have any idea on why this is causing an error and failing to recognise the actual workflow activity, it’ll be much appreciated.
Sharepoint Developer, Operations
The Channel Managing Agency
10 Lime Street, London, EC3M 7AA
Tel: +44 (0) 203 817 5066
For further information on the Channel Syndicate 2015, please visit our website at www.channel2015.com<http://www.channel2015.com><http://www.whittingtoninsurance.com>
P Please consider the environment before printing this email.
This email (and any attachment) is intended only for the attention of the addressee and may contain legally privileged and/or confidential information. Its unauthorised use, disclosure, storage or copying is not permitted. If you are not the intended recipient, please permanently delete the original, destroy all copies and inform the sender by return email. Thank you.
An email reply to this address may be subject to interception or monitoring for operational reasons or for lawful business practices.
Syndicate 2015 is managed at Lloyd’s by The Channel Managing Agency Limited, which is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority. The Channel Managing Agency Limited (08614385) is registered at 10 Lime Street, London EC3M 7AA.
For further information on the Channel Syndicate, please visit our website at www.channel2015.com<http://www.channel2015.com>
Interesting that it is working on 2013. I have not tested with that version. I've heard others have had issues. Did you look at the commercially available PowerShell action?
Can you supply a link?
Darren, here you go. DataOne.de
Thanks. I'll give it a go.
Hello, there is also an english page for "Data One 4 PowerShell" available:
Kind regards, Frank
Thanks Frank. I don’t see any pricing info. on that page.
Hi Eric, the current official pricing is EUR 1.499 per (productive) WFE and includes 12 months of technical support and updates during that period. I encourage you to use our free trial to evaluate the tool.
Retrieving data ...