none
Reporting Autocad Serial numbers from SCCM

תשובות

  • For the report script, very slight amendment (mistake on my part..):

    select
     SYS.Netbios_Name0 AS [Computer Name],
     ADC.ProductName0 AS [AutoCAD Version],
            ADC.Rel0 AS [AutoCAD Rel],
     ADC.SerialNumber0 AS [AutoCAD Serial Number]
    from
     v_GS_AutoDeskCombo0 ADC
     INNER JOIN v_R_System SYS 
      ON SYS.ResourceID = ADC.ResourceID
     inner join v_GS_OPERATING_SYSTEM OS
      ON SYS.ResourceID = OS.ResourceID

    Note that I took the description part out - this was a custom setting I had on my collection so will not work for everyone, my site has been amended now.

    However, the error you are getting above it slightly different, so long as you have correctly done everything as stated in my instructions, you should get the information once your clients have reported back their HARDWARE inventory - a lot of people make the mistake that this is a software inventory collection, its not, its based on hardware to collect the info and pass to the database. So, you can wait or change your hardware inventory settings to speed things up a bit.

    Hope this helps, if you continue to have problems, let me know and I'll help where I can.


    https://blog.techygeekshome.info

    • הוצע כתשובה על-ידי TGHInfo יום שלישי 18 ספטמבר 2012 18:10
    • סומן כתשובה על-ידי Garth JonesMVP, Moderator יום ראשון 04 נובמבר 2012 18:38
    • נערך על-ידי TGHInfo שבת 07 אפריל 2018 16:53 update
    יום שלישי 18 ספטמבר 2012 18:09

