ā10-24-2022 12:41 PM - last edited on ā10-27-2022 12:08 PM by beacampos
Hi all thanks for taking the time to read this
I am trying to create a lansweeper report that only shows all desktops and laptops including some other fields which works but for some reason its also showing our VMWARE systems which I need to filter out please could anyone assist, I have crawled through the forums and have started to go crazy now
My report runs like this, I am unsure on how or where to add the excluded manufacturer VMware, Inc.
Solved! Go to Solution.
ā10-27-2022 08:43 AM
Hi Yes i did some searching around other topics and just did some copying and pasting until it worked hahaha bits and bats of other peoples reports but this gives me exactly what I need now so thanks to everyone
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblADusers.email As Email,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssetCustom.Manufacturer As Make,
tblAssetCustom.Model As Model,
tsysOS.OSname As OS,
tblAssets.Lastseen,
tblAssetCustom.Warrantydate As [Warranty Expiration],
tblState.Statename As State,
Case
When tblPortableBattery.AssetID Is Null Then 'Desktop'
Else 'Laptop'
End As [Desktop/Laptop]
From tblAssets
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tblADusers On tblADusers.Username = tblAssets.Username
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tblPortableBattery On tblAssets.AssetID = tblPortableBattery.AssetID
Where (tblAssetCustom.Model Is Null Or tblAssetCustom.Model = '' Or
tblAssetCustom.Model Not Like '%Virtual%') And
tsysOS.OSname Not Like '%win 20%%' And tblAssets.Lastseen Is Not Null And
tblAssets.Lastseen <> '' And tsysAssetTypes.AssetTypename In ('Windows',
'Windows CE', 'apple mac', 'linux')
Order By tblAssets.Domain,
tblAssets.AssetName
ā10-27-2022 07:15 AM
I usually just put "tblassetcustom.manufacturer not like '%VMware%'" in the WHERE clause, to filter out vmware stuff, and I think you can do %Microsoft%' as well, at least for windows computers, to rule out virtual stuff for Hyper-V.
ā10-24-2022 04:58 PM
Hello, @DaveWard , glad to hear you have been able to solve the problem. Would you mind sharing with our Community what was the solution? This will be valuable for others joining that face the same situation! thank you !
ā10-27-2022 08:43 AM
Hi Yes i did some searching around other topics and just did some copying and pasting until it worked hahaha bits and bats of other peoples reports but this gives me exactly what I need now so thanks to everyone
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblADusers.email As Email,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssetCustom.Manufacturer As Make,
tblAssetCustom.Model As Model,
tsysOS.OSname As OS,
tblAssets.Lastseen,
tblAssetCustom.Warrantydate As [Warranty Expiration],
tblState.Statename As State,
Case
When tblPortableBattery.AssetID Is Null Then 'Desktop'
Else 'Laptop'
End As [Desktop/Laptop]
From tblAssets
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tblADusers On tblADusers.Username = tblAssets.Username
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tblPortableBattery On tblAssets.AssetID = tblPortableBattery.AssetID
Where (tblAssetCustom.Model Is Null Or tblAssetCustom.Model = '' Or
tblAssetCustom.Model Not Like '%Virtual%') And
tsysOS.OSname Not Like '%win 20%%' And tblAssets.Lastseen Is Not Null And
tblAssets.Lastseen <> '' And tsysAssetTypes.AssetTypename In ('Windows',
'Windows CE', 'apple mac', 'linux')
Order By tblAssets.Domain,
tblAssets.AssetName
ā10-27-2022 10:41 AM
Hello @DaveWard that's great, thanks a lot for sharing š
ā10-24-2022 02:36 PM
This can be closed now thank
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now