Hi,
On a few versions of Solarwinds the following query returns an error, Message: Cannot resolve property EntPhysicalIndex
When I looked at the different schemas 2018,2019,2020 they all have EntPhysicalIndex column defined.
Is there a version of NCM in which this column was introduced or is this error caused by a different reason ?
select
EntityID,
EntityName as entPhysicalName,
EntityDescription as entPhysicalDescr,
EntityType as entPhysicalVendorType,
ContainedIn as entPhysicalContainedIn,
EntityClass as entPhysicalClass,
Position as entPhysicalParentRelPos,
HardwareRevision as entPhysicalHardwareRev,
FirmwareRevision as entPhysicalFirmwareRev,
SoftwareRevision as entPhysicalSoftwareRev,
Serial as entPhysicalSerialNum,
Manufacturer as entPhysicalMfgName,
Model as entPhysicalModelName,
Alias as entPhysicalAlias,
AssetID as entPhysicalAssetID,
FieldReplaceable as entPhysicalIsFRU,
EntPhysicalIndex as entPhysicalIndex,
NodeID,
DisplayName,
Description,
InstanceType
from ncm.EntityPhysical
