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

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

Attachment

Attachment#2

Answered 11/19/2010 by: dchristian
Red Belt

Please log in to comment
0
You can write a custom inventory rule using the below rule.

RegistryValueReturn(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion,ProductID,TEXT)

The Product ID should show up in custom inventory field of the individual machine.
Answered 12/31/2010 by: wsteo
Senior Yellow Belt

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