IMC Custom Report - DataField Entries missing

[kd7]

Hello,

I'm new here; hopefully this is the right place to get help. I have IMC in our environment and was trying to do a report to get the firmware on all the switches. However, in the Report Design > Datafields, it's missing the following 3 fields:

1. Hardware Version

2. Software Version

3. Product Number.

I need the software version to get the firmware on the switches and our IMC server is running 7.3 Platform. Any ideas on why those are missing in the reports?

Thanks

[jguse]

Hello,

iMC provides some pre-defined report templates for this purpose, I'd suggest using those instead. Check out Report > Report Template List (V2 Template) > Device Asset Report V2 and Device Asset Report (Concise) V2. These reports will generate a list of all your devices along with their current software/firmware versions according to the Custom View you select (My Network View to include all devices).

[kd7]

Thanks for the reply; however, I already know we can do that, but the report doesn't come out clean and there are duplicates.

I also would like to know why those data entries are missing and what is different than the ones that do have it? Is something configured wrong or is there some sort of update? What is the cause of the missing data entries? 

[jguse]

Hello,

I guess you mean the fact that it lists the modules in switch chassis' as well? That's by design to inform you about which modules are installed where. You could export this report to excel, apply filtering to the columns, and then filter by Unit Model = Device to see only the devices.

Alternatively as a workaround, you could get such data directly from the DB with an SQL query. Here is an example with MSSQL that I run in the Management Studio to retrieve the kind of information you are looking for, without the modules and such:

SELECT [device_id]
,[physical_name]
,[physical_hardware_rev]
,[physical_software_rev]
,[physical_serial_num]
,[physical_model_name]
FROM [invent_db].[imc_inventory].[tbl_inventory_info]
WHERE (([entity_physical_flag] = 0 and [stack_flag] = 0) or ([entity_physical_flag] = 1 and [stack_flag] = 1)) and DATALENGTH([physical_serial_num]) > 0;

Some explanation for the WHERE statement - the 'device itself' matches to entity_physical_flag = 0 while modules and other components = 1, so that is matched to filter out modules and such. Unless it is stacked (IRF for example), in which case the match for the physical_flag = 1 and stack_flag = 1 ensures we see the individual IRF-stacked devices (but not the combined virtual stack device). Checking for the datalength on physical_serial_num ensures we don't see things like VMs on the list (that don't have a Serial Number).

Hope that helps.