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.
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 ?
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
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.
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
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.
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.
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.