Deanr Posted January 29, 2021 Report Share Posted January 29, 2021 Has anyone successfully designed a PowerBL Dashboard for Domotz, I am struggling with it. Link to comment Share on other sites More sharing options...
Azza Posted January 29, 2021 Report Share Posted January 29, 2021 Hi! It's still quite experimental but I've developed a custom connector for the public API you can find installation and usage info here: https://blog.domotz.com/power-bi-api-network-reports/ let me know if you have any issue! Link to comment Share on other sites More sharing options...
Deanr Posted January 29, 2021 Author Report Share Posted January 29, 2021 Hi Azza I have used the PowerBI connector but struggling to make sense of the data. It is only showing 6 of my agents. Link to comment Share on other sites More sharing options...
Azza Posted January 29, 2021 Report Share Posted January 29, 2021 That's strange. I've just tested with an account where I have access to 8 agents, are you sure there's no filter set (display_name, page_size)? Link to comment Share on other sites More sharing options...
Deanr Posted February 19, 2021 Author Report Share Posted February 19, 2021 Hi Azza I am having the same issue with the node red integration. It is only pulling 9 sites from the API, the rest of my sites are missing. Link to comment Share on other sites More sharing options...
Azza Posted February 19, 2021 Report Share Posted February 19, 2021 Hi Dean, I'm sorry about that, it was not really clear from the API documentation that the default page size for agents list is 10. We recently updated the documentation https://portal.domotz.com/developers/#listagents to mention the default page_size=10 You can increase the page_size param to retrieve all your agents, sorry for the inconvenience Link to comment Share on other sites More sharing options...
Alerts Posted February 22, 2021 Report Share Posted February 22, 2021 I'm trying to create one report in Power BI Desktop that shows the following info for our security team. How can I do this: Hostname IP Addresses MAC addresses Type (router, switch, server, et cetera) TCP/UDP services along with ARP and ICMP info OS (+version/build number) List of applications installed per device Basic Hardware information (physical/virtual, attached storage, cpu, NIC state, et cetera) Link to comment Share on other sites More sharing options...
MichaelB. Posted March 2, 2021 Report Share Posted March 2, 2021 Hi Alerts, you can retrieve the informations about the Hostname, IP Addresses, MAC addresses, Type, and TCP/UDP services following these steps. 1. Import the listDeviceBaseTypes and listDevices (you must specify the agent id here): 2. you need to transform the imported list of devices in a table (clicking on the header) and then expand to columns (please, remember to click on "Load more" before expanding the columns) 3. you need to expand to column the fields "user_data", "type", and "names" (in the latter you find the names of each device: host, bonjour, upnp, dhcp, snmp, and inspection) 4. then you need to go in the section "Add Column" and click on "Custom Column" for the actual device type: = if [Column1.user_data.type] <> null then [Column1.user_data.type] else [Column1.type.id] 5. in the section "Home", under "Combine", select "Merge Queries": you need to select the listDeviceBaseTypes highlighting the newly added field and the field "id" specifying the Join Kind = Left Outer 6. finally you need to expand the listDeviceBaseTypes To add the IP Addresses you need to do the "Extract Values..." on the field "ip_addresses" and then to eventually do the "Replace Errors" (I suggest with blank values) TCP/UDP services can be retrieved by doing the "Expand to New Rows" to the field "ip_ports" and then expanding the result to columns (please, note that this will increase the cardinality of the table) Finally, the MAC address of each device is in the column "hw_address". For the other points of your request, at this time it is not possible to be retrieved in Power BI. I hope this help. Best, Michael Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now