Hello,
I am trying to modify an existing report. Could you please tell me how different assets exclude?
Here is the code
Select Top 1000000 tsysOS.Image As icon,
TblAssets.AssetID,
TblAssets.AssetName,
TblDiskdrives.Caption,
Cast (tblDiskdrives.Freespace As bigint) / 1024/1024 As numeric) As
Free,
Cast (tblDiskdrives.Size As bigint) / 1024/1024 As numeric) As
[Total size],
TblDiskdrives.Lastchanged As [lastChanged],
TblAssets.Domain,
TblAssets.Username,
TblAssets.Userdomain,
TblAssets.IPAddress,
TblAssets.Description,
TblAssetCustom.Manufacturer,
TblAssetCustom.Model,
TblAssetCustom.Location,
TsysIPLocations.IPLocation,
TsysOS.OSname As OS,
TblAssets.SP As SP,
TblAssets.Firstseen,
TblAssets.Lastseen
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP> = tblAssets.IPNumeric
Where tblAssets.AssetName NotLike 'VADM-%' And
Cast (tblDiskdrives.Freespace As bigint) / 1024/1024 As numeric) <2048
And Cast (tblDiskdrives.Size As bigint) / 1024/1024 As numeric) <> 0And
Cast (tblDiskdrives.Size As bigint) / 1024/1024 As numeric)> 1500And
TblComputersystem.Domainrole <2 And tblDiskdrives.DriveType = 3 And
TblAssetCustom.State = 1
I would like to exclude not only "VADM-%" but also "VPOOL-%" To the example.
It would be really great if someone could help me.
