/build/static/layout/Breadcrumb_cap_w.png

K1000: Smart Label for Select kb

I want to create a dynamic label, which selects all security patches with the following criteria

but I dont' known how to dos this in a sql querry ?

I do not know if this is also a good practice to patch some priority operating system like this ?

Impact = Critical

OS = Win 7 SP1 x64

Superseded = No

Status = Active

Category = OS

Vendor  Microsoft Corp.

Severity = Critical

Can anyone help me ?

 

Thanks .

 

 


1 Comment   [ + ] Show comment
  • Not sure why you need all these or a custom sql. the wizard can do this with the 4 lines it has today.

    Impact = Critical

    OS = Win 7 SP1 x64

    Superseded = No

    Status = Active

    Category = OS

    Vendor Microsoft Corp.

    Severity = Critical

    In our KBOX i just use these to get my critical, os, active

    OS = Win 7 SP1 x64
    Impact = Critical
    Category = OS
    Status = Active

    There is no need for vendor as they shoud all be OS patches and maybe severity but if you are looking for impact critical you should get all the critical severity patches well.

    I create different labels for each OS but only use the 4 that i mentioned and just change the OS line for the OS i need. - nshah 11 years ago

Answers (0)

Be the first to answer this question

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