kdaepic.blogg.se

I am looking for an antivirus solution for a school with approx 30 staff laptop users. softwareName Like '%Autodesk Revit 2013%' ) As SoftwareCheck On SoftwareCheck. softwareName Like '%Autodesk Material LIbraries 2011%' or tblSoftwareUni. softwareName Like 'Autocad 2011%' or tblSoftwareUni. softwareVersion From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni. 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.