/build/static/layout/Breadcrumb_cap_w.png

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.

0 Comments   [ + ] Show comments

Answers (2)

Posted by: GillySpy 12 years ago
7th Degree Black Belt
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
Posted by: airwolf 12 years ago
Red Belt
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.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