Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Convert a Local VBS for use in SAM

I have a local script that utilizes WMI to retrieve the software installed on a server (collecting this from Solarwinds via SNMP does not work well and changing my WIndows servers to be monitored via WMI only is not currently an option). I would like to get this script functionality into SAM to retrieve this info from all of my Windows servers. I have zero experience scripting and no test lab to experiment from so I'm a little nervous about the trial and error method I would employ to try and get this to work. I was hoping this would be a pretty simple task for someone who knows what they are doing and at the very least someone could get me pointed in the right direction and help ensure that I "do no harm" . The working local script that I've been using can be seen here. Thanks in advance.

strComputer = "."

Set objWMIService = GetObject("winmgmts:" _

& "{impersonationLevel=impersonate}!\\" _

& strComputer & "\root\cimv2")

Set colSoftware = objWMIService.ExecQuery _

("Select * from Win32_Product")

For Each objSoftware in colSoftware

Wscript.Echo "Name: " & objSoftware.Name

Wscript.Echo "Version: " & objSoftware.Version

Wscript.Echo "Publisher: " & objSoftware.vendor

Wscript.Echo "Installed: " & objSoftware.InstallDate

Find more posts tagged with

custom script

Accepted answers

All comments

chad.every

So one of the things that you're going to run into with trying to accomplish this is that SAM only allows up to 10 unique output returns. So it isn't going to be able to enumerate all of the installed software like you're wanting.

If you were able to switch to WMI then you can use SAM's Asset Inventory to pull installed software.

Other than those 2 options you're most likely needing something like SolarWinds Patch Manager that can pull software inventories or another 3rd party tool.

Ralphr

So I'm curious, what magical thing happens when you switch a nodes polling method to WMI that allows the software inventory data collection to work without this 10 item return limitation? Switching nodes to WMI will require defining new collections to replace all of my UnDP's (which are many) and re-doing all of the alerts and reports that are based on all of those pollers. This is an effort I am trying to postpone until the day after I retire.

aLTeReGo

Much of the information you're attempting to query is already collected natively by SAM"s Asset Inventory, even for SNMP managed nodes. Have you looked at the Software Inventory Resource on the Asset Inventory sub-view on the Node Details view for one of your WIndows Nodes?

Ralphr

The information that is returned via WMI is more detailed (includes "publisher" and "Version") and more inclusive (shows Oracle apps on my oracle servers and Solarwinds modules on my Solarwinds servers ) then what I get via SNMP.