We are looking for a tool that can help us create dashboards/reporting for different elements in FNMS. Specifically, we are looking for Agent Installed vs Uninstalled, Agents not communicating over a predetermined amount of time, and Devices with Inventory dates >= x amount of days. We were pointed to Power BI as a possibility and would like to know if anyone is using it for these purposes or something similar. Also, is anyone leveraging any other products to get this information easily like tableau or a similar product.
Feb 04, 2022 09:51 AM
We are using PowerBI to share with thirdparties KPI about agent, Coverage rate of agent installed (cmdb vs servers with agent).
We connect directly to the FNMS database, using views and service account dedicated. It's easy with Power BI to refresh data when you want after. And you can customize which informations you want to share.
Feb 04, 2022 10:38 AM
can you expand on cmdb vs servers with agent?
Feb 04, 2022 10:40 AM
If you use All asset view, you can compare All inventory with All asset to check the rate coverage of agent in your scope.
In our case, we don't have data in All Asset view, so we make an extract of cmdb (list of servers) to compare with server with agent in order to have coverage rate. And the list of server where we don't have agents.
Feb 04, 2022 10:51 AM
was this relatively easy to accomplish? or alot of trial and error
Feb 04, 2022 10:53 AM
Yes it was easy. If you can find a common key between all your sources, Power Bi can do the job. (example of key : juste the name or combination of name and serial number, it depends of your data)
Feb 04, 2022 10:59 AM