Currently I build a report to filter on all systems that do not have a software package installed called Global Protect.
I am trying to add another statement to only show laptops and tablets in the results.
It currently contains desktops, servers etc..
GlobalProtect is a VPN solution.
My idea was to add a statement that filters out devices with a battery and only include those in the results. But I cant seem to figure it out. Any idea how to add that to the report?
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%GlobalProtect%') And
tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
