Convert-SqlServerInventoryClixmlToExcel.ps1 fails on PS 5

While running Convert-SqlServerInventoryClixmlToExcel.ps1 after my PS version was upgraded to version 5, I started getting errors. Have you seen this before and is there a resolution? Convert-Sq...

Id #26 | Release: None | Updated: Jun 29 at 6:41 PM by bgollakn | Created: Jun 28 at 9:37 PM by bgollakn

Microsoft SQL Server unknown for SQL Server 2014 Instances

Thanks for developing and sharing this powerful tool. I have found that for SQL Server 2014 It's not generating the product name as Microsoft SQL Server 2014 in Database Engine Config file. Sample ...

Id #25 | Release: None | Updated: Mar 27 at 6:46 AM by szubair1 | Created: Mar 27 at 6:46 AM by szubair1

module RDS-Manager causes issue Win10 PS 5

Hi all, just noticed a minor issue which isn't directly related to the Power Doc solution. If you're using Windows 10 and PS Version 5 you'll get a Null reference exception if you have the module...

Id #24 | Release: None | Updated: Nov 3, 2016 at 4:16 PM by Feleryan | Created: Nov 3, 2016 at 4:16 PM by Feleryan

Exception calling "SizeOf" with "1" argument(s):

Hi, Thanks for this project. I just tested it on a sql 2012 server and couldn't go beyond this error: Instance name is server\sp2013 (server is netbios servername). The tool is using a fqn. S...

Id #23 | Release: None | Updated: Nov 18, 2016 at 5:23 PM by KenScoggin | Created: Oct 19, 2016 at 8:02 PM by SpRambler

Question

I am trying to put this in a job. So when someone wants an updated inventory. Then can just run the sql agent job,. I got it all working except the conversion to excel. Has any one tried this? or h...

Id #22 | Release: None | Updated: May 27, 2016 at 6:40 PM by kendalvandyke | Created: Apr 1, 2016 at 11:45 PM by dyard12

Named SQL Instance is Reported as Disabled

The named SQL instance is reported ad disabled when it is running if the default instance is disabled.

Id #21 | Release: None | Updated: Dec 22, 2015 at 10:50 PM by kendalvandyke | Created: Sep 8, 2015 at 1:20 PM by JKL

Computername - forced to put into comma delimited format

Another issue I have come across is the requirement of Get-SqlServerInventoryToClixml.ps1 forcing a user to put the ComputerName parameter into a comma delimited format. In the situation I am in, ...

Id #20 | Release: None | Updated: Mar 11, 2016 at 4:58 PM by kendalvandyke | Created: Aug 26, 2015 at 11:03 PM by AfterSunrise

Exception calling "EndInvoke" with "1" argument(s)

While I would like to report that I have used this product, unfortunately, it has failed every time I have attempted to use it. Specifically, I am getting the following error and need an immediate...

Id #19 | Release: None | Updated: May 27, 2016 at 6:38 PM by kendalvandyke | Created: Aug 26, 2015 at 10:42 PM by AfterSunrise

No valid module

Hi, I seem to be failing at the first hurdle. I downloaded, unblocked and extracted the zip to c:\tools\sql doc. I open PS ISE and type .\Get-SqlServerInventoryToClixml.ps1 -ComputerName 'domai...

Id #18 | Release: None | Updated: May 27, 2016 at 6:46 PM by kendalvandyke | Created: Aug 26, 2015 at 10:33 PM by JGP

Problem with databases having 6.5 compatibility level

probably a minor issue as these scenarios are going to disappear soon (hopefully), but if you have a database with compatiblity level 6.5 on a SQL Server 2000 instance, the following error is risen...

Id #17 | Release: None | Updated: May 27, 2016 at 6:47 PM by kendalvandyke | Created: Aug 6, 2015 at 9:30 AM by ghotz