I just published a new article. It is about an interesting question on Experts Exchange I saw last week. The guy wanted to loop through all the folders (including subfolders) to discover how many files are stored in them and how big are the files.
It is not a complex one but it requires a bit of recursion to loop through the folders, a bit of error handling because there are folders that might be protected.
So here comes the first article of January!
You can read it from http://emoreau.com/Entries/Articles/2017/01/Getting-folder-size.aspx
If you are administering an Office 365 tenant, you might have tried to list the user profiles from the SharePoint admin center.
We can see a label showing "Total number of profiles" with a number just above the find textbox but there is no easy way to list them all.
I just discovered that if you search for the letter i and click the Find button, you will get almost all of them. A couple of profiles are missing but they are used internally and you probably shouldn't bother with them! The reason why the full list is returned when you search for I is because the internal account name is something like "i:0#.f|membership|accounting@YourDomain.com"
Je souhaite une merveilleuse année 2017 à tous. Au plaisir de vous croiser dans cette nouvelle année.
I wish you all the best for the new year.
Microsoft Canada is hosting a full day of hands on labs on Jan 17. Our goal is to reach a new crowd and to create an environment where individuals who have yet to tinker with Azure, have a chance to do so. If possible, we’d love your help to spread the word in your circles. Below are details about the day. We will be hosting two tracks and understand that many have obligations that keep them from attending this type of event during the day, so we added an extra slot from 18h to 21h, that we hope will allow us to accommodate those who wish to attend.
Below are some resources that we’d appreciate if you could use to send out to your communities. Please spread the word as best as you can!
The information about the event has been posted on our blog: Link
Register now and include the time block, session and track you want to attend
I just published the December article.
I received a couple of nice comments about last month article about retrieving Office 365 mailboxes statistics. Apparently, I am not alone trying to get information from Office 365 in an automated way!
This month, I will show you 2 more tricks built using PowerShell to get some more information from the Office 365 tenant. First, I will show you how to get the list of mobile devices that connects to the mailboxes. Second, I will show you how to list not-delivered emails.
You can read this month article at http://emoreau.com/Entries/Articles/2016/12/More-PowerShell-for-Office-365--Devices-and-failed-emails.aspx
I just published my latest article. And oh surprised, I will show you some PowerShell this month!
A client of mine finally switched to Office 365 last month. They started to have recurring issues with their old on premise Exchange server and going to Office 365 was a no-brainer decision.
On the previous server, because space was tight, I had a script running weekly showing the usage of all users’ mailboxes to discover who was using all the precious space. That script was built for Exchange Server 2010 and was not compatible with Office 365.
Now with the standard 50 gb of total space for each user, they have plenty of space but managers are still interested in getting statistics about the space used in Office 365 and the licensing.
When I started to look around for samples, I found snippets here and there but none were giving me all the client wanted. I found that I needed to mix many of them in order to get various pieces of information.
For example, Get-Mailbox returns a list of the mailboxes in your tenant but we need to call Get-MailboxStatistics to get the total size of an account. but I later discovered that this size does include much more than just emails (so it was a bit different from I expected). If we want a break that value down, we need to call Get-MailboxFolderStatistics to get more granular information like the number and size of emails, calendar items, and contacts. Lastly, if we are interested in licensing information, we need to call Get-MsolUser.
This current article is clearly not a full tutorial on how to use PowerShell as I am not an expert in that domain. It is the result of my experiments trying to produce some statistics putting together snippets that were working separately but not when combined all together.
You can read this article from http://emoreau.com/Entries/Articles/2016/11/PowerShell-Get-O365-mailboxes-statistics.aspx
The most requested feature I receive from reader is to show C# code directly in the article. I thought of switching all the code to C# but I still have a great number of VB readers.
I finally took some time to create tabs to show both VB and C# code on article.
Hope you will like it.
10 years ago, I wrote 2 articles about Crystal Reports for .Net (Feeding Crystal Reports from your application and Crystal Reports – Part II). At that time, it was for the Universal Thread magazine which has stopped publishing since then but I never stopped.
Without any doubt, these 2 articles have been in the top 5 of my most visited and they are still today attracting readers even after 10 long years. Since I continue to receive questions about the use of CR in .Net, I decided to revisit that topic.
You can read the new revamped article from http://www.emoreau.com/Entries/Articles/2016/10/Crystal-Reports-for-Net-revisited-10-years-later.aspx
Have you ever used LightSwitch? It is a tool proposed by Microsoft targeting power users/business analyst but not developers.
Well, if you never used it, be aware that the product is not officially dead (but still supported until October 2020) as announced at https://blogs.msdn.microsoft.com/lightswitch/2016/10/14/lightswitch-update/.
The same post is pushing on a newer tool named PowerApps (https://powerapps.microsoft.com/en-us/). Will you take the chance?
I just published an article that is revisiting one I wrote back in February 2008 showing how to create a wiki-like help system.
Since 2008, I have implemented that feature in most applications because the user can really customize the documentation to fit their needs. The system has proven to be useful in many occasion.
Not only users are more than happy to be able create and improve the help by themselves, they have also asked for some improvements. These required are the same as those listed in the “Extending this system” section of the 2008 article. I have seen them coming! One of the improvements is the ability to be able to jump from one topic to another (this is why I have a listbox control on the left of the screen). Lately, a customer also asked me to generate a Word document containing all the topics from the wiki system.
That last request will be subject of this article.
You can read it from http://emoreau.com/Entries/Articles/2016/09/Wiki-revisited--Generating-a-Word-document.aspx