KACE Product Support

I would think that you could take a csv and import it to update your existing asset. I'm not certain of how multi-selects are imported off the top of my head but could check when back in the office. My guess is that the csv would look something like:

col1,col2,"value1,value2,value3"

That's a 3 column csv. Column 3 has multiple values in it.

You could experiment with a test asset.

I have several items of software set up for License compliance tracking, which works great

Hi Im trying to set this up atm in my company and I was hoping you might give me a few steps you used to get it working?

Thanks in advance

Gerald - Hi, hope you're OK :)

Thanks for this, I'll try it. So if I Import an asset CSV with the Name field matching an existing record, it'll update it rather than creating a duplicate? Yes, I'll give this a go.

Paddyl, I'm miles from an expert here, but as this does work for me I'll gladly share what I did; chance to pay back into the community for the help I've had here!

First stop is the manual; this process is explained thorougfhly there and though it's fiddly when you're new to it it makes sense after practice. In short, what you have to do is:

1. Create a Smart Label for Software Inventory items that covers all the audited software/versions that match the licence you want to track. Frex my 'Office 2000 Pro' label is set to match

'office 2000 professional' or 'office 2000 SR-1 professional'

in the software title and includes these inventoried installs

Microsoft Office 2000 Professional 5 9.00.2720 Microsoft Corporation
Microsoft Office 2000 SR-1 Professional 75 9.00.9327 Microsoft Corporation
Microsoft Office 2000 SR-1 Professional 11 9.00.3821 Microsoft Corporation

2. So far so good, we know what's out there. Now we create a Software Asset to connect to this

Asset, Action, Add New, Software
Give it a name (in my case Office 2000 Pro) and select the Smart Label you just created. Save It.

3. Last step - Connect /that/ to the number of seats you have; in my case, read from the Select relationship page.

Asset, Action, Add New, License
Give it a name (in the example, Office 2000 Pro)
License Count - enter the number of Seats or copies you have
Select the Software Asset you created in 2 from the Applies to Software list
License Mode - Unit License covers 'normal' licenses

Approved for Computer - you can manually pick the PCs the software's supposed to be on. If you have lots... that's where we came in.

The rest of the fields are for keeping track of optional stuff.

Save that, then go to Home and look at the License Compliance graph (you may need to Refresh). If all is well, you get the happy glow of Microsoft under control.

Hope this helps

Thank you, yes doing well, hope you are too. If kbox problems are our biggest problems then we are doing well. Yes I believe that should work. I haven't had a chance to test the multi-value specifically but that would definitely work for other asset data types. If you have a problem let us know as there should definitely be a way to update any type of asset value via import.

OK, I've given this a whirl. It works pretty well; it doesn't update the existing Asset, rather creates a duplicate, but it's the work of a moment to copy the other data over from the original and link it to the software Asset.

What spoils the parade a bit is that it only adds the first 35 items in the pile to the multi-select. This will be OK for some of the smaller ones; but the 190-odd I needed for Powerterm isn't happening.

I'll come back and try it again after I've moved up to 5.3

It should not create a duplicate, but I could see the limit occurring. Acedashdog please open a support ticket and pm me with the number. I doubt there is any change in 5.3 in this particular area.