/build/static/layout/Breadcrumb_cap_w.png
11/07/2019 102 views

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?

Thanks

0 Comments   [ + ] Show comments

Comments


All Answers

1

Try exploring this:


SELECT MACHINE.NAME, LABEL.NAME
FROM MACHINE
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.


Thanks,

Answered 11/07/2019 by: feeldamped
Third Degree Blue Belt