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
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
I would start by detecting the chassis type as a custom inventory field [link]http://www.kace.com/support/customer/faq/index.php?action=artikel&cat=5&id=850&artlang=en[/link]

Then I would create a filter to label all machines with a certain chassis type.

Then, since you're not comfortable with SQL, use the report wizard to generate this report based on the label membership.
Answered 02/25/2010 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
Gerald's suggestion is definitely an easier solution than trying to figure out which models are laptops by manually checking them off of a list. Detecting chassis type may be effective, but I haven't used the KBOX suggestion so I cannot attest to its accuracy. What I've done in my organization is setup a script (using WMI) to detect the existence of a battery in the system and write a registry key accordingly. I then configured a custom software inventory named "Laptop Battery" to detect the value. This has given us a very accurate count of laptops.
Answered 02/26/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
Thanks a lot Gerald. You just saved me a ton of time. That worked out perfectly.



ORIGINAL: GillySpy

I would start by detecting the chassis type as a custom inventory field [link]http://www.kace.com/support/customer/faq/index.php?action=artikel&cat=5&id=850&artlang=en[/link]

Then I would create a filter to label all machines with a certain chassis type.

Then, since you're not comfortable with SQL, use the report wizard to generate this report based on the label membership.
Answered 02/26/2010 by: ustacp
Second Degree Blue Belt

Please log in to comment
0
Andy,

I actually ran across a Google search where they did the same thing as you described. That would work well too. The way Gerald had me go, actually allows me to place the servers and desktops into a filter as well. So I get to knock out three birds at once. I have been meaning to do this for some time now but have not got around to it yet until now. I also ran across some listings using the same method Gerald described via WMI though. Therefore, it should be pretty accurate as it is used elsewhere besides the KBox.

I would be interested to see how the battery script compared to the chassis script in finding the laptops.



ORIGINAL: airwolf

Gerald's suggestion is definitely an easier solution than trying to figure out which models are laptops by manually checking them off of a list. Detecting chassis type may be effective, but I haven't used the KBOX suggestion so I cannot attest to its accuracy. What I've done in my organization is setup a script (using WMI) to detect the existence of a battery in the system and write a registry key accordingly. I then configured a custom software inventory named "Laptop Battery" to detect the value. This has given us a very accurate count of laptops.
Answered 02/26/2010 by: ustacp
Second Degree Blue Belt

Please log in to comment
0
ORIGINAL: GillySpy

I would start by detecting the chassis type as a custom inventory field [link]http://www.kace.com/support/customer/faq/index.php?action=artikel&cat=5&id=850&artlang=en[/link]

Then I would create a filter to label all machines with a certain chassis type.

Then, since you're not comfortable with SQL, use the report wizard to generate this report based on the label membership.


Awesome, eh! Working great for me. Good things can come from Canada! [8D]
Answered 02/27/2010 by: RichB
Third Degree Green Belt

Please log in to comment
0
I did notice that the label was not finding some of the laptops. Looking further into the issue, some of the laptops are placed into the "Peripheral Chassis" section. I am guessing this is because of the docking stations.
Answered 03/01/2010 by: ustacp
Second Degree Blue Belt

Please log in to comment
0
I also found a chassis type not originally designated as a Portable so had to add it to the filter: Docking Station.

What is the SQL to report just the distinct Chassis Types without listing all the computers associated?

Also, using this method it seems all computers get designated as a Desktop initially since the criteria is "... if not labelled Portable or Server" and the first time it checks those designations haven't been applied yet. The next time they check in they get the Portable designation but the Desktop label does not go away.
Answered 03/01/2010 by: RichB
Third Degree Green Belt

Please log in to comment
0
The article sited earlier says "24. Set up the Filter for your Desktop machines by excluding machines with the Server label or the Portable label."

I am finding all computers are getting the Desktop label in addition to the Portable or Server label and it won't go away. I set up the "Desktop" label's filter as Label Names does not contain Portable and Label Names does not contain Server.

Is there a better way to exclude the Portable and Server computers so they don't get the Desktop label too?
Answered 03/02/2010 by: RichB
Third Degree Green Belt

Please log in to comment
0
I gave up on the "Desktop" label as it was still showing on laptops. Portable and Server labels are working great though.
Answered 03/06/2010 by: RichB
Third Degree Green Belt

Please log in to comment
0
Did you have your filters ordered so that Server and Laptop would be applied before Desktop?
Answered 03/07/2010 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
No, but thanks for reminding me Gerald!

I'm still preferring no label for Desktop Chassis Types since everything that's not a Portable or Server is by default a Desktop! Did I mention we already have over 400 labels?
Answered 03/08/2010 by: RichB
Third Degree Green Belt

Please log in to comment
Answer this question or Comment on this question for clarity