cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
AnthelioHealth
Engaged Sweeper
Hello,

I would like to modify 2 reports to include Linux and other *nix OSs. These reports are "OS: Operating System Overview" and "Server: All Servers". How can this be accomplished?

Thanks.
2 REPLIES 2
Hemoco
Lansweeper Alumni
You need to filter on assettype -1 (windows) and 11 (linux)

Example:

Select Top 1000000 tblAssets.Assettype,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Description,
tsysOS.OSname,
tblOperatingsystem.Caption,
tblAssets.SP,
tblAssets.Lastseen,
tsysOS.Image As icon
From tblAssets
Left Join tblOperatingsystem On tblAssets.AssetID = tblOperatingsystem.AssetID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where (tblAssets.Assettype = -1 And tblAssetCustom.State = 1) Or
(tblAssets.Assettype = 11)
Order By tsysOS.OSname,
tblAssets.AssetName,
tblOperatingsystem.Caption
AnthelioHealth
Engaged Sweeper
Anybody? Bueller... Bueller...