[Lansweeper] Report of Microsoft Office 2010 SP1

Select Top 1000000 upgrade_tblComputers.Computername,
upgrade_tblComputers.ComputerUnique,
upgrade_tblSoftware.softwareName,
upgrade_tblSoftware.softwareVersion,
tblADusers.Displayname,
tblADusers.Username
From upgrade_tblComputers
Inner Join upgrade_tblSoftware On upgrade_tblComputers.Computername =
upgrade_tblSoftware.ComputerName
Left Join tblADusers On upgrade_tblComputers.Username = tblADusers.Username
And upgrade_tblComputers.Userdomain = tblADusers.Userdomain
Where upgrade_tblSoftware.softwareName Like ‘Microsoft Office%’
AND upgrade_tblSoftware.softwareVersion Between ‘14.0.6029.1000’ AND ‘14.0.7015.1000’

Order By upgrade_tblComputers.ComputerUnique

Information of software version is based on the following link:

http://support.microsoft.com/kb/2121559

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s