I've been using LANDesk for remote support for a while and recently changed positions to one where I'll be using the reporting functions of the software a lot more.

Here's what I'm trying to do...

I want to generate a report or query that will list each piece of software installed on the network once, with a column that is a count for how many instances of that software are on the network.

I've been able to generate a comprehensive list, but it lists the software once for each computer - which is not what I'm after.

So for example, if our standard image has ten pieces of software on it, and I have 700 computers, I want my report to have ten line items (one for each piece of software) and a count column telling me there are 700 installs for each line item.

The query I was able to come up with (sticking with the same example of 10 programs on each of 700 computers) generated a report with 7000 line items - 700 lines for each program installed, because each program was installed 700 times on the network.