3 Replies Latest reply on Sep 4, 2012 5:33 AM by Mahesh.Ghosal

    Query in the database

    Rookie

      Hi everybody 

       

      Somebody knows how to made a query in a landesk database for having this results :

       

      Full Name

      Location

      All the applications installed on the pc

       

      Thanks a lot in advance for your response

       

      FAbien 

        • 1. Re: Query in the database
          SupportEmployee

          If your looking for the tables to use direct SQL with then..

          Both Fullname and Location are stored in the computer table, to get your packages you are going to have to join fileinfoinstance by computer_idn and then fileinfo by fileinfo_idn in that order.

           

          -Brandon

          • 2. Re: Query in the database
            Rookie

            Thanks a lot for your response

             

            Fab

            • 3. Re: Query in the database
              Rookie

              Hi fab,

               

              There is Computer table in SQL Database use computer_idn as primary key-Foreign key to join table to get desired result.

              But if you using the Query Engine: Go to Query engine in to the Name tab enter relevant name to query , now under the Machine Components tab go to software --> Add or Remove Programs --> Name --> Now Named list of all software will populate under Display Scanned Values(Here Select which software you want in result and insert into query area using the Insert Tab , separate each software qualifier with AND.

               

              Click the Filter Tab to select the group of managed devices for desired result. 

              For more detail refer screen-shot.

               

              Regards

              Mahi   

               

               

               

               

              Query_Application_Installed.jpg