How can i use ouput of PowerShell script in SSRS without upload toSQL DB

Question

Post reply

How can i use ouput of PowerShell script in SSRS without upload toSQL DB

nelly.kh

SSC-Addicted

Points: 415
More actions
October 8, 2014 at 9:13 am

#397479

I'm new to SSRS 2008 R2. I have been using Report Builder 3.0 to design my reports with no problems .Now, I would like to use as sources output from powershell script without upload information into SQL database, just run script when you start report en this report shows PS output. And Refresh infrmation with new parametrs from SSRS

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

sylvio.hellmann Valued Member Points: 59 More actions · Answer 1

Please have a look at https://psdpe.codeplex.com/[/url]

Jeff Moden SSC Guru Points: 1003861 More actions · Answer 2

nelly.kh (10/8/2014)
I'm new to SSRS 2008 R2. I have been using Report Builder 3.0 to design my reports with no problems .Now, I would like to use as sources output from powershell script without upload information into SQL database, just run script when you start report en this report shows PS output. And Refresh infrmation with new parametrs from SSRS

I'm curious... what do the PowerShell scripts do?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

nelly.kh SSC-Addicted Points: 415 More actions · Answer 3

I have differents script and we use them for quick diagnostic:

For example , check quickly status of running services ; disk space on selected computers or quickly compare software of hardware on 2-3 selected computers (cluster nodes) ..

nelly.kh SSC-Addicted Points: 415 More actions · Answer 4

I have seen it already, even installed all on my SSRS server.

I can add Embedded PowerShell connection in new report, but do not know how must created Connection string for PS. Please, can somebody help me with it ? Thanks in advance.