Label question
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.
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
Answers (2)
Please log in to answer
Posted by:
GillySpy
13 years ago
If your IT group was in a label called "IT" then you could exclude that label from your smart label.
e.g.
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
Posted by:
airwolf
13 years ago
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.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
