Creating a Report or a Query to show machines that do not have certain software installed for LDMS 8.7 and 8.8

Version 20

    Verified Product Versions

    LANDESK Management Suite 9.6LANDESK Management Suite 9.0 and OlderLANDESK Management Suite 2016.x

    Versions

    8.7 All and 8.8 All

    See ** for updated informtaion

     

    Description

     

    Trying to create a query or a report that will show machines that are missing software. A single criteria chosen will work as designed. Once you choose any additional criteria you will not show correct information.

     

    Example: We would like to install Winzip 11.1 onto our machines. As a second criteria we would like to only install Winzip on machines that are in a certain IP address range.

     

    A single criteria example:

     

    Computer. Software. Application Suites. Application Suites. Name Not Like Winzip 11.1

     

    This query will work properly and only return computer names where Winzip 11.1 is not installed.

     

    A multiple criteria example:

     

    Computer. Software. Application Suites. Application Suites. Name Not Like Winzip 11.1

    AND Computer. Network. TCPIP. Bound Adapter. IP Address < 192.168.000.000

     

    This query will not report back any computer names even if Winzip 11 is not installed and the IP Address is in range.

    Cause

     

    **The way the database is read you will not be able to create this report in the Query or Report module if you are looking for more than one criteria. There is an enhancement request to resolve this issue.

    N.B: This issue is now resolved this works as in LDMS 9.5 and 9.6

     

    Work Around 1

    Create two seperate single criteria queries.

     

    1. Create a single criteria query showing the following machines that do not have Winzip installed : Computer. Software. Application Suites. Application Suites. Name Not Like Winzip 11.1

     

    10-29-2009 4-46-05 PM.png

     

    2. Create a single criteria query showing machine names that have an IP Address range greater than 192.168.000.000 : Computer. Network. TCPIP. Bound Adapter. IP Address < 192.168.000.000

     

    10-29-2009 4-46-29 PM.png

    3. Under Devices | My Devices | Create a new group and drag and drop the query results from query 2 to this group.

     

    10-29-2009 4-46-56 PM.png

     

    4. Edit query 1 and choose "Filter" and choose the create group from step 3.

     

    10-29-2009 4-47-32 PM.png

     

    Work Around 2

     

    The goal is to find all machines missing software so that software can be installed. To do this we can create a Custom Definition in the Security and Patch module. You do not require a license for Security and Patch to utilize this function at this time.

     

    Here is a link to creating various Custom Definitions: http://community.landesk.com/support/docs/DOC-6041

     

    Once you have created your custom definition you will perform security scans on your machines.At this point machines that do not have the software will show as "Affected Computers".

     

    Steps:

     

    1. Right click on Custom Definition (after you have scanned machines with security scan)

     

    2. Choose Affected Computers.

    10-29-2009 3-55-44 PM.png

    3. With the open Affected Computers window, drag and drop the machines missing Winzip onto the Scheduled task

    10-29-2009 3-56-27 PM.png

    4. Deploy task