View Smart Lables and What Machines They Are Applied To
We're going to have to rebuild a bunch of Smart Labels and reapply them to the machines they are currently associated with.
Is there a SQL query/table that contains this info? E.g., list all smart labels and how many machines are are associated with it, and then maybe query a specific smart label for a list of all machines associated with it?
Answer Chosen by the Author
Try exploring this:
SELECT MACHINE.NAME, LABEL.NAME
LEFT OUTER JOIN MACHINE_LABEL_JT ON MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID
LEFT OUTER JOIN LABEL ON MACHINE_LABEL_JT.LABEL_ID = LABEL.ID
You can add a filter for specific labels in here, or just dump everything into Excel and filter there. Let me know if you need any help/questions.