In July 2009, I posted a table that outlined a number of Microsoft software versions. In January of 2010, I released version 2 of this list that included a number of additional features, including information regarding SMS/SCCM history and all versions of Windows back to Windows 95 in the DOS line and Windows NT 3.1in the NT line. With version 3, I added Microsoft Data Protection Manager and Operations Manager builds, end-of-life support dates for many of the Windows products and for Operations Manager, and a lot of new updates for SQL Server and Exchange.

In this update of the list, I made a number of additions, including:

  • Added System Center Service Manager to the product list
  • Added System Center 2012 versions
  • Added a slew of SQL Server cumulative updates
  • By reader request, changed the file format to XLS

The downloadable table is broken down into these seven columns:

  • Release date. This is the month and the year in which a particular release was made available. Bear in mind that there can be multiple release dates. For example, was Windows 7 released in August 2009 or October 2009? Well, it depends on how you look at it. The RTM bits were available starting August 6, 2009, but general availability didn’t hit until October 22, 2009.
  • Software title/version. For example, Windows XP, Exchange Server 2003
  • Revision level. RTM, SP1, etc.
    • CU stands for Cumulative Update.
    • CH stands for Cumulative Hotfix.
    • HF stands for Hot Fix.
    • UR stands for Update Rollup.
    • RTM stands for Release to Manufacturing. I use RTM to describe the initial release of a product. Technically, every release has an RTM period, but RTM is commonly used in the manner in which I’ve described.
  • Build number. The internal build number often causes confusion because it doesn’t always match the product name. For example, Windows 7 RTM has a build number of 6.1.7600.16385, thereby proving to some that Windows 7 is a minor release. The build number is simply an interval versioning mechanism. If you know where I can find additional build information (especially older SMS build numbers), please let me know in the comments section. I only included release versions of products; no beta versions are included.
  • Mainstream. This is the date Microsoft ended or will end mainstream support for the currently supported version of the product.
  • Extended. This is the date Microsoft ended or will end extended support for the currently supported version of the product.
  • SP retired. This is the date the service pack was or will be retired from support.

Note: Some date and build information is missing because I could not find a resource that outlined that particular data point. If you know the information or you come across it, please post it in the discussion. Also, there are a lot of missing pieces in the new columns: mainstream, extended, and SP retired. I will continue to more fully populate these columns in future updates.