→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
TimBLank
Engaged Sweeper
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
0 REPLIES 0