SAM & Multi-Statistic Component Scripts

by

In September I wrote a few things about how I use SAM Script Templates – specifically with PowerShell. One of the more powerful things in the SAM arsenal is the ability to return multiple components in a single script. I’ve used this in any number of ways, but the one that gives me the most satisfaction is a PowerShell script that I wrote for Linux.

Read more

Scripting SQL Server Installation

by

This is where I show that I’m really not a DBA.  I’m an Accidental DBA at best, and a nuisance at worst.  SQL Server already has the capability to be installed via command line parameters or a configuration file.  If I setup the machine the same way every single time, this would be fine, but since I need to change the placement of certain file types, I need to have the ability to change on the fly.

Read more

Simple Automation Example using Orion SDK

by

A few months ago, I really stated digging into the Orion SDK and I wanted to know more about ways to automate adding nodes to Orion.  Sure, I can wait for the Network Discovery to kick off, but I’m impatient.  I’ve gotten many of the parts together over time, but this is my first post where I put everything together.  For this version, I use the PowerShell Snap-In.  I will add an additional post later using the PowerOrion Module.

Read more

SAM PowerShell Scripting Template

by

I write a lot of PowerShell scripts.  Like a lot, a lot.  I write them for any manner of things, but recently I’ve been tasked to help out with a few Server & Application Monitor templates.  These are some of the most interesting things that SAM has to offer.

Looking at each of the scripts, I decided it was worth revisiting based on some of my newly acquired PowerShell superpowers (cape not included).

SAM script templates (Windows Scripting, PowerShell, Perl, Python, whatever) require two things – a statistic and an exit code.

Read more

Mass Export of NCM Device Templates

by

Do you run a bunch of Orion servers?  Do you hate exporting your custom NCM Device Templates one at a time?

No?  Only me?

Well, if you are ever like me, I’ve got something to help you out.

It basically checks for all the device templates in your database for those that aren’t out of the box and exports them in the proper format.

Read more

Installed Modules (Orion)

by

Installed Orion Modules

SELECT CASE
          WHEN Name = 'APM'     THEN 'Server & Application Monitor'
          WHEN Name = 'IPAM'    THEN 'IP Address Manager'
          WHEN Name = 'NCM'     THEN 'Network Configuration Manager'
          WHEN Name = 'NPM'     THEN 'Network Performance Monitor'
          WHEN Name = 'NTA'     THEN 'NetFlow Traffic Analyzer'
          WHEN Name = 'Orion'   THEN 'Orion Core'
          WHEN Name = 'SEUM'    THEN 'Web Performance Analyzer'
          WHEN Name = 'SRM'     THEN 'Storage Resource Monitor'
          WHEN Name = 'Toolset' THEN 'Enterprise Toolset'
          WHEN Name = 'UDT'     THEN 'User Device Tracker'
          WHEN Name = 'VoIP'    THEN 'VoIP & Network Quality Manager'
          WHEN Name = 'EOC'     THEN 'Enterprise Operations Console'
          ELSE Name
     END AS [Product Name]
     , Version
     , CASE
          WHEN IsEval = 'True' THEN  CONCAT('Evaluation (', [DaysRemaining], ' days left)')
          ELSE 'Licensed'
       END AS [License Type]
      
FROM Orion.InstalledModule
ORDER BY CASE
          WHEN Name = 'APM'     THEN 9
          WHEN Name = 'IPAM'    THEN 5
          WHEN Name = 'NCM'     THEN 4
          WHEN Name = 'NPM'     THEN 2
          WHEN Name = 'NTA'     THEN 3
          WHEN Name = 'Orion'   THEN 0
          WHEN Name = 'SEUM'    THEN 11
          WHEN Name = 'SRM'     THEN 10
          WHEN Name = 'Toolset' THEN 8
          WHEN Name = 'UDT'     THEN 6
          WHEN Name = 'VoIP'    THEN 7
          WHEN Name = 'EOC'     THEN 1
          ELSE 99
        END