April 22, 2017

SharePoint for Project Management (2016)—Presentation Video & Slides for Download

Microsoft SharePoint, the widely leveraged document management and collaboration web application, is a stabilized product with millions of users that has been growing strong since 2001, from on-premises to cloud as part of Office 365. Using SharePoint with Microsoft Office is a seamless experience. 

I had the opportunity to present SharePoint publicly four times in 2016. Two of them were for work and two of them for school (one being in English). As posted below, you may find the slides (in PowerPoint format) on SlideShare and partial video of the English presentation on YouTube.

Academic Presentation 1 - Available on SlideShare

August 31, 2016

Customizing Packages in HP SPP ISO and Offline Firmware Update in ProLiant Servers

This is a quick guide showing how to include/slipstream custom packages (rpm, exe, etc.) in HP/HPE SPP (Service Pack for ProLiant) ISO images for updating of system software or firmware of components within HPE/HP servers. Next, the process of offline updating will be shown. Finally, a few handy tips and reference URLs will be provided before conclusion.

The Need for SPP Customization

Below are a few of the reasons:

  • SPP is released several times per year by HPE. Component updates released in between may not be covered and would require a separate updating process had SPP not been customized.
  • Although SPP supports online firmware updating within a suitable OS, in limited environments where online updating is impossible, offline updating, which often require SPP, might be the only way.
  • The current SPP ISO is over the size of a single-layer writable DVD disc. However, not all firmware files are required for everyone; it may be desirable to only select desired firmware files to make the ISO smaller and the whole patching process less time-consuming.

August 21, 2016

Do-It-Yourself: Auto-Posting Inspirational Quotes on Twitter and Facebook

I enjoy reading quotes, concise and thoughtful ones, as IT workaholics like me are busy and quotes are easy to be consumed; they get me inspired quickly or start off the day with clarity.

To pay my respect and contribute, I wrote a few Windows and Linux scripts (documented below) and established these quote delivery services on Twitter and Facebook in February 2011:

This blog post describes the previous and current designs of the services as well as sharing the scripts written to implement them. Unlike the last post regarding social media automation which introduced paid services that are more user-friendly, this post demonstrates a more advanced technique; it is completely free of charge, but could be more friendly to system admins or IT pros than general users.

Flow – How It Works


July 17, 2016

Automatic Posting on Facebook Pages/Groups as Members — 3 Third-Party Solutions Compared

Recently, a less technical friend of mine who provides services for a living wanted to advertise his services on Facebook groups of which he is a member. He asked me to take a look at the automatic posting solutions on the market. During the research, I had to make sure my suggestions are solid (legit – not some scams or fakes, proven to work – at least until this moment).

This blog post provides a brief look at three of the more popular ones which fulfill his needs (i.e. posting to not only fan pages but groups, and not only groups one administrates, but also groups of which one is a member.)

Know the Ethics First

Reading the product manual prior to use

As emphasized above (from the help page of one of the tools), this kind of automation tools, if used incorrectly (e.g. going over the posting limit, posting the same content over and over, abuse of the service, etc.) could upset the host (Facebook) and ultimately get your account restricted or banned. Therefore, it is important to do things right the first time by reading product manuals and consulting sales/support persons (support URLs below) to fully understand the manners in correctly using the tools and the associated risks.

July 3, 2016

Exchange 2013 Journal Mailbox Archive-to-PST PowerShell Script Automation with Reporting

Recent Exchange versions have built-in support of journaling for recording all inbound and outbound email messages for backup or compliance reasons. Overtime, the journal mailbox grows so large and needs to be trimmed or pruned.

This article documents a PowerShell maintenance script I have written for a customer to report and automate the monthly archive-to-PST process of the Exchange 2013 journaling mailbox.

Archiving Concept

This script uses the PowerShell cmdlet New-MailboxExportRequest -Mailbox to export Exchange 2013 Journaling Mailbox of previous month (e.g. 2016-01-01 to 2016-01-31) as a standard PST file (e.g. archive 2016_01_31.pst) to specified locations (up to two locations) and then uses Search-Mailbox -DeleteContent to delete email messages within the date range if successful. It is designed to be run at the beginning of each month (e.g. 2/Feb/16) using Windows Task Scheduler.

Email Alerting, Reporting and Logging