ePO Query/Report - Number of Installed Products...

[mraybone]

Hello,

I'm trying to create a query in ePO to show a list of products, and the number of systems that has each product installed, but don't seems to be able to find the right way to get this done.  Can anyone point me in the right direction please?

Something like...

Cheers,
MRaybone

[cdinet]

Go to queries, new query.  On the left side choose others, then scroll down to installed products.

Click next, choose single group summary table.  For labels, under installed products choose product name- if you want version also you can choose product name and version.  Leave the values as is (number of installed products).

Then click next and choose what columns you want to see, then save it and run it.

[mraybone]

Thank you for your reply!

I think I have something slightly different when building the query.  You mention under Labels, there should be Product Name under Installed Products.  I have the following...

This gives the following results in the table, which seems a bit weird...

Any ideas why I'd be missing the Installed Products category?

Cheers,
MRaybone

[mraybone]

Actually, when I create a new query and select Others from the left.  The only thing that appears on the right is Systems Per Product...

[cdinet]

You should be seeing something like this (you may not see dlp if you don't have that extension checked in).  Also, are you a global admin?

[mraybone]

I see none of those Result Types.  I am an Administrator.  The products I have are Agent, VSE, DLP and DE.  All with the relevant extensions checked in.

[cdinet · Accepted solution]

Make sure you have this extension checked in.

ftp://custftp2.nai.com/outgoing/cdinet/ppsreports.zip

[mraybone]

Thanks for the help, however...

"Unable to install extension. The uploaded file was either corrupt or not of the proper format."

I checked the file and it unzips ok so isn't corrupt.

[cdinet]

So Sorry!  I forgot to check the contents.  Re-download it and it should check in now.

[mraybone]

Thanks for the help, however...

"Package missing required pkgcatalog.z file"

One more time?