We currently have rolled out a large number of machines that have Office 2007, but most of our machines have Office 2003.
We thought it would be useful to see which machines that still have Office 2003, do not have the 2007 compatability pack because those are the machines that are going to start to have trouble opening 2007 files. In case anyone is interested, here it is...
Code:SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER VIEW dbo.Web30repno2007
AS
SELECT TOP 100 PERCENT ComputerName
FROM dbo.tblSoftware
WHERE (softwareName = 'Microsoft Office Professional Edition 2003') AND (NOT (softwareName = 'Compatability Pack for the 2007 office system'))
GROUP BY ComputerName
ORDER BY ComputerName
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
