I am trying to create a custom report. Inside the table layout, I am trying to get the following together.
(Node/Caption) (Node/IP_Address) (Custom Properties/Department) (Network Interface/MAC Address) (Node Current Statistics/Average Response Time) AND (Interface/Speed)
The problem is that I can not add BOTH "Network Interface/MAC Address AND (Interface/Speed)". It is either one or the other.
When I have MAC Address added and try to add Interface/Speed or vice versa. It gives me a error message:
Unrelated Data Columns in the selected category contain data that is unrelated to the other data that is already in this resource. Attempting to join unrelated data may result in slow performance or an invalid database query.
For example, response time history and syslog data are not related, so they should not be included in the same resource.
Select an enabled category to ensure that only related data are used to create this resource. If you are not able to select desired data using this method, use a SQL/SWQL query to select appropriate data sources for your resource.
Is there anyway to add this data for a custom report even though they are unrelated data?