This is a check to see if anyone has found an easy way around a grotty job.

I have several items of software set up for License compliance tracking, which works great. One problem I have though is that when a couple more PCs crop up with said software, the count goes negative, we need to buy some more - but for who? Which are the new computers in the list of those installed with the software?

The answer to this seems to be Approved for Computers, of course. Here's the problem; for Powerterm, frex, I have 198 installed out of 1200 PCs. It lists them, but if I go to set them up as Approved there's just a list of 1200 PCs. I keep blanching at the prospect of rolling down this and picking out 198 machines manually.... especially when I have a list of the PCs I want selected. Some software items have far more PCs...

Is there any way at all I can import that list and designate the PCs as Approved for software xyz? Once it's done, I can keep up by using reports to pick up unapproved PCs, but I could really do with a shortcut to get me over the initial hump.

Anyone tackled this before?
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
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.
Answered 12/30/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
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
Answered 01/03/2012 by: paddyl
Orange Belt

Please log in to comment
0
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.
Answered 01/03/2012 by: Acedashdog
Purple Belt

Please log in to comment
0
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
Answered 01/03/2012 by: Acedashdog
Purple Belt

Please log in to comment
0
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.
Answered 01/03/2012 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
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
Answered 01/04/2012 by: Acedashdog
Purple Belt

Please log in to comment
0
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.
Answered 01/04/2012 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity