/bundles/itninjaweb/img/Breadcrumb_cap_w.png
Our floors at work are divided into subnets
Floor 1 - 10.1.1.x
Floor 2 - 10.1.2.x
Floor 3 - 10.1.3.x
etc....

I have created smart labels that look at the IP address in correlation to the floor. I tend to push out software installs by floor. Since the IT department falls under the 10.1.3.x subnet, they are automatically added per smart label.

I do not want any installs to be pushed to the IT group. I have tried manually removing the specific computers from that group, but it still shows up in the Floor 3 smart label.

Basically, I just want to know if there is a way to remove machines that fall under a specific smart label?

Thanks.
0 Comments   [ - ] Hide Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity

Answers

0
If your IT group was in a label called "IT" then you could exclude that label from your smart label.

e.g.

select MACHINE.ID from
MACHINE
LEFT JOIN
(select MACHINE_ID ID from MACHINE_LABEL_JT
JOIN LABEL L ON L.ID=LABEL_ID and L.NAME='IT') ML ON ML.ID=MACHINE.ID
WHERE
IP LIKE '10.1.3.%'
and ML.ID IS NULL
Answered 11/11/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
Gerald's solution should work. To explain further, in order to exclude anything from a Smart Label, the SQL filter must do the exclusion. You cannot manually remove anything from a Smart Label, because if it still meets the filter criteria it would be added back in.
Answered 11/11/2011 by: airwolf
Tenth Degree Black Belt

Please log in to comment