Skype for Business Environment Report

This package of PowerShell scripts will gather data on a Skype for Business environment and store it into an XML data file. You can also create Microsoft Word reports and Microsoft Visio network diagrams based on the data gathered.

 
 
 
 
 
4.8 Star
(8)
2,817 times
Add to favorites
Lync
12/7/2016
E-mail Twitter del.icio.us Digg Facebook
  • Error while generating visio
    6 Posts | Last post May 06, 2019
    • Modified the script by according to your suggestion, the error changes to below
      
      Extracting CS Environment data file to R:\
      Importing CS Environment data file.
      Creating diagram: .\CS_Env_Data-0117180106.vsdx
      Creating new instance of Visio to work with.
      Creating new Visio document.
      Adding page(s) to Visio document.
      Importing stencils...
      New-VisioDiagram :
      File not found.
      At R:\New-CsEnvDiagram.ps1:1170 char:1
      + New-VisioDiagram -DataFileName $script:XmlFileName -CsConfig $CsConfi ...
      + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          + CategoryInfo          : OperationStopped: (:) [New-VisioDiagram], COMException
          + FullyQualifiedErrorId : System.Runtime.InteropServices.COMException,New-VisioDiagram
      
      Do I have to download any stencil or other requirement is needed before running this script? Thanks a lot
    • I've short out the error above, but got another during drawing the diagram
      
      New-VisioSitePage : Exception getting "Item": "
      Object name not found."
      At C:\Users\kenfil\Desktop\Cs Env Report v6.0\New-CsEnvDiagram.ps1:621 char:3
      +         New-VisioSitePage -Site $Site -CurrentPage $CurrentPage
      +         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          + CategoryInfo          : NotSpecified: (:) [New-VisioSitePage], GetValueI
         nvocationException
          + FullyQualifiedErrorId : ExceptionWhenGetting,New-VisioSitePage
      
      Looking forward for your advise, billion thanks
    • Hi
      
      How did you solve the first error? I've tried changing it as to what RAGuth earlier wrote but it didn't help.
      
      Thanks
      
      Broddi
    • The first issue I've hit is the incorrect paper size, just do a search "papersize" and replace 3 with 2 or 8
      This next error which what posted previously, just download and extract the stencil and place all vss to my documents\my stencils
      
      Both Visio 2013/2016 getting same error....
    • I found downloading the following stencils https://www.microsoft.com/en-us/download/details.aspx?id=35772 and putting them into \Documents\My Shapes worked for me.
      
       
      OfficeSymbols_2012and2014.zip
      OfficeSymbols_2014.zip 
      OfficeSymbols_2016.zip
    • I have read through this thread and have made the suggested changes however I still get the following erro:
      
      PS C:\Users\dhillan.kalyan\Downloads\Cs Env Report v6.0> .\New-CsEnvDiagram.ps1 '.\rainbow.root CS_Env_Data-0506190106.xml'
      Starting report creation.
      Importing CS Environment data file.
      Creating diagram: .\rainbow.root CS_Env_Data-0506190106.vsdx
      Creating new instance of Visio to work with.
      Creating new Visio document.
      Adding page(s) to Visio document.
      Importing stencils...
      New-VisioDiagram :
      Object name not found.
      At C:\Downloads\Cs Env Report v6.0\New-CsEnvDiagram.ps1:1169 char:1
      + New-VisioDiagram -DataFileName $script:XmlFileName -CsConfig $CsConfi ...
      + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          + CategoryInfo          : OperationStopped: (:) [New-VisioDiagram], COMException
          + FullyQualifiedErrorId : System.Runtime.InteropServices.COMException,New-VisioDiagram
      
      I have checked my stencils, changed the page size etc and still now luck.  Anyone have a working script yet? Please help me out.
  • OpenEx error
    1 Posts | Last post January 16, 2019
    • I have the xml file and the templates in the right location, but keep getting this error:
      New-VisioDiagram : Exception calling "OpenEx" with "2" argument(s): "
      This file name is not valid."
      At \\tsclient\H\Scripts\Skype\New-CsEnvDiagram.ps1:1169 char:1
      + New-VisioDiagram -DataFileName $script:XmlFileName -CsConfig $CsConfig -Visible  ...
      + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          + CategoryInfo          : NotSpecified: (:) [New-VisioDiagram], MethodInvocationException
          + FullyQualifiedErrorId : COMException,New-VisioDiagram
  • Any suggestions?
    3 Posts | Last post December 20, 2018
    • Someone else mentioned this too, but i don't see that an answer was given.  When running the script to create the Visio diagram, i'm getting this error:
      
      New-VisioSitePage : Method invocation failed because [System.Management.Automation.PSObject] does not contain a method named 'op_Addition'.
      At C:\Scripts\LyncEnvReport\v6\New-CsEnvDiagram.ps1:621 char:3
      +         New-VisioSitePage -Site $Site -CurrentPage $CurrentPage
      +         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          + CategoryInfo          : InvalidOperation: (op_Addition:String) [New-VisioSitePage], RuntimeException
          + FullyQualifiedErrorId : MethodNotFound,New-VisioSitePage
      
      How can i fix this?
      
      Thanks again. Awesome script!
    • The problem doesn't seem to be the inability to create a second page. It seems to be creating a connector between the front-end and another server. The script-block in question is this:
      
      # Create connectors from FE to SQL.
      		$FESQLConnector = Add-ConnectorToPage -Page $CurrentPage -Name "$($Pool.Fqdn) SQLConnector" -BeginX 1 -BeginY 1 -EndX 2 -EndY 2  -LineWeight "0.147 pt*ThePage!PageWidth" -Color $($Colors.Red) -BeginArrow "5" -EndArrow "5" -LineType 1 -ConnectorRouteStyle 17 -ConnectorShape 2 -ErrorAction SilentlyContinue
      		$FESQLConnector.Cells("BeginX").GlueTo($CurrentPage.Shapes.Item("$($Pool.Fqdn) FqdnLabel").Cells("Connections.X2"))
      		$FESQLConnector.Cells("EndX").GlueTo($CurrentPage.Shapes.Item("$($DBFqdn)").Cells("Connections.X4"))
      
      I'm still deciphering the way the script works as I've limited XML or Visio scripting but it seems in my case it sees the Office Web App server as a SQL backend!
    • Looks like the script have issues with multi-site environments. I'm actually walking through the code to see how can it be adapted for multi-sites, but as I'm not an daily-basis programmer it takes some time for me.
      
      With some luck, @Empty Message guy will read this message, and maybe he is already aware of this problem.
  • Coding Error - Has this ever been answered?
    1 Posts | Last post November 09, 2018
    • New-VisioSitePage : Method invocation failed because [System.Management.Automation.PSObject] does not contain a method
      named 'op_Addition'.
      At C:\temp\zag\New-CsEnvDiagram.ps1:621 char:3
      +         New-VisioSitePage -Site $Site -CurrentPage $CurrentPage
      +         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          + CategoryInfo          : InvalidOperation: (op_Addition:String) [New-VisioSitePage], RuntimeException
          + FullyQualifiedErrorId : MethodNotFound,New-VisioSitePage
  • I am getting this error while trying to generate the Env Diagram
    1 Posts | Last post July 05, 2018
    • Hello everyone
      Is there anyone who can help me? I'm completely stuck on this error.
      
      New-VisioSitePage: Method invocation failed because [System.Management.Automation.PSObject] does not contain a method
      named 'op_Addition'.
      At D: \ Temp \ Cargo Cargo Column \ Cs_Env_Report_v6.0 \ New-CsEnvDiagram.ps1: 621 char: 3
      + New-VisioSitePage -Site $ Site -CurrentPage $ CurrentPage
      + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~
           + CategoryInfo: InvalidOperation: (op_Addition: String) [New-VisioSitePage], RuntimeException
           + FullyQualifiedErrorId: MethodNotFound, New-VisioSitePage
      
      I do not know what to do, please help me
  • I am getting error while trying to generate the Env Diagram
    2 Posts | Last post July 04, 2018
    • Can You help me resolve this error: I have read through blogs and tried to implement the fixes mentioned, but nothing seems to work.
      
      
      New-VisioSitePage : Method invocation failed because [System.Management.Automation.PSObject] does not contain a method
      named 'op_Addition'.
      At C:\Users\Administrator.WHITEHORN\Documents\Cs Env Report v6.0\New-CsEnvDiagram.ps1:621 char:3
      +         New-VisioSitePage -Site $Site -CurrentPage $CurrentPage
      +         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          + CategoryInfo          : InvalidOperation: (op_Addition:String) [New-VisioSitePage], RuntimeException
          + FullyQualifiedErrorId : MethodNotFound,New-VisioSitePage
      
      
    • hi
      Have you been able to fix this error because I'm completely blocking it
  • Exported XML file from the script is not compatible with the Planning Tool
    1 Posts | Last post June 29, 2018
    • Skype For Business Server 2015 Planning Tool does not accept the XML file created by CsEnvReport script. 
      
      Following error is displayed: The Planning Tool cannot open the file because it`s compatible with Skype for Business Server 2015, Planning Tool.
      
      Do you have the same error what could be the reason? 
      
      
      
      
  • New-CsEnvReport.ps1 error
    4 Posts | Last post May 03, 2018
    • I'm also getting this error when i run new-csenvreport.ps1.  It works great for a minute or two, chugging along and setting up the Word doc, but then dies on "Creating LisSubnet policy table"  Here's the error...
      
      New-WordTable : The number must be between 1 and 63.
      At S:\Restore\NEW\New-CsEnvReport.ps1:495 char:5
      + ...             New-WordTable -DataTable $dt -HeaderRow $true -FlipData $ ...
      +                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          + CategoryInfo          : OperationStopped: (:) [New-WordTable], COMException
          + FullyQualifiedErrorId : System.Runtime.InteropServices.COMException,New-WordTable
    • The LIS & RGS sections can be a bit flaky. As a temporary workaround you can comment out the sections for them from the report. You would just need to add a # at the beginning of line 401 for RGS or 403 for LIS. I will do some additional testing and validation for the next release the see if I can figure out the issue. 
    • Do you have a fix for this?  LIS and RGS are needed in the report.
      
      Thanks very much.  :)
    • Is there a fix for this problem? I am having the same problem with the RGS.
      
      Thanks
  • Error when creating Visio
    4 Posts | Last post April 23, 2018
    • Hi,
      
      I tried to create the Visio with New-CsEnvDiagram.ps1 but received the following error:
      Add-ShapeToPage :
      An exception occurred.
      At line:587 char:21
      + … ntOutline = Add-ShapeToPage -Shape “Rectangle” -Page $CurrentPage -X1 …
      + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      + CategoryInfo : OperationStopped: (:) [Add-ShapeToPage], COMException
      + FullyQualifiedErrorId : System.Runtime.InteropServices.COMException,Add-ShapeToPage
      
      Can I do something from my side to fix this?
      
      Thank you!
    • Hello Simon,
      Did you find a answer to this error ? I am having the same issue.
      
      Thanks
    • Same Problem here, any solutions?
    • Hi, it seems to be related regional settings and differences how using comma/dot in Europe. Someone could maybe solve this in script, but I just changed my region setting from control panel to English (united states) and it started to work immediately.
  • Add-ShapeToPage Visio Error
    6 Posts | Last post April 23, 2018
    • Hi There
      
      I get the following error:
      
      Add-ShapeToPage : 
      An exception occurred.
      At C:\Users\BMarks\Documents\Skype for Business\Cs Env Report v6.0\New-CsEnvDiagram.ps1:637 char:21
      + ... ntOutline = Add-ShapeToPage -Shape "Rectangle" -Page $CurrentPage -X1 ...
      +                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          + CategoryInfo          : OperationStopped: (:) [Add-ShapeToPage], COMException
          + FullyQualifiedErrorId : System.Runtime.InteropServices.COMException,Add-ShapeToPage
      
      I have read through the posts and there doesnt seem to be an fix, or I just dont know how to fix it.
      
      Please help. :-)
    • Ok, somehow I got this to run and it started creating the visio diagram. But near the end of the Diagram when it was adding the internal servers, it stopped and gave me the follow error. Any ideas?
      
      New-VisioSitePage : Method invocation failed because [System.Management.Automation.PSObject] does not contain a method named 'op_Addition'.
      At C:\Users\BMarks\Documents\Skype for Business\Cs Env Report v6.0\New-CsEnvDiagram.ps1:621 char:3
      +         New-VisioSitePage -Site $Site -CurrentPage $CurrentPage
      +         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          + CategoryInfo          : InvalidOperation: (op_Addition:String) [New-VisioSitePage], RuntimeException
          + FullyQualifiedErrorId : MethodNotFound,New-VisioSitePage
    • Hello Skellitor, what did you fix to get this error to go away ?
      
      637 char:21
      Thanks
    • Hi Alexander
      
      I must be honest, i dont really know. I think it had to do with how I ran the script. My second issue has got to do with errors I get when gathering info from SQL cluster but i think it has to do with user rights. 
      
      Regards
    • Hi Alexander and Skellitor
      
      how i fix this error.
      
      thanks
      
      RI
    • Hi, it seems to be related regional settings and differences how using comma/dot in Europe. Someone could maybe solve this in script, but I just changed my region setting from control panel to English (united states) and it started to work immediately.
1 - 10 of 27 Items