Automate!

Austrian Blog around optimizing datacenters with Powershell and Azure

PowerShell your ServiceManager & ITAM: Get Discovered Computer Information

No Comments »

Hi all !

Lets focus on a simple problem, many Service Manager / ITAM customers probably have. A set of discovered computers by AD/SCCM is imported into the ServiceManager CMDB with more or less useful information. On the other hand there is unstructured ITAM data. So what those many people want is:

Create an Asset for every Computer CI in the CMDB !

Even if this is not best ITAM practice, it is a common question/demand, this blog addresses

The solution can be easily done with the ScsmPX Module on GitHub and a little piece of code. In the files available in the download section you will find the Powershell Script, and the Provance Import Template to allow the creation of Assets with Provance DMP.

[codesyntax lang=“powershell“ lines=“normal“ container=“pre“]

[/codesyntax]

The Import Template uses this CSV and loads the Data as Assets, depending on if its physical Computers or virtual machines. Below find a screenshot of the template:

Import-Template

Screenshot of the Import Template (Provance Data Management)

Finally if you load the data with the Provance DMP you get:

  • Physical Hardware Assets + Assigned User
  • Hardware Catalog Items for Physical Computers + related Vendor
  • Virtual Computer Assets + Assigned Users
  • All assets are linked to CI´s

Way to go and start importing/editing financial data for your assets

Update: Sept 2015: Script now uses Powershell v3 PSObject way of creating arrays

Cheers / Roman

Script and Import Template

PowerShell your ServiceManager & ITAM: Intro

No Comments »

Dear All !

Service Manager has a wide range of customers and many people deploy or use it in operations. All those know that Service Manager needs customization and sometimes also development to fulfill the needs of IT organizations.

This blog is the starting point of a series to manage Service Manager with Powershell.

BORING you might be forced to say – but wait – this series differs from all those tons of other blogs out in the wild by a couple of facts i will explain now.

  1. No SMLets – SMLets are still in Beta and the future is unclear
  2. Leverage ScsmPX Modules. Kirk Munroes´s (the Poshoholic :-))  ScsmPX Module is Open Source, is based on Microsofts SCSM-native Modules and extends them with the functions that are missing.
  3. No SMA, Orchestrator, or other SC products just native PowerShell. We know you can call anything from anywhere so automation is  limitless (SMA,SCOR,SCSM, …) but we want to focus on the basics.
  4. Examples will be based on Service Manager and Provance 2014 ITAM, from what i saw in the field but the examples are open so you will be able to adapt them to your needs.

The first entry will be posted soon, so stay tuned.

R.

Links:

https://kirkmunro.github.io/ScsmPx/

Update #1: I have attached a screenshot sample in PDF of „How to runa powershell script with parameters with task manager“ because the exampled following are based on that and so you have a easy reference for configuring Task Scheduler.

Run a Powershell Script with Paramaters with task Scheduler

Provance ITAM Integration with SAP

No Comments »

Hi all !

A question / demand of customers which comes very often is how to integrate Asset Management with ERP. In this demo
i am going to show you how this can be done with the help of SystemCenter Tools and Provance Software.

SAPProvanceExampleScrSh

You will first see a Powerpoint with the scenarios i created for the demo and then the actual implementation.

==> YOUTUBE VIDEO ==> Click on the Link for the video.

What you need to implement this is:

  • System Center Service Manager 2012 SP1
  • System Center Orchestrator 2012 SP1
  • Provance Asset management Pack
  • Provance Data Management Pack
  • Provance Support Powershell Module (Ask Provance)
  • Orchestrator Powershell Integration Pack 1.2 http://gallery.technet.microsoft.com/Orchestrator-Integration-438f9ece
  • good process definitions because automation needs a high level of standardization

Technical Implementation

1.) Installation of the Provance Support Modules

Contact support@provance.com to get the the latest support-modules. This are 2 Files, ProvanceSupport and ScsmLoader.
Extract them to a folder within the PSModulePath Environement Variable.
A Powershell session should (if correctly installed) allow you to load

After that the „Import-ProvanceData“ command should be available.

2.) Preperation of the first SCSM Management Server (Workflow Server)

On the Workflow Server there has to be one account which is allowed to import DMP Data, this account will be used by the
remote Powershell Session to start the DMP Import. So before playing around with Orchestrator log in with that account
and try to import data with the DMP via Powershell.

The account you are using must have started the SCSM Console successfully once, bcs. the import-provancedata command
uses the registry entries to connect to the manegement server.

 3.) Preperation of Orchestrator.

Have Orchestrator 2012 SP1 (i am running R2) installed, the Service Manager 2012 OIP installed and configured
and the Powershell Extension 1.2 installed and configured.

Execute_PSScript

The Powershell execution activity needs to be configured that way.

ProvanceDMPProperties

Enter a the Workflow Server as the hostname, domain, username and password of the account you have been
configuring for the DMP Import.

The command in „PS Script 01“ is:

All the other technical implementation details are shown in the video. Attached to this BlogEntry you find:

  1. Runbook example on how to start DMP Import from Orchestrator (DMPImportExample.ois_export)
  2. Runbook example for a purchase order export (WritePOFile.ois_export)
  3. DMP Templates and example files ImportTemplatesandFiles.zip

I hope you have found that useful, if you have questions, at the very beginning of the video you find my E-Mail Adress.

Best regards / Roman

ProvanceSAPFiles

Provance DMP: Import Hardware Assets and link them to a Warranty Contract

No Comments »

Hi All !

The value of Asset Management products should be more than a status of single assets, and thats where agreements and contracts come into the game.

So when your company has Provance ITAM and DMP in place this video shows how you can import Hardware Assets, link them to Models and to a warranty Agreement by creating warranty contracts.

The files are attached below, have fun watching and trying.

http://youtu.be/80uBQ2zPlR0

Hardware-linked-to-warranty

Roman