Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Invite a Co-worker
Send a co-worker an invite to the 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.
DCE 7.3.1
I'm trying to get the model or part # to appear in a line of a UPS age report. The best I can find is adding the Device Status sensor to the report criteria, but it puts it on another line. This would be fine if I had just a few units, but there is 549 in this system. And I'd like just the model or part # there without the "Device Status" bit. Also, I know what the min/max/avg columns are for, but they don't have any relevance to this report. Couldn't it just say the age in days? Thanks!
Accepted Solutions
Link copied. Please paste this link to share this article on your social media post.
Hi Bob,
Since in this case the model is another sensor value, it can not be added to the same line. You're trying to create a single point using 2 sensors and that won't work. As you have seen, there are limited column listings that you can add to report by default.
The only way around this wold be to create a custom property. You can Create something and name it whatever you'd like:
It will show up in device view if you chose it:
...AND you can add it under report options:
The bad part of it is that each device would need to have this value added manually.
I can not say that it will be implemented or if so, when, but at least for this type of report it seems the UPS Model would be a valid column. I have added an enhancement request into the system.
The only other option at this time would be to run the report against both sensor values as you did and get the values in different rows then use a separate utility (Microsoft Excel) to realign the data.
Steve
Link copied. Please paste this link to share this article on your social media post.
Bob, You can remove the unwanted columns by clicking on the "edit report Options" which is highlighted in my image. Then just select which you want or don't want and even change the order.
Enjoy!
Link copied. Please paste this link to share this article on your social media post.
Hi Bob,
Since in this case the model is another sensor value, it can not be added to the same line. You're trying to create a single point using 2 sensors and that won't work. As you have seen, there are limited column listings that you can add to report by default.
The only way around this wold be to create a custom property. You can Create something and name it whatever you'd like:
It will show up in device view if you chose it:
...AND you can add it under report options:
The bad part of it is that each device would need to have this value added manually.
I can not say that it will be implemented or if so, when, but at least for this type of report it seems the UPS Model would be a valid column. I have added an enhancement request into the system.
The only other option at this time would be to run the report against both sensor values as you did and get the values in different rows then use a separate utility (Microsoft Excel) to realign the data.
Steve
Link copied. Please paste this link to share this article on your social media post.
This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.