/build/static/layout/Breadcrumb_cap_w.png

Automate the Inclusion of "New" Operating Systems to Custom Inventory Rules?

Whenever a "new" OS shows up on the K1000, that OS is not selected to run any Custom Inventory Rules (CIRs). Unfortunately, "new" can mean a different build of an operating system, which is extremely problematic for Macs. I have 213(!!!) distinct entries for Mac OS X in my "OPERATING_SYSTEM" table, and on CIRs I can see there are 49 which are active. This means that every time the Mac OS is updated I have to go in to each CIR in Software Inventory to enable it in "Supported Operating Systems". As we increase the number of CIRs, this has become untenable: It takes about ten minutes of redundant clicking. This year alone, there have been 8 new OSes detected in my environment. Is there any way to add these automatically to CIRs? Has anyone tackled this problem in another way? Or if anyone knows a uservoice entry for this improvement, let me know.

0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: chucksteel 6 years ago
Red Belt
1

Top Answer

I agree that this is a major annoyance. It should be possible to create a ticket rule that will insert rows into the SOFTWARE_OS_JT table but I haven't experimented with it.


Comments:
  • The problem with that is I don't know a method to select only the "new" OSes in the "SELECT" statement of a Custom Ticket Rule. Since there's no "date added" column in OPERATING_SYSTEMS, I can't query something like "select the OSes that have been added in the past week." So I suppose I'd have to filter by whether or not their included in the SOFTWARE_OS_JT already. But would that mean I'm also going to add all the old OSes that have expired from my environment? - JasonEgg 6 years ago
    • I was thinking that it might make more sense to select based on major and minor version numbers. For instance:
      SELECT * FROM OPERATING_SYSTEMS
      where
      FAMILY = "windows"
      and MAJOR_VERSION = 10

      would get all of the Windows 10 versions.

      Similarly
      SELECT * FROM OPERATING_SYSTEMS
      where
      FAMILY = "mac"
      and MAJOR_VERSION = 10
      and MINOR_VERSION in (9,10,11,12)

      would get the Mac OS 10.9 and above versions. This would let you selectively target MacOS versions, also, so you won't be pushing software and rules to new major releases until you're ready and you update the rule. - chucksteel 6 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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