Dear all,

We are using SCCM 2007 SP2 R2 in our concern for client management

We had purchased 275 licenses for AutoCAD for different edition like 2012, 2011, 2010 and so on. We had some around 1100 machines in our client environment. So we had installed those products in some random machines some couple of months before. So here is our constraint like we require the query based report to view Computer Name, AutoCAD editions and AutoCAD unique serial number information’s of client machines in single report.

Please provide SCCM Query to accomplish the activity. If you require any additional information please let me know?

Thanks in Advance

Dinesh Vinay

I believe it should be in Asset intelligent reports...

look this report ...Software 02A - Software Families

I Don't think you will get the serial number without extending the MOF file..

Recommendation... I only tried this in a lab environment, so please do let this thread know if it works well:

http://myitforum.com/cs2/blogs/skissinger/archive/2011/04/26/autodesk-autocad-information-via-dcm-and-mof-edit.aspx

 

Hi,

I had tried that script with SCCM DCM by subsequent procedures as what you have given in the above link. But unfortunately i am never get any AutoCAD product key related info from our domain machine. I had  viewed some DCM web report to look for that AutoCAD serial number with product key information. But it doesn't help me

Please provide some simple query to find the Computer Name and AutoCAD serial number with product key information which was installed in our client machines.

Kindly help us to overcome this issue please.

Thanks in Advance

Dinesh

Hi Dinesh

I had a post where my autocad/Desk licensing was reporting with the MOF edits.. let me know how this works for you...

http://paddymaddy.blogspot.com/2011/01/autocad-mof-file-for-all-versions_3761.ht

Don't look at DCM reports.  I'm just cheating and using DCM CIs as a mechanism to run the script to populate WMI locally.  I completely expect DCM reports to say absolutely nothing except that the target boxes are compliant (because they launched the CI at all).

What you need is the mof edit in SMS_def.mof; a hardware inventory action on a computer that ran the DCM (and of course, has autocad).  Then look in ResourceExplorer; you'll see the new custom info.

then you just have to make a totally custom Report.  There will be no built-in report using this completely custom information.  It's a custom table in your database, and a custom view.

 

Potentially a report like..

select sys.netbios_name0,
acad.ProductName0,
acad.Rel0,
acad.SerialNumber0,
acad.StandaloneNetworkType0
from v_gs_AutoDeskCombo0 acad
join v_r_system sys on sys.resourceid=acad.resourceid
where acad.ProductName is not null

Hi Dinesh,

Did you get this working?  Keep to hear how is you did.

 

PaddyMaddy,

Have you got the SQL query to report on this?

Thanks

Hi Paddy,

Thank you very much to provide the Mof file definitions for AutoCAD. It's really worked superb.......

So here is our one more constraint like AutoCAD. Do you have customized MOF file for Adobe Acrobat reader please.. Or else will you please share the technique that how to modify the both customize AutoCAD MOF file for "Adobe Acrobat Reader"

Kindly help us to resolve this issue

Thanks in advance

Dinesh

Hi Ian,

My apologized for delayed response... Use the below link to copy the paddy customized smsdef.mof and configuration.mof files based on AutoCAD version and paste in your environment Mof files.

http://paddymaddy.blogspot.com/2011/01/autocad-mof-file-for-all-versions_3761.html

Run the New custom SQL query to find AutoCAD serial no based on editions

SELECT     v_R_System.User_Name0,  v_R_System.Name0,  v_GS_AutoCAD_20100.ResourceID, v_GS_AutoCAD_20100.KeyName0, v_GS_AutoCAD_20100.ProductName0,

                      v_GS_AutoCAD_20100.Release0, v_GS_AutoCAD_20100.SerialNumber0, v_GS_AutoCAD_20100.StandaloneNetworkType0

FROM         v_R_System INNER JOIN

                      v_GS_AutoCAD_20100 ON v_R_System.ResourceID = v_GS_AutoCAD_20100.ResourceID

 

SELECT     v_R_System.User_Name0, v_R_System.Name0, v_GS_AutoCAD_20110.ResourceID, v_GS_AutoCAD_20110.KeyName0, v_GS_AutoCAD_20110.ProductName0,

                      v_GS_AutoCAD_20110.Release0, v_GS_AutoCAD_20110.SerialNumber0, v_GS_AutoCAD_20110.StandaloneNetworkType0

FROM         v_R_System INNER JOIN

                      v_GS_AutoCAD_20110 ON v_R_System.ResourceID = v_GS_AutoCAD_20110.ResourceID


SELECT     v_R_System.User_Name0, v_R_System.Name0, v_GS_AutoCAD_20120.ResourceID, v_GS_AutoCAD_20120.KeyName0, v_GS_AutoCAD_20120.ProductName0,

                      v_GS_AutoCAD_20120.Release0, v_GS_AutoCAD_20120.SerialNumber0, v_GS_AutoCAD_20120.StandaloneNetworkType0

