‎06-22-2018 09:35 PM
‎06-25-2018 04:47 PM
WHERE
...
AND software1.AssetID IS NOT NULL
AND software2.AssetID IS NOT NULL
‎06-22-2018 10:30 PM
For this asset, for this specific piece of software, is the software both MozyPro AND Spotify?
For this asset, for this specific piece of software, is the software either MozyPro OR Spotify?
Software: Microsoft Word; is the software either MozyPro (NO) or Spotify (NO); no yeses means exclude
Software: MozyPro; is the software either MozyPro (YES) or Spotify (NO); we've got a YES, so include in the output
Software: Adobe Reader; is the software either MozyPro (NO) or Spotify (NO); no yeses means exclude
Software: Spotify; is the software either MozyPro (NO) or Spotify (YES); we've got a YES, so include in the output
Where
tblSoftwareUni.softwareName Like '%MozyPro%'
OR tblSoftwareUni.softwareName Like '%Spotify%'
‎06-25-2018 02:37 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now