'System Hidden' Label Type in Reports - Why?
Hi guys,
Got a weird one - noticing on some of my device reports, for the field Label, it will list the assigned label, but then on some of them, it will also put a label of 'System Hidden'.
I've scanned all over and tried to figure out where this is coming from - but no avail. That occasional extra label is messing with the grouping on my reports - so I'd love to just remove it, but when I go to edit the device's label, only the existing label shows up - can't see nor delete 'system hidden' from a device (appears to only show up in the reports).
Any ideas? Anyone else encounter this?
Thanks!
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
9 years ago
When you join to the label table you should exclude hidden labels:
LEFT JOIN LABEL ON (LABEL.ID = MACHINE_LABEL_JT.LABEL_ID AND LABEL.TYPE <> 'hidden')
The appliance uses some hidden labels in the background that you can exclude from your reports.
