Ok think I worked it out, I get so much help on this forum, I hope this helps somebody else.

$SSRSConMgr = Get-WmiObject -Namespace "root\Microsoft\SqlServer\ReportServer\RS_<yourInstanceNameOrVariableHere>\v11\Admin" -Class MSReportServer_ConfigurationSetting -ComputerName $env:COMPUTERNAME

$SSRSConMgr.InitializeReportServer("$InstID".TrimStart('@{InstallationID={').TrimEnd('}'))

Gives me a...

Hello,

Thank you for replying, but unfortunately that did not work. I got the same error as I did previously.

Anyone else? I'll keep looking.

Regards,

D.

Thanks Gary,

I think I found another way of doing it which I will post when I can sort out an non-sensitive version, its probably not the most elegant way to...

Hi Gary,

I wondered if I might call on your help once more. I am trying to set up some try/catch action, I feel like I am almost there but I...

Thank you, Gary. I took the parameters a little too literally there!

Regards,

D.

Awesome! Thanks Gary!

Regards,

Paul.

That's great, Shawn! Thank you!

Regards,

D.

Thanks Shawn, the curly brace got me nearer to the goal, after a bit of jiggery pockery I got to this, but I am finding that it is creating the...

Right ok, if there is one thing I have noticed about myself is that I seem to get deeper and deeper then end up going nowhere!

I'm trying to get the...

Hi Shawn,

Yes, thank you for that, I get the info for the local machine, I need to work out how I can get it for the remote servers I am...

Hi Shawn

AH! I literally found this out just as I got your reply through, and then it was by accident! So now I have...

Get-Service -ComputerName $ComputerName -Name SQL*

Format-Table -AutoSize

...the only...

Hi Shawn,

At the moment, I have only listed one server in the txt file just for test purposes, and its basically..

FQDN\Instance, port

...and that's it, when I add the others it...

Hi Shawn,

Thank you for getting back, I have tried your code but I'm having trouble getting it to work, the last one that does the local machine works, but I...

Hi, thank you for your help, with your suggestions and a little tinkering, it has been wittled from 6 errors down to 1. I feel like I am almost at...

Hello,

I'm now trying to get a list of SQL services from a remote machine, and I feel like I am almost there, but there are one or two things I...