I would like an alert or report on the italicized servers listed in IVIM, so we can make sure they get added to Orion for full monitoring.
Anyone have one setup?
Not setup but I'd look first in the vim discovered nodes table.
If that doesn't resolve host name then maybe join to nodes or vim nodes by IP address?
Luckily the built in alert object looks at a proper view with all the details you need.
For an alert:
SELECT VirtualMachinesView.VirtualMachineID, VirtualMachinesView.DisplayName FROM VirtualMachinesViewWHERE VirtualMachinesView.NodeID IS NULL
For a report, you can see the following out of the same view:
SELECT * FROM VirtualMachinesView
UUIDHostNodeIDNodeIDVirtualMachineIDVMIDDisplayNameVMConfigFileMemoryConfiguredMemorySharesCPUSharesOperatingSystemGuestStateVMwareProductNameVMwareProductVersionVMPollingJobIDifinOctetsTotalifoutOctetsTotalHostNodeNameSampleTimeCpuUtilizationMemoryUtilizationSwappedMemoryUtilizationBalloonMemoryUtilizationAvailabilityNetworkUtilizationcpuUtilkbTxkbRxPlatformIDPlatformNameCpuReadyIOPSTotalIOPSReadIOPSWriteLatencyTotalLatencyReadLatencyWriteBootTimeRunTimePowerStateCpuCostopSnapshotSummaryCountDateCreatedOldestSnapshotDateHeartBeatSnapshotDateModifiedMemoryAllocationLimitVirtualDiskDateModifiedVolumeSummaryFreeSpacePercentage
UUID
HostNodeID
NodeID
VirtualMachineID
VMID
DisplayName
VMConfigFile
MemoryConfigured
MemoryShares
CPUShares
OperatingSystem
GuestState
VMwareProductName
VMwareProductVersion
VMPollingJobID
ifinOctetsTotal
ifoutOctetsTotal
HostNodeName
SampleTime
CpuUtilization
MemoryUtilization
SwappedMemoryUtilization
BalloonMemoryUtilization
Availability
NetworkUtilization
cpuUtil
kbTx
kbRx
PlatformID
PlatformName
CpuReady
IOPSTotal
IOPSRead
IOPSWrite
LatencyTotal
LatencyRead
LatencyWrite
BootTime
RunTime
PowerState
CpuCostop
SnapshotSummaryCount
DateCreated
OldestSnapshotDate
HeartBeat
SnapshotDateModified
MemoryAllocationLimit
VirtualDiskDateModified
VolumeSummaryFreeSpacePercentage
Hope that helps!
-ZackM
Loop1 Systems: SolarWinds Training and Professional Services
