4 Replies Latest reply on Oct 14, 2009 9:18 AM by Jared Barneck

    Laptops vs Desktops

    Rookie

      Is there any simple way I can run a report that will return just Laptop computers? We have a variety of models, so specifying each one in a query would not be easy.

        • 1. Re: Laptops vs Desktops
          Jason SupportEmployee

          Have your query look to see if the computer has a battery or use the Chassis Type.

           

           

           


          • 2. Re: Laptops vs Desktops
            Jason SupportEmployee

            here's a quick write up the steps.

             

            Creating a query that returns laptops/notebooks
            -----------------------------------------------------------------
            1) Open the LANDesk Management Suite console
            2) In the Network View, expand Queries.
            3) Right-click on 'My Queries', select 'New Query'
            4) In the name field, type 'Laptop'.
            5) Select the "Computer"."System"."Has Battery" component from the left pane.
            6) Select the '<>' (not equal) operator from the middle pane.
            7) Select the 'No' value from the right pane.
            8) Click on the 'Insert' button.
            9) Select the "Computer"."System"."Chassis Type" component from the left pane.
            10) Select the '=' operator from the middle pane.
            11) Select the 'Notebook' value from the right pane.
            12) Select 'OR' from the drop-down menu.
            13) Click on the 'Insert' button.
            14) The end query will look like this:

            "Computer"."System"."Has Battery" <> "No"
            OR "Computer"."System"."Chassis Type" = "Notebook"

            15) Click on the 'Save' button.




            Creating a query that returns desktops
            ----------------------------------------------------
            1) Open the LANDesk Management Suite console
            2) In the Network View, expand Queries.
            3) Right-click on 'My Queries', select 'New Query'
            4) In the name field, type 'Desktop'.
            5) Select the "Computer"."System"."Has Battery" component from the left pane.
            6) Select the '=' operator from the middle pane.
            7) Select the 'No' value from the right pane.
            8) Click on the 'Insert' button.
            9) Select the "Computer"."System"."Chassis Type" component from the left pane.
            10) Select the '<>' operator from the middle pane.
            11) Select the 'Notebook' value from the right pane.
            12) Select 'OR' from the drop-down menu.
            13) Click on the 'Insert' button.
            14) The end query will look like this:

            "Computer"."System"."Has Battery" = "No"
            OR "Computer"."System"."Chassis Type" <> "Notebook"

            15) Click on the 'Save' button.

            • 3. Re: Laptops vs Desktops
              Rookie

              Thanks!

              • 4. Re: Laptops vs Desktops
                Jared Barneck SupportEmployee

                Don't forget to click that Jason gave you the correct answer...we have a cool point system on this forum and he deserves his points.