FROM         v_R_System INNER JOIN

                      v_GS_AutoCAD_20120 ON v_R_System.ResourceID = v_GS_AutoCAD_20120.ResourceID


SELECT     v_R_System.User_Name0, v_R_System.Name0, v_GS_AutoCAD_20090.ResourceID, v_GS_AutoCAD_20090.KeyName0, v_GS_AutoCAD_20090.ProductName0,

                      v_GS_AutoCAD_20090.Release0, v_GS_AutoCAD_20090.SerialNumber0, v_GS_AutoCAD_20090.StandaloneNetworkType0

FROM         v_R_System INNER JOIN

                      v_GS_AutoCAD_20090 ON v_R_System.ResourceID = v_GS_AutoCAD_20090.ResourceID


SELECT     v_R_System.User_Name0, v_R_System.Name0, v_GS_AutoCAD_20080.ResourceID, v_GS_AutoCAD_20080.KeyName0, v_GS_AutoCAD_20080.ProductName0,

                      v_GS_AutoCAD_20080.Release0, v_GS_AutoCAD_20080.SerialNumber0, v_GS_AutoCAD_20080.StandaloneNetworkType0

FROM         v_R_System INNER JOIN

                      v_GS_AutoCAD_20080 ON v_R_System.ResourceID = v_GS_AutoCAD_20080.ResourceID

SELECT     v_R_System.User_Name0, v_R_System.Name0, v_GS_AutoCAD_LT_20070.ResourceID, v_GS_AutoCAD_LT_20070.KeyName0, v_GS_AutoCAD_LT_20070.ProductName0,

                      v_GS_AutoCAD_LT_20070.Release0, v_GS_AutoCAD_LT_20070.SerialNumber0, v_GS_AutoCAD_LT_20070.StandaloneNetworkType0

FROM         v_R_System INNER JOIN

                      v_GS_AutoCAD_LT_20070 ON v_R_System.ResourceID = v_GS_AutoCAD_LT_20070.ResourceID

SELECT     v_R_System.User_Name0, v_R_System.Name0, v_GS_AutoCAD_LT_20080.ResourceID, v_GS_AutoCAD_LT_20080.KeyName0, v_GS_AutoCAD_LT_20080.ProductName0,

                      v_GS_AutoCAD_LT_20080.Release0, v_GS_AutoCAD_LT_20080.SerialNumber0, v_GS_AutoCAD_LT_20080.StandaloneNetworkType0

FROM         v_R_System INNER JOIN

                      v_GS_AutoCAD_LT_20080 ON v_R_System.ResourceID = v_GS_AutoCAD_LT_20080.ResourceID

SELECT     v_R_System.User_Name0, v_R_System.Name0, v_GS_AutoCAD_LT_20090.ResourceID, v_GS_AutoCAD_LT_20090.KeyName0, v_GS_AutoCAD_LT_20090.ProductName0,

                      v_GS_AutoCAD_LT_20090.Release0, v_GS_AutoCAD_LT_20090.SerialNumber0, v_GS_AutoCAD_LT_20090.StandaloneNetworkType0

FROM         v_R_System INNER JOIN

                      v_GS_AutoCAD_LT_20090 ON v_R_System.ResourceID = v_GS_AutoCAD_LT_20090.ResourceID

 

Thanks in advance

Dinesh Vinay

 

I've been searching the internet for weeks to find out about collecting serial numbers for various software. After looking through a huge amount of code (written by others) I finally managed to get virtually everything working that I was looking for. Due to the amount of time that I took looking for various things to try to get this to work, I thought I would blog what worked for me to try and help others as I know how annoying it is searching the net to get things to work. 

I would like to thank Sherry Kissinger though as most of the work for my findings has been done by you!

I've completed the step-by-step guide for all Adobe products now, including adding the DCM script and the custom report script to actually produce the report so feel free to take a look at it here:

http://www.techygeekshome.co.uk/2012/07/step-by-step-guide-to-creating-custom.html

I'll be working on the AutoCad products one today and I've also got some for Office products like Project, Visio etc...

Hope this helps some people and thanks again to Sherry!

• Proposed as answer by itguru82 Tuesday, July 17, 2012 5:30 PM
• Edited by itguru82 Tuesday, August 13, 2013 8:20 PM Updated links

I've been searching the internet for weeks to find out about collecting serial numbers for various software. After looking through a huge amount of code (written by others) I finally managed to get virtually everything working that I was looking for. Due to the amount of time that I took looking for various things to try to get this to work, I thought I would blog what worked for me to try and help others as I know how annoying it is searching the net to get things to work. 

