ITNinja

I am trying to make a report that will give me all the computer model numbers from KBox. I also would like to start ruling out certain models as I figure out what it is. Basically, I am trying to get a report to list all of our laptops. Not sure, of an easy way but to have a list of all the computers and then start ruling out each model that I know is a desktop. Then I plan to do an online search on the model numbers that I am unsure of. So far, I have as follows, but it is not actually eliminating the models numbers I already have listed. I know there is something missing but do not know what it is. I do not have much experience with SQL and trying to learn a little at a time. I need help setting up the (and CS_MODEL NOT LIKE '%7522D6U%') to work properly in order to eliminate those machine models. Thanks in advance!


SELECT SYSTEM_DESCRIPTION, CS_MODEL, CS_MANUFACTURER, ASSET.NAME AS ASSET_NAME FROM MACHINE LEFT JOIN ASSET ON ASSET.MAPPED_ID = MACHINE.ID AND ASSET.ASSET_TYPE_ID=5
and CS_MODEL NOT LIKE '%7522D6U%'
and CS_MODEL NOT LIKE '%964523U%'
and CS_MODEL NOT LIKE '%821529U%'
and CS_MODEL NOT LIKE '%9645J1U%'
and CS_MODEL NOT LIKE '%9704ANU%'
order by CS_MODEL