Help with asset report

Hi All,

The "Inventory Fixed Asset Report" has a lot of what I want - including "Node Name", "Device Type", "Service Tag" and "Manufacturer". I'd like to add "Network Interfaces" - "Mac Address". This information is visible on the node's "Asset Inventory" page, under the "Network Interfaces" section, then lists all the interfaces and MAC Addresses.

I can't figure out how to filter the "Inventory Fixed Asset Report" for only device type = workstation, and then add the MAC address.

Should I be doing this in the web report section? Do I need to go on the Orion server and futz with the database tools to build some sort of query? It's certainly not as intuitive as the rest of NPM.

Thanks!

Find more posts tagged with

asset report

Accepted answers

All comments

nick_scott

There are certain limitations with web reports. I have noticed that when you start joining multiple tables the Web Reporter seems to run out of options. Network interfaces and Mac Address info can be found in the 'interfaces' table. Over the years I have learned to get very familiar with Database Manager and basic SQL querying. If you still need help after looking at DB manager please reply.