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   [ + ] Show 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.

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
Answer this question or Comment on this question for clarity