Can K1000 tell us if any servers are set for auto updates ?
Can K1000 tell us if any of our servers are set for auto updates ?
I want to avoid servers rebooting since tmrw is patch Tuesday.
2 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
However, we could not make the SQL part work. Any SQL gurus out there ? - endlessknot 8 years ago
MACHINE.NAME as SYSTEM_NAME,
MACHINE.OS_NAME as OPERATING_SYSTEM,
IP as IP_ADDRESS,
REPLACE(MACHINE.USER_LOGGED, '\\', '\\\\') as LOGGED_ON_USER,
CASE
WHEN STR_FIELD_VALUE LIKE '%1%' THEN 'Enabled'
ELSE CASE
WHEN STR_FIELD_VALUE LIKE '%0%' THEN 'Disabled'
ELSE 'Unknown'
END
END AS 'ST Servers Windows Update Status OFF'
from
MACHINE
inner join
MACHINE_CUSTOM_INVENTORY ON MACHINE_CUSTOM_INVENTORY.ID = MACHINE.ID
inner join
SOFTWARE ON MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID = SOFTWARE.ID
WHERE
SOFTWARE.DISPLAY_NAME = 'ST Servers Windows Update Status OFF' - endlessknot 8 years ago
When you view the ST Servers Windows Update Status OFF software title does it report the correct data?
>> No. The result is blank. Not a single server is listed. - endlessknot 8 years ago