'#ffcccc' As backgroundcolor - always red software not installedĪnd Not Exists(Select tblSoftware.AssetIDĪnd tblSoftwareUni.softwareName Like 'software_name%')Īnd tblSoftwareUni. those assets without the desired software TblSoftwareUni.softwareName Like 'software_name%' 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 Then '#ccffcc' - green: good name and good versionĮlse '#ffcccc' - red: good name, but wrong version When tblSoftwareUni.softwareName Like 'software_name%' And tblSoftware.softwareVersion = 'wanted_software_version' scan will not collect your data files stored on the device. those assets with the desired software and maybe the right version Lansweeper (LsAgent) is an application that gathers hardware and software information of. Substitute the software name and version that you're looking for, of course. survey of more than 10 million Microsoft devices by Lansweepers PC management software showed 1. Since you're actually wanting two different sets of data (assets with software_name and assets without software_name), I think you're going to need to create a union of two data selections. How to fix Destiny 2 Servers are not available and.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |