Lansweeper license key1/13/2024 This seems to work, it lists all the workstations and the office version installed. (tblSoftwareUni.softwareName Like '%Microsoft Office Project Standard 2007%') '%Microsoft Office Visio Professional 2007%') Or '%Microsoft Office Visio Professional 2003%') Or (tblSoftwareUni.softwareName Like '%Microsoft Office Standard 2007%') Or (tblSoftwareUni.softwareName Like '%Microsoft Office Professional Plus 2010%') '%Microsoft Office Professional Editie 2003%') Or TblSoftwareUni.SoftwarePublisher Like 'Microsoft%' And tblAssetCustom.State = Where (tblSoftwareUni.softwareName Like '%Microsoft Office Standard 2010%' And Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID For some reason I can't get the product key part in there. I'm trying to generate a report of all workstations in a domain, the version of MS Office installed, and the product key that was used.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |