→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
SimplyClueless
Engaged Sweeper III
Hi folks- I have a decent report that I got some help with a year or so back; but; I need to filter it so that it only pulls machine names that start with

dt
lt
sff


is there any easy way to do this? here is what I have so far- just pulls everything:

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblADusers.Displayname,
tsysIPLocations.IPLocation,
tblAssets.Lastseen,
tblOperatingsystem.Caption,
tblAssets.IPAddress
From tblAssets
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Order By tsysIPLocations.IPLocation,
tblAssets.AssetName
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
Add the below to the Criteria column of the tblAssets.AssetName expression. Keep in mind that this is standard SQL syntax. I would recommend reviewing some tutorials on SQL operators, like this one for instance, as this will make building and modifying reports a lot easier.
Like 'dt%' or Like 'lt%' or Like 'sff%'

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
Add the below to the Criteria column of the tblAssets.AssetName expression. Keep in mind that this is standard SQL syntax. I would recommend reviewing some tutorials on SQL operators, like this one for instance, as this will make building and modifying reports a lot easier.
Like 'dt%' or Like 'lt%' or Like 'sff%'