Machine Labels for Server Roles (4277186)

Servers on the network that serve special roles such as DNS, Exchange or SQL servers are subject to special rules and circumstances that workstations and file servers are not subject to. Putting them into normal patch schedules can cause patching for the rest of your network to be too restrictive, or can cause the servers to be unavailable during vital times. Labeling them by server role instead of OS will allow you to make special patching schedules that can be run separately and customized for network needs. 

CODE WRITTEN BY QUEST KACE SUPPORT FOR DEMONSTRATION PURPOSES ONLY AND NOT SUPPORTED BY KACE TECHNICAL SUPPORT.   CLIENT CONFIRMS THE NEED FOR TESTING AND ACCEPTS ALL RESPONSIBILITY FOR USE AND MISUSE OF CODE. QUEST KACE SHALL NOT BE HELD LIABLE FOR DAMAGE OR DOWN TIME RESULTING  FROM USE OF THIS OR ANY CODE PRESENTED FOR PURPOSES OF TROUBLESHOOTING OR DEMONSTRATION.

The following SQL is provided as a courtesy and not supported by KACE Technical Support.

WARNING:  Any labels created should be tested to ensure the desired result before using in patching.

The following method will allow you to label a machine according to its role and NOT its OS.

1. Click Home | Label | Smart Labels
2. Click Choose Action and then select Add New Machine Label.
3. Leave everything default and give your label a name and then click Create.
4. Go back to Labels | Smart Labels and click the new label name.
5. You want to edit it in the SQL editor.
6. Replace the SQL with the below code.

SELECT MACHINE.NAME AS SYSTEM_NAME,

SYSTEM_DESCRIPTION,

MACHINE.IP,

MACHINE.ID as TOPIC_ID FROM MACHINE 

WHERE ((( exists  (select 1 from SOFTWARE, MACHINE_SOFTWARE_JT where

MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID AND

SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and

SOFTWARE.DISPLAY_NAME = 'Microsoft Exchange Server')) ))