Video Screencast Help
Endpoint Management Community Blog

DS 7.1 - Creating Computer Model Token

Created: 14 Sep 2011 • 8 comments
JimChud's picture
+2 2 Votes
Login to vote

Something i couldnt find very easily was how to use the model token like in DS6.9. Alot of different ways using VBS were found however its easy enough to create a token under Settings > Deployment > Tokens.

Heres the SQL Query i'm using:

 SELECT DISTINCT [vHWComputerSystem].[Model]
FROM [dbo].[vComputer]
JOIN [dbo].[vHWComputerSystem]ON [dbo].[vComputer].[Guid] = [dbo].[vHWComputerSystem].[_ResourceGuid]
WHERE [dbo].[vComputer].[Guid] = '%COMPUTERID%'

Hope this helps.

Comments 8 CommentsJump to latest comment

sfaucher's picture

Unfortunately in 7.x the basic inventory information including model don't seem to be pushed to the database during initial deployment like it was in 6.9, so I've found that I can't rely on a model token in automation.

Shawn Faucher | Senior Technology Analyst

Armstrong Teasdale LLP
 

-1
Login to vote
JimChud's picture

Unfortunately i've found the same thing.
I had tested it on machines already in the database and it worked but for new machines this was a problem.

I'm still looking in to ways to get around this.

Regards Jim.
Connect Etiquette: "Mark as Solution" those posts which resolve your problem and give a thumbs up to useful comments, articles and downloads.

+3
Login to vote
sfaucher's picture

FOR /F "tokens=2 delims==" %%G IN ('WMIC computersystem get model /format:VALUE') DO SET Model=%%G

That's what I'm using currently.  See this thread.

Shawn Faucher | Senior Technology Analyst

Armstrong Teasdale LLP
 

+1
Login to vote
Pascal KOTTE's picture

We would also have the model number, not only the name: any idea?

WMIC computersystem get model /format:VALUE

Model=HP Compaq dc7900 Ultra-Slim Desktop

~Pascal @ Kotte.net~ Do you speak French? Et utilisez Altiris: venez nous rejoindre sur le GUASF

-1
Login to vote
Sascha Hildebrandt's picture

You want it without the number? I dont think another attribute would help as that is what HP puts in the BIOS and WMI can read out. It's still much better then Lenovo for example, where you find somthing like '2236EG1' in model and 'Thinkpad T410' in csproduct.version

Greetings from Becthle-Bonn by the way.

+1
Login to vote
Pascal KOTTE's picture

Happy to see not alone at Swiss Romande working with Symantec :)

Thanks the advice for WMI, I am not expert this part. I see HP makes some "tricky" fun where computersystem.model is a literal string as I display above, and other vendors provide the model number as I was expecting.

In final: The best WMI variable seems to be into csproduct instead of computersystem, thanks again.

C:\Windows\system32>WMIC csproduct get * /format:VALUE

Caption=Computer System Product
Description=Computer System Product
IdentifyingNumber=R887BPX
Name=43494JG
SKUNumber=
UUID=81AAB0D4-7350-CB11-A58D-E6E3B6B0BAA3
Vendor=LENOVO
Version=ThinkPad T510

 

~Pascal @ Kotte.net~ Do you speak French? Et utilisez Altiris: venez nous rejoindre sur le GUASF

-3
Login to vote
Pascal KOTTE's picture

I must say we should have also a basic harware inventory running with DS 7.1, as we have with DS 6.9. That is a must. Perhaps next DS 7.5 ?

~Pascal @ Kotte.net~ Do you speak French? Et utilisez Altiris: venez nous rejoindre sur le GUASF

+1
Login to vote
sfaucher's picture

It's on their list; let's hope sooner rather than later.

Shawn Faucher | Senior Technology Analyst

Armstrong Teasdale LLP
 

+2
Login to vote