Windows Services
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?
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
Answers (1)
Please log in to answer
Posted by:
dchristian
12 years ago
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.
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
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
