/build/static/layout/Breadcrumb_cap_w.png

Report help - missing patches of all devices including Organizational Unit

Hello,

I have a report that lists all missing patches per device.  I'm unsure how to add the Active Directory OUs to the SQL query so I can filter devices in a csv file by OU.  I don't see an OU option in the "New Report - Wizard' area nor in the tables. I thought including the "Machine Location" table would fix that but all it shows is "NOTPATCHED", so something is really broke there.

Here is my existing query.


SELECT MACHINE.NAME,

       PATCH.PUBLISHER,

       PATCH.TITLE,

       PATCH_MACHINE_STATUS.DETECT_STATUS

       MACHINE_LOCATION

  FROM (PATCH_MACHINE_STATUS PATCH_MACHINE_STATUS

        INNER JOIN KBSYS.PATCH PATCH

           ON (PATCH_MACHINE_STATUS.PATCH_ID = PATCH.ID))

       INNER JOIN MACHINE MACHINE

          ON (PATCH_MACHINE_STATUS.MACHINE_ID = MACHINE.ID)

WHERE (PATCH_MACHINE_STATUS.DETECT_STATUS = 'NOTPATCHED')


0 Comments   [ + ] Show comments

Answers (2)

Posted by: Tramer61 2 months ago
White Belt
0

I do have smart labels for this, thanks very much for the tip.

Posted by: Hobbsy 2 months ago
Red Belt
0

You wont find any reference to AD or OU, but you should be able to use a label if you have LDAP labels created?? So if your OU's are reflected in your LDAP Labels, you will probably need to join the MACHINE Table to the MACHINE_LABEL_JT table and then use the ID of  the OU label that you need

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