3/12/2024 0 Comments E3 office 365(tblSoftwareUni. Where (tblSoftwareUni.softwareName Like '%Office%365%') Or TsysIPLocations.StartIP And tblAssets.IPNumeric 1) SubQuery1 On SubQuery1.AssetID = The software name includes "Office" and "2010".įor what you are trying to do (list computers with both Office versions installed), you need something like this: The software name includes "Office" and "365". There are several good SQL tutorials available online, e.g.: We would recommend reading up on SQL, so you know how the AND and OR operators work. Your report only lists software that meets BOTH of the criteria below. TblSoftwareUni.softwareName Like '%Office%2010%' Where tblSoftwareUni.softwareName Like '%Office%365%' And Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID TsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP Left Outer Join tsysIPLocations On tblAssets.IPNumeric >= Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID I have created a report but it does list any results. During the migration we had some of our techs not uninstall the 2010 versions. Transform how you manage your business and enhance customer relationships with integrated workflows. Improve productivity and foster a culture of collaboration with connected experiences. We have recently moved to Office 365 for Enterprises and we have some users who are part of their E3 packages who get the Office 365 2013 package installed and the rest are still using our Volume licensing office 2010 installs. Microsoft 365 E3 combines best-in-class enterprise productivity apps with core security and compliance capabilities.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |