There are certain windows services that we deem as a risk and would like to disable. I would like to make a smart label basically to assist with disabling those services via batch script.

Is there any easy way to figure out the right SQL statement for "advanced" fields that are not included in the K1 Smart Label Creation process?

For example, under services is "lanman server" aka server service. We would like to disable this on every machine except for servers. Under the smart label creation process there is no option for "IF SERVICE CONTAINS LANMAN AND SERVICE IS = RUNNING"

So is there an easy way to do this with a SQL statement and is there an easy way to figure out the field names?
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
Here's a report i use to check the status of services for computers.

Take a look at some of the other post around here on how to convert the sql into a smart label.

SELECT M.NAME,
M.OS_NAME,
N.DISPLAY_NAME,
N.STATUS,
N.STARTUP_TYPE
FROM NTSERVICE N,
MACHINE_NTSERVICE_JT MN,
MACHINE M
WHERE M.ID = MN.MACHINE_ID
AND N.ID = MN.NTSERVICE_ID
ORDER BY NAME,
STATUS,
DISPLAY_NAME
Answered 02/04/2012 by: dchristian
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity