/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Can K1000 tell us if any servers are set for auto updates ?

03/07/2016 796 views

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.

Be the first to answer this question

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