3 Replies Latest reply on May 14, 2013 10:04 AM by James.Rowney

    Can CUSTJOB change SQL inventory data?

    JSMCPN Expert

      I would LOVE to be able to change a piece of database information via custjob, is this possible?  Basically, I just want to change a targeted computer's Description to "DONATED TO PUBLIC" as part of an OSD custjob script.  We are donating a bunch of used computers to low-income families.  The computers will get a legit disk image first, and as part of the OSD job to deploy this image, I want custjob to mark them in the database as having been imaged.


      Currently, I am doing this via REMEXEC lines to modify the Description in the registry:


      REMEXEC400=reg add "HKLM\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters" /v srvcomment /t REG_SZ /d "DONATED TO PUBLIC" /f



      However, this method only works when the target computer is functional enough to recieve the WinPE boot image via Console push, and communicate with the LD Agent and send back the invenvtory scan.  When someone PXE-boots a computer and picks the OSD job, it's not possible to change the PC description and send back a scan while in WinPE.  Therefore it would be much better if, instead of sending in an inventory scan, I could change the description in the SQL database directly via custjob something like:


      LOCEXEC400=SET DESCRIPTION='DONATED TO PUBLIC' WHERE DeviceName=%Computer - Device Name%



      Any input would be greatly appreciated!