Having an up-to-date inventory of your network and storage devices is important to ensure you are able to manage all of your devices. Since NAS devices are a prime targets for attackers, it is important to make sure that they are always on the latest firmware available to prevent any sort of vulnerability in your security. You can get more information on our QNAP NAS blog.
The report below provides an overview of all QNAP NAS assets in your environment. Additionally, if you’ve scanned any data with custom OID scanning, this is also displayed.
QNAP NAS Assets Query
Select Top 1000000 tblAssets.AssetID,
tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssets.AssetName,
tblOIDData.Label As [OIDLabel],
tblOIDData.Data As [OIDData],
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
left Join tblOIDData On tblAssets.AssetID = tblOIDData.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Outer Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Outer Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where tsysassettypes.AssetTypename = 'NAS' And tblassetcustom.State = 1 and tblAssetCustom.Manufacturer LIKE '%QNAP%'
