After upgrading System Center Orchestrator from 2012 RTM to 2012 SP1 and also the System Center integration packs including System Center Operations Manager 2012 SP1 Integration Pack I realized that the monitor setting entry has changed.
I have a small runbook that shows this. The first activity only translates a netbios servername to a FQDN and the second activity sets the maintenance in SCOM.
The Start Maintenance Mode activity looked like this before the upgrade to SP1:
The Monitor entry had a format like this: Microsoft.Windows.Computer:ServernameFQDN to set the whole server into maintenance.
After upgrade to SP1 you get the following error.
So it does not find the monitor anymore.
Change the activity to this:
The monitor entry needs to have this format now:
ServernameFQDN : Microsoft.Windows.Computer:ServernameFQDN
Now it should run successful.
In most companies data is spread across different tools / software. SharePoint is one common software to store data. Without a central CMDB you perhaps also have data about servers, server owners, etc. stored in SharePoint. SCOM could use this data to update for example custom fields in alerts http://systemcentersolutions.wordpress.com/2010/06/01/updating-custom-fields-using-powershell/.
SCORch could process this data for example within an activity. The best way to do that is through PowerShell.
With SharePoint 2010 you have PowerShell cmdlets to grab this data easily. With SharePoint 2007 you can utilize the WebService. I want to focus on this solution.
Use the script from this blog: http://blogs.msdn.com/b/powershell/archive/2010/06/24/using-new-webserviceproxy-to-get-modify-and-add-items-to-a-list-in-sharepoint-2007.aspx.
If you only need some fields, then you can see the available fields by entering $list.data.row | get-member at the end of the script or if you already know which field you want to see, then you can use this format:
If the fieldname contains spaces then replace them with _x0020_.
Fieldname: Management Pack
So use it like this:
Foreach ($listitem in $list.data.row)
$line = $listitem.ows_title, $listitem.ows_Management_x0020_Pack
# this example writes a log file, but you can also use the data in another way
# => see the link to the blog to update custom fields.
out-file -FilePath c:\list.log -InputObject $line -Append