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

WQL Query help for Mount Point

So trying to get a WMI Monitor to work based of a query. This query works from the server itself via powershell so I know the query is valid. I am also testing directly from the Solarwinds Server.

Select FreeSpace From Win32_LogicalDisk Where NAME='Z:' | ForEach-Object {[math]::truncate($_.freespace / 1GB)}

I thought maybe it was the conversion I was doing at the end of the query that might be the issue so I removed it yet it still fails upon test.

Select FreeSpace From Win32_LogicalDisk Where NAME='Z:'

Any thoughts? This query is perfect from the server side because it gives me in either GB or MB depending on the modifier the exact amount of space available for a mount point.

Find more posts tagged with

Accepted answers

All comments

mdriskell

I also tested with the default select statement that is in the WMI Monitor to start with Select AvailableMBytes From Win32_PerfRawData_PerfOS_Memory and that works fine and returns an available status when testing. So I know the ability to run the WMI query is working

When testing with Select FreeSpace From Win32_LogicalDisk Where NAME='Z:' It fails with the message failed with 'Undefined' status No results were returned by WQL query

Can anyone help with this? This is one of many WMI queries we will need in order to replace the OpenView agents we are targeting.

qle

Have you tried executing this query remotely using something like wbemtest?

mdriskell

Have you tried executing this query remotely using something like wbemtest?

No I have not...however in my test case...the solarwinds server is the test node. That query works fine when I run it in powershell on the Solarwinds server but not when I test it from the APM interface.

aLTeReGo

You cannot query the status of network volumes mounted on a host via WMI no more than you could map a drive to it. Let me explain.

On your Orion server you have a network drive "Z:" pointed to some network location. Let's say it's "\\remote.server.dom\F$"

No network machine, or even the local machine can map to that path. For example if you try and map a network drive from the server itself to \\127.0.0.1\C$ you can. If you try and map a drive to the path of the already mapped Z: drive such as \\127.0.0.1\Z$ you'll receive an error. WMI is no different. Your script is accessing the mapped drive locally, where APM is accessing WMI remotely, even when on the same machine. Similar to the example above mapping drives locally. This is true even when using the loopback interface.

This is due to user context and permissions. If user "A" logs in their mapped Z: drive may not be what user "B" is who's also logged into the same machine (Think Terminal Services or Citrix). This is the nature of multi-user systems. When a user logs into the server either through the console or through a remote desktop session everything executed is in the context of that user.

If this is something you need working I would recommend running this as a PowerShell script monitor in APM. This is not a limitation of APM, but more of an architecture design limitation of Windows.