*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
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.
b.t.w I am new to Landesk reports.