2 Replies Latest reply on May 5, 2010 8:19 AM by smopuru

    Query to find information for software deployments from Landesk ??

    Rookie

      Which table or view I can find below information? So I can create crystal report using below info.

       

      The script name that was executed,

      PCs that the scripts ran against,

      the time the scripts were run,

      and the user account that ran/scheduled the script.

        • 1. Re: Query to find information for software deployments from Landesk ??
          phoffmann SupportEmployee

          *Thread moved to LANDesk Management Suite - Reporting*

           

          It'd help if you'd say how familiar you are with DB's in general / how familiar you are with the LANDesk DB itself. Also, ideally, get into the habit of stating what version you use, as the DB tables can (and do) change between versions quite a bit.

           

          In general, you will want to keep an eye on these tables:

           

          COMPUTER -- this will help you resolve COMPUTER_IDN's to device names.

          LD_TASK -- this table will net you the task's identifier (LD_TASK_IDN).

          LD_TASK_MACHINE -- this table will list the COMPUTER_IDN's (i.e. devices) that a particular task has run against.

           

          These tables should keep your report happy / give you a good start.

           

          You can find other bits of information in either the Reporting section or the Software Distribution section.

           

          - Paul Hoffmann

          LANDesk EMEA Technical Lead

          • 2. Re: Query to find information for software deployments from Landesk ??
            Rookie

            Thank You Paul for prompt response.

             

            Reagarding to Version: We are using   v8.7 with SP5.

             

            I need to know below information with table names if you help me that will be great.

            Script name

            Targeted PC's

            Excution Time

            User Account

             

            b.t.w I am new to Landesk reports.