Hey All,

I need to some how drop a report that shows the software catalog with each actual PC name against each.

We built one for the software raw list but as it shows 45000 software titles the report will only run on the top 140 at a time, and even this is a 140mb excel file of 1million lines.

How can this be done?

Thanks all!
1 Comment   [ + ] Show Comment

Comments

  • SELECT SAM_VIEW_DISCOVERED_SOFTWARE.NAME AS SOFTNAME, MACHINE.NAME AS MACHINENAME FROM SAM_MACHINE_JT LEFT JOIN MACHINE ON SAM_MACHINE_JT.MACHINE_ID = MACHINE.ID LEFT JOIN SAM_VIEW_DISCOVERED_SOFTWARE ON SAM_VIEW_DISCOVERED_SOFTWARE.ID = SAM_MACHINE_JT.SAM_CATALOG_ID ORDER BY SOFTNAME

    This work?
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity