Answered Using Adobe's SMS Rporting Tool kit - Software Inventory

  • Tuesday, May 22, 2012 7:55 PM
     
     

    We enabled Software Inventory yesterday in SCCM for inventory of Adobe products.  I enabled searching of *.SWTAG files every 24 hours.  I added SWTAG file collection in SCCM software Inventory.  Inventory has run on many systems, but I cannot run a SCCM query to locate systems with these files.  Does anyone have a SCCM query to find these systems with SWTAG files?

    Besides the above SCCM angle, has anyone used Adob's SMS Reporting Toolkit ver 4 to scan SWTAG files for licensing?  Searched Adobe forums with little luck on others using the tool.

All Replies

  • Tuesday, May 22, 2012 8:46 PM
    Moderator
     
     
    I've never heard of it before.  Do you have a link to it on adobe's web site?  I found some links, but they didn't take me to Adobe, but to file sharing sites.  So I'm not sure if it's really an Adobe product or not?

    Standardize. Simplify. Automate.

  • Wednesday, May 23, 2012 12:59 AM
     
     

    Hi Sherry.  As you've found, there is very little-no information out there unfortunately.  This program was sent to us directly from Adobe for a software audit and looks like its sent only to enterprise customers.  It connects directly to the SCCM SQL DB to pull reports on EXE files collected for adobe products, and now the *.swtag files. SWTAG files contain licensing data and make it easier to tell which adobe products are installed on a PC. 

    In SCCM, we had to scan for *.swtag files located here on each system:  “%ALLUSERSPROFILE%\Application Data\Adobe\ISO-19770\” and %PROGRAMDATA%\ Adobe\ISO-19770\

    Here is some info on SWTAG's: http://blogs.adobe.com/oobe/2009/11/software_tagging_in_adobe_prod_1.html#comment-2828

    For SWTAG collection the utility (running on a PC) scans in real time on \\sccmserver\SMS_DAB\inboxes\sinv.box\FileCol This allows the the utility to output into excel its SWTAG results.  Though this is taking quite some time and wondering if there is a query I can run in SCCM so don't have to wait for the utility to finish scanning.


    • Edited by net1994 Wednesday, May 23, 2012 1:00 AM
    •  
  • Thursday, May 24, 2012 10:54 AM
    Moderator
     
     Answered

    "if there is a query I can run in SCCM so don't have to wait for the utility to finish scanning."  No.  What it sounds like to me is that their utility is scanning through the inbox \ filecol folder, and reading through every subfolder looking for the swtag files, then opening each swtag file, reading the contents to get the data to present to you.

    The CM Database doesn't hold the contents of the collected files in the DB--just the fact that the file has been collected at all.  So any report you write for CM would just be a "yes, Bob's pc had an swtag file collected", which won't help you much.

    So, either stick with their method of gathering up all the .swtag files onto your server, and then running their tool.  Or... depending upon your scripting skillz...you could roll your own script that, when run locally on a client, finds the .swtag files; parses thru the xml files and extracts out the relevant data; and dumps that relevant data into a custom WMI namespace; and then you could custom hinv that back.  THEN the data would be in the CM database and you could run reports on it.  Of course, that's a bit of work to design and test that.   Personally, that's what I would do; but only because I detest File Collection, and go to any lengths to avoid it.  But if FileCol is working for you and you don't have concerns about your inbox size or backup space due to how large your inbox folder now is because of those collected files, then stick with what is already working.


    Standardize. Simplify. Automate.

  • Wednesday, May 30, 2012 10:38 PM
    Moderator
     
     
    Net1994, if you are still interested in this, I played around with a script + mof edit based on that blog.  email me at mofmaster [ a t ] myitforum d-t com  if you want to try it out.

    Standardize. Simplify. Automate.

  • Thursday, June 14, 2012 2:11 AM
    Moderator
     
     
    Blogged the script + mof edit... but no guarantees how well it works.  http://myitforum.com/myitforumwp/2012/06/13/gather-some-adobe-software-serial-numbers-using-configmgr-dcm-and-hardware-inventory/

    Standardize. Simplify. Automate.