I would like to thank Sherry Kissinger though as most of the work for my findings has been done by you!

I've completed the step-by-step guide for all Adobe products now, including adding the DCM script and the custom report script to actually produce the report so feel free to take a look at it here:

http://www.techygeekshome.co.uk/2012/07/step-by-step-guide-to-creating-custom.html

I'll be working on the AutoCad products one today and I've also got some for Office products like Project, Visio etc...

Hope this helps some people and thanks again to Sherry!

• Proposed as answer by itguru82 Tuesday, July 17, 2012 5:30 PM
• Edited by itguru82 Tuesday, August 13, 2013 8:20 PM Updated links

I've been searching the internet for weeks to find out about collecting serial numbers for various software. After looking through a huge amount of code (written by others) I finally managed to get virtually everything working that I was looking for. Due to the amount of time that I took looking for various things to try to get this to work, I thought I would blog what worked for me to try and help others as I know how annoying it is searching the net to get things to work. 

I would like to thank Sherry Kissinger though as most of the work for my findings has been done by you!

I've completed the step-by-step guide for all Adobe products now, including adding the DCM script and the custom report script to actually produce the report so feel free to take a look at it here:

http://www.techygeekshome.co.uk/2012/07/step-by-step-guide-to-creating-custom.html

I'll be working on the AutoCad products one today and I've also got some for Office products like Project, Visio etc...

Hope this helps some people and thanks again to Sherry!

• Proposed as answer by itguru82 Tuesday, July 17, 2012 5:30 PM
• Edited by itguru82 Tuesday, August 13, 2013 8:20 PM Updated links

I've been working on a solution to this for Configuration Manager 2012 and I finally cracked it today, very similar sort of setup, but I've created a full step by step guide to hopefully get it working for others too.

The guide for Autodesk products is here:

http://www.techygeekshome.co.uk/2012/08/step-by-step-guide-to-reporting-autocad.html

I've also managed to get it working for all Adobe products too in CM2012 so I'll try and get a step by step guide up for that soon.

• Proposed as answer by Sherry Kissinger Tuesday, August 28, 2012 11:04 PM
• Marked as answer by Garth JonesMVP, Moderator Monday, November 05, 2012 1:44 AM
• Edited by itguru82 Tuesday, August 13, 2013 8:20 PM Updated links

I've been working on a solution to this for Configuration Manager 2012 and I finally cracked it today, very similar sort of setup, but I've created a full step by step guide to hopefully get it working for others too.

The guide for Autodesk products is here:

http://www.techygeekshome.co.uk/2012/08/step-by-step-guide-to-reporting-autocad.html

I've also managed to get it working for all Adobe products too in CM2012 so I'll try and get a step by step guide up for that soon.

• Proposed as answer by Sherry Kissinger Tuesday, August 28, 2012 11:04 PM
• Marked as answer by Garth JonesMVP, Moderator Monday, November 05, 2012 1:44 AM
• Edited by itguru82 Tuesday, August 13, 2013 8:20 PM Updated links

I've been working on a solution to this for Configuration Manager 2012 and I finally cracked it today, very similar sort of setup, but I've created a full step by step guide to hopefully get it working for others too.

The guide for Autodesk products is here:

http://www.techygeekshome.co.uk/2012/08/step-by-step-guide-to-reporting-autocad.html

I've also managed to get it working for all Adobe products too in CM2012 so I'll try and get a step by step guide up for that soon.

• Proposed as answer by Sherry Kissinger Tuesday, August 28, 2012 11:04 PM
• Marked as answer by Garth JonesMVP, Moderator Monday, November 05, 2012 1:44 AM
• Edited by itguru82 Tuesday, August 13, 2013 8:20 PM Updated links

Very nice!

If anyone is interested, I've updated the script now to be able to collect up to 2013 versions of CAD....link for the updates are here:

http://www.techygeekshome.co.uk/2013/02/autocad-serial-number-reporting-updated.html

I've just released v3 of my Autodesk reporting. The CI script has been updated to collect up to 2015 (when it comes out!) and also a lot more Autodesk products. I've also amended the report slightly to make it a little better.

Full details and downloads for the updated scripts etc is here:

Autodesk Serial Number Reporting v3 Released

We have now updated the script again to include 2014 versions. We have also fixed the issues with 2013 and 2014 versions reporting back incorrect data so I would suggest that you use this script...

http://www.techygeekshome.co.uk/2013/11/autocad-serial-number-reporting-script.html

Hi,

Can the above SQL query used for SCCM 2007. I want to fetch only the AutoCAD LT versions that are installed in the environment

Can the above SQL query used for SCCM 2007. I want to fetch only the AutoCAD LT versions that are installed in the environment

yes it should work, assuming that you have setup everything correctly and have had at least one computer return results to CM07.