Subscribing is a smart move!
You can subscribe to this forum after you log in or create your free account.
Custom Insight report - how to add Custom propertie values to report?
EcoStruxure IT forum
A support forum for Data Center Operation, Data Center Expert, and EcoStruxure IT product users to share knowledge on installation, configuration, and general product use.
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we?ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
Solved
Go to Solution
Link copied. Please paste this link to share this article on your social media post.
Accepted Solutions
Link copied. Please paste this link to share this article on your social media post.
Hello Valentin.
Ok, I admit your question made me think about how to do what you're asking. So I did a little research, I pasted a section of the Insight view of the Inventory report below. You can certainly create a joined dataset with the existing inventorytags dataset and a new custom properties dataset to join rows to custom properties.
But as I think you already stated in this ticket this means you'd get a series of addition rows in your output, one for each custom property assigned to the device (right?).
So, I think you need to create a group in each section... the group would be based on name and location perhaps? Then you'd want to move the data fields in the above detail rows to the group footer row, then change your new custom property field to an string field which you aggregate the custom property value from each returned row into a list. So the grouping will produce one row of output for each inventory item and location, then your list of custom properties would only be outputted on the footer.
Make sense? I think this would work.
GregS
Link copied. Please paste this link to share this article on your social media post.
Hello Valentin.
Ok, I admit your question made me think about how to do what you're asking. So I did a little research, I pasted a section of the Insight view of the Inventory report below. You can certainly create a joined dataset with the existing inventorytags dataset and a new custom properties dataset to join rows to custom properties.
But as I think you already stated in this ticket this means you'd get a series of addition rows in your output, one for each custom property assigned to the device (right?).
So, I think you need to create a group in each section... the group would be based on name and location perhaps? Then you'd want to move the data fields in the above detail rows to the group footer row, then change your new custom property field to an string field which you aggregate the custom property value from each returned row into a list. So the grouping will produce one row of output for each inventory item and location, then your list of custom properties would only be outputted on the footer.
Make sense? I think this would work.
GregS
Link copied. Please paste this link to share this article on your social media post.
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.