Client Management Suite

Hey All,

I have this existing report that i managed to create somehow with snippets and hekp from this forum but I now need to alter it a little to get more data along with it.

Current report (basically gives me all semi-active computers with Attachmate installed):
SELECT T0.[Name] AS 'Product Name', T0.[Version] AS 'Version', COUNT(*) AS 'Total Installed'

FROM [Inv_AeX_OS_Add_Remove_Programs] T0
JOIN Inv_AeX_AC_Inventory_Results acir
ON T0._ResourceGuid = acir._ResourceGuid

WHERE DATEDIFF(DAY,acir.[Collection Time], GETDATE()) < 90
AND (T0.[Name] LIKE '%myEXTRA! Enterprise%'
OR T0.[Name] LIKE '%EXTRA! Personal Client%'
OR T0.[Name] LIKE '%EXTRA! for windows%'
OR T0.[Name] LIKE '%EXTRA! X-treme 8%' )

GROUP BY T0.[Name], T0.[Version]

This works good at giving me a raw count but I need to double click on a specific version of that product and it open me a window with the computer names and their IP addresses that are associated with it.

Any help or direction would be great.

Thanks,
Clay

Hi,

you need to edit the report and define a new level 1 query and a drill down menu using parameters. for example:

A. Level 0 query:

select distinct
i.name as 'Product Name',
i. version as 'Product Version'
from
inv_aex_os_add_remove_programs i
order by
1


B. Level 1 query:

select distinct
vcomputer.guid as '_guid',
vcomputer.name,
vcomputer.domain,
i.name,
i.version
from
vcomputer,
inv_aex_os_add_remove_programs i
where
vcomputer.guid = i._resourceguid and
i.name = '%Product Name%' and
i.version = '%Product Version%'


C. Drill Down:
create a new drill down menu at level 0 (use the icons at the end of the query definition) and use the following parameters: Product Name|Product Version