Lync, Teams and Office 365 PowerShell module ReportHTML

-


So I found myself looking for some nice PowerShell reporting tools. The standard table with header format was looking a bit dated.
After some investigation I found some decent output using the ReportHTML PowerShell module https://www.powershellgallery.com/packages/ReportHTML/1.4.1.2

So far, i've done some
  • Essential system overview (Figure 1)
  • Teams/Lync/SfBO reporting showing users enabled (doughnut chart), with used domains (user count), enabled user count, disabled user count, registered sip domains, policies in use (client, conferencing, external access etc), users online, on-premises (Figure 2)
  • Domains in use, invalid domains (assigned to users presumably through script) which weren't valid in Lync. Online users in teams modes (another doughnut, with data table).
  • Users online with various interpreted user types (to catch those who are enabled in cloud, sync'd account on premises, but not sip enabled on premises. for example!)
  • Teams without owners, with guests, number of channels, average, min/max, visibility
  • Error reports with users without a registrar pool, invalid domains, non-matching sip/email addresses and invalid characters in SIP addresses.

This was based on a large user pool (80,000+) so lots of data to sift through and more than a few interesting pieces of data.

Fig 1. System Overview


Fig 2. Policies



Then I had a look at some mailbox analysis, focusing on Enterprise Vault mailboxes.
Same idea, charts and data tables, looking at 'stuck' emails (that wouldn't process in the inbox) identifying mailboxes and sent dates.
the filtering and sorting capabilities of the data tables helped greatly when displaying key information on the stuck emails (sent dates/times, mailbox, subject etc)

Comments

Post a Comment

Popular posts from this blog

Skype Online and MCOValidationError

-
These user counts are incorporated into the Lync ReportHTML  from the previous post: https://jc-nts.blogspot.com/2019/05/powershell-module-reporthtml.html While doing some housekeeping for a client, I noticed that the Interpreted User Type attribute in SfBO threw up some HybridOnpremSfBUserWithMCOValidationError accounts. The full list included: DirSyncSfBUser: On-premises users which have been assigned a SfB online licence DirSyncTeamsUser: On-premises users which have been assigned a Teams licence HybridOnlineSfBUser: A user created on-premises and migrated to SfBO HybridOnpremSfBUser: A user created on-premises and enabled on-premises for Lync/Skype HybridOnpremSfBUserWithDeletedLicenses: An on-premises user has a deleted office 365 SfB licence HybridOnpremSfBUserWithMCOValidationError: An on-premises user with a domain that is not valid in your synchronised tenant PureOnlineSfBUser: Online users which have been assigned a SfB licence PureOnlineTeamsUser: Online us...
Read more

SCCM 2012 R2 - Offline servicing error

-
While updating images in SCCM 2012R2 to apply recent updates to a windows 8 image, I hit the following errors: Failed to install update with error code -2146498513 InstallUpdate returned code 0x800f082f Failed to install update with ID 17242935 on the image. ErrorCode = 2095 To fix: Mount the image (.wim) file using dism: dism /mount-wim /wimfile:d:\sources\os\captures\w8x86.wim /index:2 /mountdir:c:\mount Load the registry SOFTWARE key reg load HKLM\MyKey c:\mount\windows\system32\config\software Find the registry key HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Compnent Based Servicing\SessionsPending Edit the DWORD Exclusives to value 0 (in my case it was 3) unload the registry reg unload HKLM\MyKey commit the changes to the wim dism /unmount-wim /mountdir:c:\mount /commit In SCCM, schedule the updates. Key an eye on the OfflineServicingMgr log file - you might need to do the same again. Links DISM mounting http://msdn.microsoft.com/en-us/library/ff7...
Read more

Polycom provisioning - and Zoom!

-
Updated June 2019 So I have a little downtime which means I need a little project. On my 'havent setup in the test lab yet' is a polycom provisioning service. So, off to eBay i head for some devices (naturaly) and i'm pleasantly surprised to find some VVX handsets at a very reasonable £30. On a roll, i head off to find some Trio conference devices. A step up from the CX3000 they replaced, these are nice pieces of kit. I just missed out on a trio 8800 and visual+ bundle, so with VVX501 in hand i setup a provisioning service. FTP server - filezilla - check exceptions in the firewall - allow the filezilla app through - check DHCP options (160 AND 161 for newer firmware) - check Create a config file for the MAC address (i only have a single device, after all) Remembering to disable updates from the Lync/Skype/Office365 service - I dont want a reboot loop as it updated and downgrades repeatedly. <?xml version="1.0" standalone="yes"?> <...
Read more