Can FlexNet Manager Suite collect server hard drive usage (gb) information?

[Tbeck159001]

Is there any way to collect server hard drive usage (gb) information within FNMS via the Flexera agent or MECM data import?

[dbeckner]

Server HD usage is not collected by default. You get a total drive capacity and total number of drives under the Hardware tab on an inventory device, but not further breakdown. You could consider creating custom fields and connecting to another data source that has that information and import it into the tool if you wish. 

[mfranz]

Hi,

The default wmitrack.ini does contain the "Win32_LogicalDisk" class and the "Size" and "FreeSpace" properties. If you run the default config, you should have this information in your inventory database. Here is an example query to extract the data:

USE FNMSInventory

SELECT
	c.ComputerCN
	,hc.Class
	,ho.HardwareName
	,hp.Property
	,hv.Value
FROM Computer c
JOIN HardwareObject ho
	ON c.ComputerID = ho.ComputerID
JOIN HardwareClass hc
	ON ho.HardwareClassID = hc.HardwareClassID
		AND hc.Class = 'Win32_LogicalDisk'
JOIN HardwareValue hv
	ON ho.HardwareObjectID = hv.HardwareObjectID
JOIN HardwareProperty hp
	ON hv.HardwarePropertyID = hp.HardwarePropertyID
WHERE hp.Property IN ('Size', 'FreeSpace')

You could use this for external reports, calculate a factor from these values, or as @dbeckner mentioned, put it to a custom field in FNMS.

Best regards,

Markward

PS: I am not sure how the data is holding up for other OS', my test data set is currently only Windows machines.

[mfeinman]

I don't think available freespace and drive capacity is captured for Linux devices.

If I modify your query to show me everything about a Linux device, nothing that looks like drive capacity is returned.  Try this (put in a Linux device name)"

USE FNMSInventory

SELECT
	c.ComputerCN
	,hc.Class
	,ho.HardwareName
	,hp.Property
	,hv.Value
FROM Computer c
JOIN HardwareObject ho
	ON c.ComputerID = ho.ComputerID
JOIN HardwareClass hc
	ON ho.HardwareClassID = hc.HardwareClassID
JOIN HardwareValue hv
	ON ho.HardwareObjectID = hv.HardwareObjectID
JOIN HardwareProperty hp
	ON hv.HardwarePropertyID = hp.HardwarePropertyID
--WHERE hp.Property IN ('Size', 'FreeSpace')
WHERE c.ComputerCN = '<<put a Linux device name here>>'
ORDER BY c.ComputerCN, ho.HardwareName

--Mark