/build/static/layout/Breadcrumb_cap_w.png

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

0 Comments   [ + ] Show comments

Answers (2)

Posted by: dchristian 13 years ago
Red Belt
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

Posted by: wsteo 13 years ago
Senior Yellow Belt
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.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