Cbi lansweeper5/30/2023 Assettype Inner Join tsysOS On tblAssets. AssetID Inner Join tsysAssetTypes On tsysAssetTypes. SoftwarePublisher From tblAssets Inner Join tblAssetCustom On tblAssets. SoftwareCheck On SoftwareCheck.AssetID = tblAssets.AssetID TblSoftwareUni.softwareName Like '%Autodesk Material LIbraries 2011%'Īnd tblSoftwareUni.softwareName Like '%Autodesk Revit 2013%') As Where tblSoftwareUni.softwareName Like 'Autocad 2011%' And Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID I have found a search and tried to modify as below. They want multiple versions of Revit(13)Autodesk Material Libraries (9)and 4 versions of AutoCAD 2011 checked.Īll versions of 3 different apps, in one query. (Did a term of SQL and can't remember much) The company I work for are currently using Lansweeper and have asked me to create a SQL query to search for 3 different types of software and all versions.
0 Comments
Leave a Reply. |