Report for Notebooks and Laptops and LSAgent

[daniel_kr]

Hi,

i´m not very familiar with sql, but i would like to build a report regarding the dynamic group "Laptops" und the static group "Notebooks" to check if the installation of LSAgent was successful. It would be nice if this report will only show the Notebooks or Laptops where LSAgent is missing.
Could you please be so kind to provide a solution for this?

Kind Regards,
Daniel

[daniel_kr]

Hi again,

this is my try for this, but it won´t show any results.

Select Distinct Top 1000000 tblSoftwareUni.softwareName As software,
  tblAssetGroups.AssetGroup,
  tblAssets.AssetName
From tblSoftware
  Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
  Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
    tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup In ('%Notebook%', '%Laptops%') And
  Not Exists(Select tblSoftware.AssetID
      From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
          tblSoftware.softID
      Where tblSoftware.AssetID = tblAssets.AssetID And
        tblSoftwareUni.softwareName Like '%LSAgent%')
Group By tblSoftwareUni.softwareName,
  tblAssetGroups.AssetGroup,
  tblAssets.AssetName

Any Improvements to get this to work are welcome.

Kind regards,
Daniel