Inventory Report suggestion needed

[Tao Yang]

I am planning to get some reports such as, monthly/quarterly inventory reports for "Devices Pingable only", "Devices in thresholds profiles", "Devices in monitory profiles" etc. The up-management needs these reports from NetOps.
Any suggestion if there's any good method to get these reports easily?

Thanks!

[Michael Poller]

Hello Tao,

There are some Inventory List Views available to use in setting up a Dashboard that shows some of the requested info. That could be shared with users and they could filter them as needed.

That could also be set up as a scheduled report to run and send to end users on a given schedule.

Some of the things that won't provide are Monitoring Profile or Threshold Profile to Device associations. Not sure what the value in a report about that information would provide.

There are a few other options but not available via the UI reports. Things like these articles describe.

• Performance Management Inventory per Item and Device
  
• List devices for a Metric Family in Performance Management Data Aggregator
• Viewing Vendor Certification assignment by Device or Component item

Hope that helps!

Thanks,
Mike

------------------------------
Technical Support Engineer IV
Broadcom
------------------------------

[Tao Yang]

Thanks a lot Mike!

So something like the following SQL query is issued from Linux server command line?

dradmin=> select REPLACE(facet_qname, '{http://im.ca.com/normalizer}', '') facet_qname, count(*) from dauser.v_item_facet where facet_qname like '%normalizer%' group by 1 order by 2 desc limit 20;

[Michael Poller]

Hi Tao,

Glad that helps.

Yes, that is a Vsql query that needs to be run in a Vsql prompt opened on one of the Data Repository Vertica DB cluster nodes.

Thanks,
Mike

------------------------------
Technical Support Engineer IV
Broadcom
------------------------------

[Tao Yang]

Thanks again Mike!!!