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

Comments

  • I opened a ticket and the Tech created a custom Inventory Rule by following this KACE KB: https://support.software.dell.com/k1000-systems-management-appliance/kb/112033

    However, we could not make the SQL part work. Any SQL gurus out there ?
    • Can you post the SQL of the custom inventory rule?
      • Select
        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'
      • When you view the ST Servers Windows Update Status OFF software title does it report the correct data?
  • This content is currently hidden from public view.
    Reason: Removed by member request
    For more information, visit our FAQ's.
  • Hi chucksteel,

    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.
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity