Book dedicated to System Center Reporting

A new System Center book is set to publish this Friday March 27th. This one has me very excited because the focus is on reporting in System Center. And it is not just one or two System Center components they cover them all. This book dives in and gives you recipes’ as to how to build reports that are useful so you can start producing them in your environment today. What I love about this book is that it was developed with the IT pro in mind. The IT pro with no SQL background. Most System Center folks dont have a past in SQL but after some time working with the product they know SQL well. 🙂 This book will help those that want to get going with reporting for System Center and those that want to pick up some new skills. The title of the book is Microsoft System Center Reporting Cookbook. I was approached to be a technical reviewer on this book and jumped at the opportunity. The authors of this book are Samuel Erskine, Kurt Van Hoecke, Dieter Gasser, Nasira Ismail.

This is a book you will want to add to your collection!

Here is the cover for the book and some links with more information:

SCReportingBook

Amazon link to the book:

http://www.amazon.com/Microsoft-System-Center-Reporting-Cookbook/dp/1782171800

Interview with Sam Erskine about the new Microsoft System Center Reporting Cookbook:

https://www.youtube.com/watch?v=cmmthUYszxw&feature=youtu.be

Read more

Update to the SCSM Discovery Report

  I have made a couple of updates to the Service Manager Discovery report. The first one is that the report will now display the update rollup level within the report along with the version number. This was courtesy of Samuel Erskine and Natascia Heil. Thanks for contributing the the report! They have recently built … Read more

Service Manager Discovery Report

I recently built a PowerShell script that creates a discovery report for System Center Service Manager. The idea behind the script was to have something that I could run to gather all of the information I would want about a Service Manager deployment. I searched online and could not find anything so that’s when I decided to put something together.

This report can be used by consultants doing assessments or SCSM admins as an easy way to document what you have in your environment. This is a first pass at the report so it is version 1.1. I plan to add more information/functionality to the report in the future. Keep in mind I am not a PowerShell expert so feel free to take the script tweak it and share your updates with the community.

When the script is run it will output a report of System Center Service Manager in HTML format. This script should be run on a management server within your Service Manager’s management group. The script should be run with an account that has administrative access to Service Manager and the local server it will be running on.

The script will run on Service Manager 2012 SP1 and above. It uses SCSM 2012 SP1/R2 CMDLETS along with SMLets. If you don’t have the SMLets installed you can download them here: https://smlets.codeplex.com/

Discovered in the report:

These are the sections of information in the report.

  • Management Server Name
  • Service Manager Version
  • Management Server HDD CPU Memory
  • Service Manager Management Group Name
  • Service Manager Data Warehouse Information
  • Users connected to Service Manager
  • Service Manager Run as accounts
  • Service Manager User Roles
  • Service Manager Notification Channels
  • Service Manager Connectors
  • Service Manager Email Templates
  • Service Manager Subscriptions
  • Service Manager Groups
  • Service Manager Queues
  • Service Manager Service Offerings
  • Published Service Manager Request Offerings
  • Draft Service Manager Request Offerings
  • Service Manager Views
  • Service Manager Tasks
  • Service Manager Un-sealed Management Packs
  • Websites local to the Service Manager Server
  • Last 10 Service Manager error event logs

Example Link:

This will take you to an online example of the report.

https://www.buchatech.com/wp-content/uploads/2015/03/Service-Manager-Discovery-Report.html

Example Output:

Here is a screenshot of the report.

clip_image001

Download It:

https://gallery.technet.microsoft.com/Service-Manager-Discovery-a25c7d80

NOTE: The PowerShell report is provided AS-IS without warranty of any kind. It is recommended to run in a lab environment before running it in a production environment.

Read more

Did you miss the #ITSM role in #Private Cloud webinar?

Did you miss my recent webinar with Savision about ‘Service Management’s Role in the Private Cloud’? This was co-hosted by Savision’s co-founder and VP of Product Management, Dennis Rietvink. If you would like to see it or watch it again, the on-demand version is now available.   “Screenshots from the webinar” During the webinars, we … Read more

