Client Management Suite

Can someone please adivse most reliable way of creating a filter to display all computers with ie6 still installed?

On NS 6.5 we had Inv_AeX_OS_Internet_Explorer but this appears to have been dropped in NS7

Thanks,

Darren

I suggest using RMV_Installed_Software or Inv_AddRemoveProgram.  An example query could be:

Select vc.Name, ris.* from RMV_Installed_Software ris
Join vComputer vc on vc.Guid = ris._ResourceGuid
where [Product Name] = 'Windows Internet Explorer 7'

as it doesn't appear in Add/Remove programs generally on XP machines.

SELECT DISTINCT TOP (100) PERCENT dbo.vComputer.Guid
FROM dbo.Inv_Microsoft_Software_Release INNER JOIN
dbo.ResourceAssociation ON dbo.Inv_Microsoft_Software_Release.InventoryRuleGuid = dbo.ResourceAssociation.ChildResourceGuid INNER JOIN
dbo.vRM_Software_Release_Item AS sr ON dbo.ResourceAssociation.ParentResourceGuid = sr.Guid INNER JOIN
dbo.vComputer ON dbo.Inv_Microsoft_Software_Release._ResourceGuid = dbo.vComputer.Guid
WHERE (dbo.ResourceAssociation.ResourceAssociationTypeGuid = '6ccb60f8-e88d-4ba2-959f-4b531c8c5fcd') AND (sr.Name LIKE N'%internet explorer 6%')

I need help to run a SQL query in Enterprise Studio of NS7 to pull Add Remove Programs like I did in with NS6.   Just something simple.

Can anyone help?  

Like this one

SELECT DISTINCT
vc.[Name],
vc.[User],
vc.[OS Name],
arp.[Name] 'Application Name',

arp.[Version],
arp.[Publisher],
arp.[Install Path]

FROM
vComputer vc
JOIN Inv_Aex_OS_Add_Remove_Programs arp ON vc.[GUID] = arp.[_ResourceGuid]
WHERE
vc.[IsManaged] = '1'

it doesn't contain exactly the same info. This is a first pass:

 SELECT DISTINCT
vc.Name
, vc.[User]
, vc.[OS Name]

, arp.DisplayName 'Application Name'
, arp.DisplayVersion
, arp.Publisher

FROM
dbo.vComputer AS vc
INNER JOIN dbo.Inv_AddRemoveProgram AS arp ON vc.Guid = arp._ResourceGuid
WHERE
(vc.IsManaged = '1') 

Cut and paste that into a new View and use the graphical View Designer tool to select another table or View that has the install path in it then drag and drop a Join between the new table/view and one of the existing ones.

Navigate to Reports > All Reports. Create your own folder, right-click > New > Report > Computer Report.

In the right hand pane, name the report then, from the "Fields" tab of the "Data Source" tab select the blue "+ Add" icon. In the drop down you can type partial phrases and it will find the fields containing that phrase. So "publisher" returns the choice of [AddRemoveProgram].[Publisher] and [MS SQL Server Replication].[Publisher].

Thank you all for your help