none
Query Based report to find AutoCAD Serial Number

    שאלה

  • 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


    Thanks & Regards, Dinesh
    יום רביעי 19 אוקטובר 2011 17:10

תשובות

כל התגובות

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


    This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    יום רביעי 19 אוקטובר 2011 17:24
  • 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

     


    Standardize. Simplify. Automate.
    • הוצע כתשובה על-ידי PaddyMaddy יום חמישי 20 אוקטובר 2011 19:14
    יום חמישי 20 אוקטובר 2011 12:46
    מנחה דיון
  • 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 Vinay


    Thanks & Regards, Dinesh
    • נערך על-ידי Dinesh Sundaram יום שישי 28 אוקטובר 2011 09:44
    יום שישי 28 אוקטובר 2011 09:40
  • 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.html


    This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • נערך על-ידי PaddyMaddy יום שישי 28 אוקטובר 2011 12:11
    יום שישי 28 אוקטובר 2011 10:59
  • 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


     


    Standardize. Simplify. Automate.
    יום שישי 28 אוקטובר 2011 12:09
    מנחה דיון
  • 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

    יום רביעי 14 דצמבר 2011 21:47
  • 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


    Thanks & Regards, Dinesh
    יום שלישי 03 ינואר 2012 11:47
  • 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

     


    Thanks & Regards, Dinesh
    יום שלישי 03 ינואר 2012 11:58
  • 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!


    • הוצע כתשובה על-ידי TechyGeeksHomeInfo יום שלישי 17 יולי 2012 17:30
    • נערך על-ידי TechyGeeksHomeInfo יום חמישי 23 נובמבר 2017 21:22
    יום ראשון 08 יולי 2012 10:03
  • 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:

    https://blog.techygeekshome.info/2012/08/autocad-autodesk-serial-number-reporting-using-sccm-2012/

    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.


    https://blog.techygeekshome.info




    יום שלישי 28 אוגוסט 2012 15:15
  • Very nice!

    Standardize. Simplify. Automate.

    יום שלישי 28 אוגוסט 2012 23:04
    מנחה דיון
  • 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:

    https://blog.techygeekshome.info/2013/02/autocad-serial-number-reporting-updated-scripts-up-to-2013/

    https://blog.techygeekshome.info



    שבת 16 פברואר 2013 15:13
  • 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


    https://blog.techygeekshome.info


    שבת 08 יוני 2013 21:02
  • 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...

    https://blog.techygeekshome.info/2013/11/autodesk-products-serial-number-reporting-script-update-version-4-1-major-release/

    https://blog.techygeekshome.info



    יום שלישי 12 נובמבר 2013 17:59
  • 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


    Azhar

    יום שלישי 01 ספטמבר 2015 16:31
  • 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.

    Garth Jones | My blogs: Enhansoft and Old Blog site | Twitter: @GarthMJ

    יום שלישי 01 ספטמבר 2015 17:29
    מנחה דיון
  • Hi all,

    Another year flies by and another version of AutoCAD released! So, we have updated our script again to include the 2018 version of LT and the full blown version.

    All the details are here:

    http://blog.techygeekshome.info/2017/03/autodesk-2018-serial-number-collection-update/

    Hope it helps...

    P.S. you may have noticed that we have changed websites to our new WordPress platform and got a new username, but its still us from the original script on this post. :) 

    Making IT Happen - https://blog.techygeekshome.info


    יום ראשון 26 מרץ 2017 21:05
  • Not sure if anyone is keeping up to date with this, but we have just released the AutoCAD 2019 MOF script if you want it. Available here:

    https://blog.techygeekshome.info/2018/04/sccm-autodesk-2019-serial-number-mof-collection-update/ 


    https://blog.techygeekshome.info

    שבת 07 אפריל 2018 16:48