→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Glenn_Gagne
Engaged Sweeper III

My discussion is a wish to add capabilities for "Dynamic Asset Groups" to filter "Linux OS" like we can do with "Windows OS".

Until Windows OS, we actually just can have a dynamic result for entire Linux asset type. With over thousand Linux assets (and some that are badly detected as Linux). We very appreciated if we could have a new filter un Linux OS field to have a better inventory overview like "Linux OS LKE: Debian, Red Hat, CentOS, etc."

1 REPLY 1
Gilian
Product Team
Product Team

@Glenn_Gagne thanks sharing this idea.

I've created an an internal product improvement.
Meanwhile you can create a custom report to have your inventory overview using this SQL query:
Select Top 1000000 tblLinuxSystem.OSRelease As OS,
Count(tblLinuxSystem.OSRelease) As Count
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join tblLinuxBios On tblassets.AssetID = tblLinuxBios.AssetID
Inner Join tblLinuxSystem On tblassets.AssetID = tblLinuxSystem.AssetID
Group By tblLinuxSystem.OSRelease