כל התגובות

  • The error means that the SQL view has not been created yet.

    Did you edit your sms_def.mof?

    Are you sure that you are collecting data for the Autocad details?


    http://www.enhansoft.com/

    יום רביעי 18 יולי 2012 11:56
    מנחה דיון
  • Hi Garth,

    Thanks for your reply .I have pasted this info for the sms_DEF.Mof

    [ SMS_Report     (TRUE),
      SMS_Group_Name ("AutoDeskCombo"),
      SMS_Class_ID   ("Custom|AutoDesk|1.0") ]

    class cm_AutoDesk : SMS_Class_Template

    {
        [SMS_Report (TRUE),key] string KeyName;
        [SMS_Report (TRUE)    ] string ProductName;
        [SMS_Report (TRUE)    ] string Rel;
        [SMS_Report (TRUE)    ] string SerialNumber;
        [SMS_Report (TRUE)    ] uint32 StandaloneNetworkType;
    };

    For the actual report, below are the SQL commands:

    select
     SYS.Netbios_Name0 AS [Computer Name],
            SYS.Description0 AS [AD Computer Description],
     ADC.ProductName0 AS [AutoCAD Version],
            ADC.Rel0 AS [AutoCAD Rel],
     ADC.SerialNumber0 AS [AutoCAD Serial Number]
    from
     v_GS_AutoDeskCombo0 ADC
     INNER JOIN v_R_System SYS
      ON SYS.ResourceID = ADC.ResourceID
     inner join v_GS_OPERATING_SYSTEM OS
      ON SYS.ResourceID = OS.ResourceID

    Basically, the DCM Script are as follows:

    on error resume next
    DIM str1(25,5)
    str1(0,0)= "Software\Autodesk\3dsmax\9.0"
    str1(1,0)= "Software\Autodesk\Inventor"
    str1(2,0)= "Software\Autodesk\AutoCAD LT\R16"
    str1(3,0)= "Software\Autodesk\AutoCAD LT\R15"
    str1(4,0)= "Software\Autodesk\AutoCAD LT\R14"
    str1(5,0)= "Software\Autodesk\AutoCAD LT\R13"
    str1(6,0)= "Software\Autodesk\AutoCAD LT\R12"
    str1(7,0)= "Software\Autodesk\AutoCAD LT\R11"
    str1(8,0)= "Software\Autodesk\AutoCAD LT\R10"
    str1(9,0)= "Software\Autodesk\AutoCAD LT\R9"
    str1(10,0)= "Software\Autodesk\AutoCAD LT\R8"
    str1(11,0)= "Software\Autodesk\AutoCAD LT\R7"
    str1(12,0)= "Software\Autodesk\AutoCAD LT\R6"
    str1(13,0)= "Software\Autodesk\AutoCAD LT\R4"
    str1(14,0)= "Software\Autodesk\AutoCAD\R18.1"
    str1(15,0)= "Software\Autodesk\AutoCAD\R18.0"
    str1(16,0)= "Software\Autodesk\AutoCAD\R17.2"
    str1(17,0)= "Software\Autodesk\AutoCAD\R17.1"
    str1(18,0)= "Software\Autodesk\AutoCAD\R17.0"
    str1(19,0)= "Software\Autodesk\AutoCAD\R16.2"
    str1(20,0)= "Software\Autodesk\AutoCAD\R16.1"
    str1(21,0)= "Software\Autodesk\AutoCAD\R16.0"
    str1(22,0)= "Software\Autodesk\AutoCAD\R15.2"
    str1(23,0)= "Software\Autodesk\AutoCAD\R15.1"
    str1(24,0)= "Software\Autodesk\AutoCAD\R14.0"
    str1(25,0)= "Software\Autodesk\AutoCAD\R15.0"

    const HKEY_LOCAL_MACHINE = &H80000002
    strComputer = "."
    Set oReg=GetObject("winmgmts:{impersonationLevel=impersonate}!\\" &_
    strComputer & "\root\default:StdRegProv")

    for i=0 to 25
     oReg.EnumKey HKEY_LOCAL_MACHINE, str1(i,0), arrSubKeys
     
     For Each subkey In arrSubKeys
       str1(i,1)=subkey
       oReg.GetStringValue HKEY_LOCAL_MACHINE,str1(i,0) & "\" & subkey,"ProductName",str1(i,2)
       oReg.GetStringValue HKEY_LOCAL_MACHINE,str1(i,0) & "\" & subkey,"Release",str1(i,3)
       oReg.GetStringValue HKEY_LOCAL_MACHINE,str1(i,0) & "\" & subkey,"SerialNumber",str1(i,4)
       oReg.GetDwordValue HKEY_LOCAL_MACHINE,str1(i,0) & "\" & subkey,"StandaloneNetworkType",str1(i,5)
      if str1(i,2) <> "" then k=k+1
     Next
    Next

    Dim wbemCimtypeString
    Dim wbemCimtypeUint32
    wbemCimtypeString = 8
    wbemCimtypeUint32 = 19

    ' Remove classes
    Set oLocation = CreateObject("WbemScripting.SWbemLocator")
    Set oServices = oLocation.ConnectServer(,"root\cimv2")
    set oNewObject = oServices.Get("cm_AutoDesk")
    oNewObject.Delete_

    if k > 0 then

     Set oDataObject = oServices.Get
     oDataObject.Path_.Class = "cm_AutoDesk"
     oDataObject.Properties_.add "KeyName" , wbemCimtypeString
     oDataObject.Properties_("KeyName").Qualifiers_.add "key" , True
     oDataObject.Properties_.add "ProductName" , wbemCimtypeString
     oDataObject.Properties_("ProductName").Qualifiers_.add "key" , True
     oDataObject.Properties_.add "Rel" , wbemCimtypeString
     oDataObject.Properties_.add "SerialNumber" , wbemCimtypeString
     oDataObject.Properties_.add "StandaloneNetworkType" , wbemCimtypeUint32
     oDataObject.Put_

     For j=0 to 25
      if str1(j,1)="" then
       else
         Set oNewObject = oServices.Get("cm_AutoDesk" ).SpawnInstance_
         oNewObject.KeyName = Str1(j,1)
         oNewObject.ProductName = str1(j,2)
         oNewObject.Rel = str1(j,3)
         oNewObject.SerialNumber = str1(j,4)
         oNewObject.StandaloneNetworkType = str1(j,5)
         oNewObject.Put_
    'uncomment the below 2 lines ONLY when testing interactively
    '   wscript.echo str1(j,0) & ", " & str1(j,1) & ", " & str1(j,2) &_
    '  ", " & str1(j,3) & ", " & str1(j,4) & ", " & str1(j,5)
      end if
     next
    end if

    wscript.quit

    Any comments on this?

    Nica

    יום שישי 20 יולי 2012 03:37
  • Everything looks good. On a system with Audocad, Can you see the WMI Class? Can you see that the data is being inventoried within the InventoryAgent.log?


    http://www.enhansoft.com/

    יום שישי 20 יולי 2012 11:55
    מנחה דיון
  • For the report script, very slight amendment (mistake on my part..):

    select
     SYS.Netbios_Name0 AS [Computer Name],
     ADC.ProductName0 AS [AutoCAD Version],
            ADC.Rel0 AS [AutoCAD Rel],
     ADC.SerialNumber0 AS [AutoCAD Serial Number]
    from
     v_GS_AutoDeskCombo0 ADC
     INNER JOIN v_R_System SYS 
      ON SYS.ResourceID = ADC.ResourceID
     inner join v_GS_OPERATING_SYSTEM OS
      ON SYS.ResourceID = OS.ResourceID

    Note that I took the description part out - this was a custom setting I had on my collection so will not work for everyone, my site has been amended now.

    However, the error you are getting above it slightly different, so long as you have correctly done everything as stated in my instructions, you should get the information once your clients have reported back their HARDWARE inventory - a lot of people make the mistake that this is a software inventory collection, its not, its based on hardware to collect the info and pass to the database. So, you can wait or change your hardware inventory settings to speed things up a bit.

    Hope this helps, if you continue to have problems, let me know and I'll help where I can.


    https://blog.techygeekshome.info

    • הוצע כתשובה על-ידי TGHInfo יום שלישי 18 ספטמבר 2012 18:10
    • סומן כתשובה על-ידי Garth JonesMVP, Moderator יום ראשון 04 נובמבר 2012 18:38
    • נערך על-ידי TGHInfo שבת 07 אפריל 2018 16:53 update
    יום שלישי 18 ספטמבר 2012 18:09
  • 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

    • נערך על-ידי TGHInfo שבת 07 אפריל 2018 16:53 update
    שבת 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

    • נערך על-ידי TGHInfo שבת 07 אפריל 2018 16:53
    שבת 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 18:00
  • 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