Lync Users and Devices - Create an automated Excel file

This automated script will create Excel file with separate tabs for users, common are phones, analog devices and RGS workflows.

 
 
 
 
 
4.8 Star
(5)
1,508 times
Add to favorites
Lync
1/14/2015
E-mail Twitter del.icio.us Digg Facebook
  • Is it possible to add last logon date in the excel result?
    1 Posts | Last post September 09, 2019
    • Hi Yoav,
      
      is it possible to add the last logon date of each user in the script? Thank you
  • non-US excel
    2 Posts | Last post December 11, 2014
    • As for NON-US excel users add the following two after line 44 but before line 45
      
      
      $newci = [System.Globalization.CultureInfo]"en-US"
      [system.threading.Thread]::CurrentThread.CurrentCulture = $newci
      
      It should like this:
      
      $Excel = New-Object -ComObject Excel.Application
      $Excel.Visible = $true
      $newci = [System.Globalization.CultureInfo]"en-US"
      [system.threading.Thread]::CurrentThread.CurrentCulture = $newci
      $Workbook = $Excel.Workbooks.Add()
      
      Find this in the comments on http://blogs.technet.com/b/heyscriptingguy/archive/2013/04/03/excel-spreadsheets.aspx
      
    • Thanks - I'll add it to the script. Much appreciated :-)