Windows 7 Product ID Report
Just installed our K1100 and K2100 a couple weeks ago and I'm trying to create a report that will return the Windows 7 Product ID for each workstation. We are rolling out a new OS (Win7 64-bit) this weekend and I need to retrieve these ID's so I can match them to my MAK's.
I've gone through all of the KACE reports but did not find what I was looking for...maybe I missed it? I also tried to create a custom report but could not find the fields I need...
Any help would be much appreciated!
Thanks!
Roger
I've gone through all of the KACE reports but did not find what I was looking for...maybe I missed it? I also tried to create a custom report but could not find the fields I need...
Any help would be much appreciated!
Thanks!
Roger
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
dchristian
14 years ago
rcoleman,
I think this will work for you.
Create an Online Shell Script.
Add the 3 files attached as dependencies (make sure you unzip and add them one at a time).
Here is the code for the shell script.
Make sure you change the name from script.sh to script.bat in the file name or the shell script wont run.
Run the script.
The script will use keyfinder.exe to retrieve your windows product key.
Next the VBS will write the key to the registry.
After create a custom inventory rule.
Call the software "Windows Product Key"
Here is the syntax for the custom inventory:
Ok Almost there.
Now when you see your computer in inventory, the windows product key will be a shown under custom inventory.
Finally create a new SQL report to look at everything.
I think this will work for you.
Create an Online Shell Script.
Add the 3 files attached as dependencies (make sure you unzip and add them one at a time).
Here is the code for the shell script.
Make sure you change the name from script.sh to script.bat in the file name or the shell script wont run.
keyfinder.exe /save /file key.txt /close
cscript.exe finder.vbs
del key.txt
Run the script.
The script will use keyfinder.exe to retrieve your windows product key.
Next the VBS will write the key to the registry.
After create a custom inventory rule.
Call the software "Windows Product Key"
Here is the syntax for the custom inventory:
RegistryValueReturn(HKEY_LOCAL_MACHINE\SOFTWARE\TVG,WinKey,TEXT)
Ok Almost there.
Now when you see your computer in inventory, the windows product key will be a shown under custom inventory.
Finally create a new SQL report to look at everything.
SELECT M.NAME,
S.DISPLAY_NAME,
MCI.STR_FIELD_VALUE AS PRODUCT_KEY
FROM SOFTWARE S,
MACHINE_CUSTOM_INVENTORY MCI,
MACHINE M
WHERE MCI.SOFTWARE_ID = S.ID
AND M.ID = MCI.ID
AND S.DISPLAY_NAME = 'Windows Product Key'
ORDER BY PRODUCT_KEY
Posted by:
wsteo
13 years ago
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
so that the conversation will remain readable.