By Garth Jones
In an October blog post, I talked about getting rid of my last Windows Server 2003. Within that blog post I also talked about my friend @pierreroman who gave a presentation at TechEd North America 2014 called, “DCIM-B367 It’s the End of the World As You Know It… Windows Server 2003 End of Life: Infrastructure Migration.” You can watch the entire presentation on Channel 9.
During an email exchange with Pierre, the idea came up to create a dashboard report in order to show the number of Windows Server 2003s in your environment and the number of days before Windows Server 2003 expires.
I took the idea and ran with it since I’m a big fan of System Center 2012 Configuration Manager and enjoy creating lots of SSRS reports. Here’s the dashboard report that I put together and want to share with all of you. I hope that you enjoy using it as much as I enjoyed creating it!
How can you get this report?
1. Download the report here: /downloads/misc/Windows-Server-2003-Countdown.zip
2. Upload the RDL to your SCCM SSRS site.
3. Change the data source to use the SCCM data source.
For the last two steps you can watch the following video on how to upload and change the data source: https://www.youtube.com/watch?v=XWR6uzMl_8k
That’s it. You are done. Now you can forward the link of the dashboard report to your colleagues, or have SSRS email it to them on a regular (daily, weekly, monthly) basis.
By Garth Jones