Service Manager PowerShell Extensions – SCSMPx

Recently a colleague of mine Rob Plank brought some new CMDLets for Service Manager to my attention. These are a part of a PowerShell module that can be installed on your Service Manager server. They are the System Center Service Manager PowerShell Extensions also known as SCSMPx. Here is the official description for them:

The ScsmPx module facilitates automation with Microsoft System Center Service Manager by auto-loading the native modules are included as part of that product and enabling automatic discovery of the commands that are contained within the native modules. It also includes dozens of complementary commands that are not available out of the box to allow you to do much more with your PowerShell automation efforts using the platform.

This module contains hundreds of new commands for Service Manager.

The module was built by Kirk Munro (@Poshoholic) and sponsored by Provance.

The System Center Service Manager PowerShell Extensions ( SCSMPx) module can be found here: https://github.com/KirkMunro/ScsmPx.

The module requires:

  • PowerShell 3.0
  • SnippetPx module

The module is very easy to install and can be done so by running this syntax from PowerShell on a Service Manager management server:

& ([scriptblock]::Create((iwr -uri http://tinyurl.com/Install-GitHubHostedModule).Content)) -ModuleName ScsmPx,SnippetPx

Running that will download and install the SCSMPx and SnippetPx modules. This is for all users and requires being run from an elevated PowerShell console. This module will auto-load (PowerShell 3.0 and above) so there is no need to run Import-Module to load it.

Once this module is installed on a management server it also enables auto-loading of the native Service Manager CMDlets for Service Manager 2012 and later.

The commands included in the module are:

Read more

Webinar: Understand what it takes for a successful Private Cloud project

Learn what you can do to ensure a successful Private Cloud project. Attend one of my webinars this week. Details about the webinars include:

-“Service Management’s role in the Private Cloud“- hosted by Microsoft MVP Steve Buchanan. The webinars will be co-hosted by Savision’s co-founder and VP of Product Management, Dennis Rietvink.

 

SMRoleInPrivateCloudWebinar

 

During these webinars you will find out the right tools that IT professionals and management need to provide clean and mature processes that will enable them to become more agile and move down the path of realizing the benefits of Private Cloud. The webinars will also define the Private Cloud, the layers of the Private Cloud, and those layers within which service management operates.

The webinars will be held on two different dates, so register now for the one that will be more convenient for you:

Register for the US webinar: Wednesday, February 25th, 2015 | 2 PM EST / 8PM CET
Register for the EU webinar: Thursday, February 26th, 2015 | 9 AM EST / 3 PM CET

P.S. If you still haven’t, download the Service Management’s role in the Private Cloud whitepaper here.

Read more

Whitepaper – Service Management’s Role in the Private Cloud

I am happy to announce that today Savision just published a new whitepaper authored by me. It is titled:

Service Management’s Role in the Private Cloud
Dispelling the Myopic Perception

 Service-Management's-role-in-the-private-cloud-600x188

This whitepaper sets out to define Private Cloud, the layers of Private Cloud, and those layers within which service management operates.

The whitepaper also explores having ultimate visibility into your organization’s business services. Business services discussed in this paper consist of configuration items (CIs), monitoring, and application maps; they are underpinned with incident, change management, and modern day self-service. In addition, the whitepaper explores the integration between Operations Manager and Service Manager, and the role Savision Live Maps Unity plays in this area. Here is an excerpt from the whitepaper:

“Technology needs of the business are changing, often faster than can be addressed by most internal IT departments.

It is critical for IT departments to shift away from the image of black box cost centers and slow moving dinosaurs that are hard to work with and become viewed as revenue-generating centers that are agile, fast moving, and business enablers with modernized IT services.

From the perspective of internal IT, there are some key steps that can be made to prepare and deliver “modern IT services” – with service management being a critical component of those services. This whitepaper explores these key steps from a Microsoft technology perspective as it applies to System Center.”

A huge thanks to both Kerrie Meyler and Sam Erskine for doing the technical review on this whitepaper!

To download visit:

http://savision.com/resources/white-paper/free-whitepaper-mvp-steve-buchanan-service-managements-role-private-cloud?utm_source=Twitter&utm_content=Whitepaper+by+MVP+Steve+Buchanan&utm_campaign=General

Read more

Great start For #SysCTR in 2015

We are just 8 days into 2015 and already there has been a lot of great things happening in the space. First off DPM has just received a highly anticipated feature.

DPM now has Deduplication of the DPM Storage. The storage savings is anywhere from 50% to 90%! This is a huge improvement for DPM. Here is a blog about the announcement:

http://blogs.technet.com/b/dpm/archive/2015/01/06/deduplication-of-dpm-storage-reduce-dpm-storage-consumption.aspx

image

Here is a whitepaper on the new functionality:

http://technet.microsoft.com/en-us/library/dn891438.aspx

Second today Microsoft released a survey soliciting feedback on System Center. This feedback will be used to influence the future of System Center. This is a chance for the System Center community to provide feedback directly to the Microsoft product teams. The post with the survey link can be found here:

http://blogs.technet.com/b/momteam/archive/2015/01/07/have-a-say-on-the-future-of-system-center.aspx

Other great news is that one of my colleagues Lee Berg has been awarded a Microsoft System Center MVP. Congratulations Lee! Here is his blog post about it:

http://www.leealanberg.com/blog/2015/01/01/im-mvp-happy-new-years/ and here is Lee’s twitter @LeeAlanBerg . This makes a total of 6 MVP’s at Concurrency now.

The other MVP’s at Concurrency are: Nathan Lasnoski – @nlasnoski, Shannon Fritz – @MrShannonFritz, Mike Steineke – @MSteineke and Annur Sumar.

You can catch these MVP’s and other Concurrency experts blogging at http://www.concurrency.com/blog/.

Read more

Featured on Techguy Blog

Today Michael Seidl published an interview he did with me on his blog!       Check it out: German: http://www.techguy.at/interview-mit-steve-buchanan/ English: http://bit.ly/1xcM9bg Follow Michael on Twitter @TechGuyAT for System Center related content. Thanks Michael!

Community tools: Manage SCSM DW Jobs & SCORCH Reporting

One of the many great things about System Center is the rich eco-system within the community. Many System Center guru’s contribute their time to making tools that improve or fill gaps within System Center and they release these to the community for FREE. Two new community tools have recently been released one for Service Manager and one for Orchestrator. I wanted to post about them today and give them some shine.

SCSM DW Jobs Management Tool

The first tool is from Sam Erskine. We have seen a lot of great stuff from Sam lately such as System Center books, speaking at conferences and now another Service Manager tool. This tool gives you a GUI to execute all the Server Manager Data Warehouse actions.

ViewJobs-executed

As of right now you cannot do this directly in the Service Manager console. You can only do this via PowerShell. This tool gives you a centralized and organized way to handle the DW jobs. This is especially helpful when upgrading Service Manager or applying update rollups.

Sam has posted a blog about the tool with more information. You can find it here:

http://itprocessed.com/2014/11/838/

You can download this tool here:

https://gallery.technet.microsoft.com/SCSM-DW-Jobs-Management-f69fb703

Orchestrator SSRS Reports

This one is from Steve Jesok. He is the man when it comes to automation. Steve has taken the time to share some very useful Orchestrator reports with the community.

summary

Orchestrator does not come with any reporting out of the box. For insight into your Orchestrator environment you have to create your own reports. Here is a blurb from the description of the reports:

“This collection of reports was put together to help me spot check the health of my servers and identify usage and failure patterns easier.  The reports are based on a number of common Orchestrator SQL queries you find used to gather different bits of information, this is simply an attempt to put more of those bits in one place.”

You can download the reports here:
https://gallery.technet.microsoft.com/Orchestrator-SSRS-Reports-ac304a7d

Thanks Sam and Steve!

Read more