The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
COURSE of the MONTH
8 days, 20 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Create Remote Powershell Process from ASP.NET C#
Posted on 2013-01-07
Hi Experts,
We have a powershell script which we run manually once every few months to provide our users with an overview of who has access to who's mailbox & vice-versa:
We then import the results to SQL and display them by user via a web page, so each individual accessing the web page sees their specific mailbox details.
What we would like to try and do now is somehow run the script from the web page so that the whole thing becomes dynamic rather than requiring a manual process every few months.
We use Citrix and would intend the Powershell script to run on the Citrix server using parameters to identify who's who.
Can anyone point us in the direction of where to begin, we have got as far as running a simple powershell cmdlet from within an ASP.NET page (locally in a test environment) following the example given here:
http://devinfra-us.blogspo
But I think we are now starting to appreciate the complexity of what to do next...some general guidance at this stage would be appreaciated.
We have a powershell script which we run manually once every few months to provide our users with an overview of who has access to who's mailbox & vice-versa:
Get-Mailbox -Server “[OUREXCHANGESERVER]” | Get-MailboxPermission | where { ($_.AccessRights -eq “FullAccess”) -and ($_.IsInherited -eq $false) -and -not ($_.User -like “NT AUTHORITY\SELF”) } | export-csv h:\access1.csv
We then import the results to SQL and display them by user via a web page, so each individual accessing the web page sees their specific mailbox details.
What we would like to try and do now is somehow run the script from the web page so that the whole thing becomes dynamic rather than requiring a manual process every few months.
We use Citrix and would intend the Powershell script to run on the Citrix server using parameters to identify who's who.
Can anyone point us in the direction of where to begin, we have got as far as running a simple powershell cmdlet from within an ASP.NET page (locally in a test environment) following the example given here:
http://devinfra-us.blogspo
But I think we are now starting to appreciate the complexity of what to do next...some general guidance at this stage would be appreaciated.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
3
7 Comments
>>But I think we are now starting to appreciate the complexity of what to do next...some general guidance at this stage would be appreciated.
I run the example from the link you've posted and it seems to work fine.
what problems you encounter applying this in your environment?
I run the example from the link you've posted and it seems to work fine.
what problems you encounter applying this in your environment?
Hi sedgwick,
My apologies, there are no problems running the linked example locally on my machine, no that works fine...agreed, but that was merely to illustrate our first step in trying to understand the process of running powershell scripts via ASP.NET. It's getting from that fairly simple example to what we want to do that seems more complex.
As I said, we want the powershell script to run on our Citrix server not locally on an individuals PC, We will need the web page to trigger the running of the script and display the results, we don't neccessarily need to embed the script itself in the C# - we could just reference a ps1 file - it's trying to understand how we would be best to do this, any security / connection issues involved and how we can trigger the script to run remotely on a server but specific to the identity of the user who is logged in and requesting the webpage if that makes sense.
My apologies, there are no problems running the linked example locally on my machine, no that works fine...agreed, but that was merely to illustrate our first step in trying to understand the process of running powershell scripts via ASP.NET. It's getting from that fairly simple example to what we want to do that seems more complex.
As I said, we want the powershell script to run on our Citrix server not locally on an individuals PC, We will need the web page to trigger the running of the script and display the results, we don't neccessarily need to embed the script itself in the C# - we could just reference a ps1 file - it's trying to understand how we would be best to do this, any security / connection issues involved and how we can trigger the script to run remotely on a server but specific to the identity of the user who is logged in and requesting the webpage if that makes sense.
I've no general guideline of how to approach this requirement since it's not common one and i assume it is bonded to your specific needs and environment.
i'd break it down to bullet tasks and handle each one individually.
also it would easier to experts suggest solutions and help you achieving the final requirement.
1. the script get current logged user as parameter and output on a web page the mailbox permissions.
2. Citrix server which runs the powershell should have access to all pc's in order to get user's mailbox permissions (it can be run with admin credentials for instance).
what else?
i might not getting the whole scope of the requirement but if you will break it down for me i'd able (i'll try) to help you figure out one step at a time.
cheers
i'd break it down to bullet tasks and handle each one individually.
also it would easier to experts suggest solutions and help you achieving the final requirement.
1. the script get current logged user as parameter and output on a web page the mailbox permissions.
2. Citrix server which runs the powershell should have access to all pc's in order to get user's mailbox permissions (it can be run with admin credentials for instance).
what else?
i might not getting the whole scope of the requirement but if you will break it down for me i'd able (i'll try) to help you figure out one step at a time.
cheers
Many thanks, I will try and tackle one thing at a time:
I suppose the first thing that we would like to understand is the usings - in that example which works for both you and I the instructions say to add:
using System.Management.Automati
but I note from googling the subject that most suggest the need for two further usings:
using System.Collections.ObjectM
using System.Management.Automati
Some also seem to refer to the use of pipelines - for example:
I'm not clear on the implications/ neccesity are you able to advise on those points at all?
I suppose the first thing that we would like to understand is the usings - in that example which works for both you and I the instructions say to add:
using System.Management.Automati
but I note from googling the subject that most suggest the need for two further usings:
using System.Collections.ObjectM
using System.Management.Automati
Some also seem to refer to the use of pipelines - for example:
runspace.Open();
Pipeline pipeline = runspace.CreatePipeline();
pipeline.Commands.AddScript("my script");
Collection<PSObject> output = pipeline.Invoke();
I'm not clear on the implications/ neccesity are you able to advise on those points at all?
using those libraries (powershell api wrapper class basically) is nice to have but as you pointed out earlier you can run a PS script.
if you familiar with .NET, then i'd stick to that and have my code using those libraries.
this is really a minor technical issue, cause the PS is merely one line of code.
check this example here:
How to run PowerShell scripts from C#
also you might want to know if the PS code was running successfully and no error was triggered, so i'd use try/catch in the PS code and output in case of exception.
what is the next step?
if you familiar with .NET, then i'd stick to that and have my code using those libraries.
this is really a minor technical issue, cause the PS is merely one line of code.
check this example here:
How to run PowerShell scripts from C#
also you might want to know if the PS code was running successfully and no error was triggered, so i'd use try/catch in the PS code and output in case of exception.
what is the next step?
Do you intend to keep this avialable longer than the Citrix session? If the answer is no, you don't need a special web page to do this.
If I am understanding you needs correctly, you can publish the Powershell script with some modifications, and it should accomplish what you want.
you would publish:
powershell.exe -file <path to ps1 file>
You would add to your one-liner.
Here's a quick throw-together of where I would start:
I'm sure it will need some debugging, and you can highly customize the resulting web page with the convertto-html command.
It's obviously the opposite direction of what you were asking originally, but if the end-result is what I think it is based on your description, this would be a lot easier to handle from a Citrix environment without having to worry about the SQL server.
Coralon
If I am understanding you needs correctly, you can publish the Powershell script with some modifications, and it should accomplish what you want.
you would publish:
powershell.exe -file <path to ps1 file>
You would add to your one-liner.
Here's a quick throw-together of where I would start:
Get-Mailbox -Server “[OUREXCHANGESERVER]” | Get-MailboxPermission | where { ($_.AccessRights -eq “FullAccess”) -and ($_.IsInherited -eq $false) -and -not ($_.User -like “NT AUTHORITY\SELF”) } | convertto-html | out-file -filepath "$env:temp\MyFileName.htm"
start-process -filepath "c:\program files (x86)\internet explorer\iexplore.exe" -argumentlist "$env:temp\myfilename" -Wait $true
I'm sure it will need some debugging, and you can highly customize the resulting web page with the convertto-html command.
It's obviously the opposite direction of what you were asking originally, but if the end-result is what I think it is based on your description, this would be a lot easier to handle from a Citrix environment without having to worry about the SQL server.
Coralon
Featured Post
WatchGuard announces the acquisition of advanced authentication provider, Datablink, with one mission – to bring secure authentication to SMB, mid-market, and distributed enterprises with a cloud-based solution, ideal for resale via their established channel & MSSP community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses
Course of the Month8 days, 20 hours left to enroll
765 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.