DS 7.1 - Creating Computer Model Token
Created: 14 Sep 2011 | 8 comments
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.
Blog Entry Filed Under:
Group Ownership:
The Endpoint Management Community Blog is the perfect place to share short, timely insights including product tips, news and other information relevant to the Endpoint Management community. Any authenticated Connect member can contribute to this blog.
Comments 8 Comments • Jump to latest comment
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 | Lead PC Technician
Armstrong Teasdale LLP
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.
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 | Lead PC Technician
Armstrong Teasdale LLP
We would also have the model number, not only the name: any idea?
WMIC computersystem get model /format:VALUE
~Pascal @ Kotte.net~ Do you speak French? Et utilisez Altiris: venez nous rejoindre sur le GUASF
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.
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.
~Pascal @ Kotte.net~ Do you speak French? Et utilisez Altiris: venez nous rejoindre sur le GUASF
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
It's on their list; let's hope sooner rather than later.
Shawn Faucher | Lead PC Technician
Armstrong Teasdale LLP
Would you like to reply?
Login or Register to post your comment.