Integration with Microsoft VLSC (Volume Licensing Service Center)?

[pripa06]

A prospective SAM customer is making use of the MS VLSC license portal to view, manage and download licensed MS products.

 

We would like to be able to download the current license entitlements into SAM for the customer from this MS site.

 

Does anyone have any experience with using this portal as the data source for license entitlements into CA SAM?

 

Thanks,

Patrick

[Anon Anon]

CA SAM has a very flexible and open integration interface. 

 

What is the customers process?  Do they expect to query the MSVLSC directly (aka, a DB query), or will they be consuming an extract (aka, CSV) on a periodic basis.

 

From there, you need to see what data is available, and what data SAM needs.  You would be importing into the License Import Pool area, and you can find the specification for that in SAM.  (The SPEC details what fields you need, which are mandatory, which are optional, and what values are expected in those fields.)  Once you have that down, its just a matter of writing the SAM DX job that can do that work. 

 

Rick

[pripa06]

Hi Rick,

Thanks for the reply. I have not yet worked with the VLSC portal, but from screen shots that I have seen on the MS site, you can download reports (probably in XLS format) which would give us the license entitlement information that we are looking for.

I was interested to see if anyone had done this previously and whether there were maybe some issues with downloading reports from the MS site.

 

Thanks,

Patrick

[Anon Anon]

If the VLSC gives an excel report, then you would need to "massage" the XLS to me importable into SAM.  SAM has utilities ias part of its data exchange feature to convert an XLS to CSV, to do some manipulations on the data if needed, etc, to make it importable into SAM.  But you need to determine if the data being provided by the VLSC is enough, or if there is other data you may need to supplement it with. 

 

Rick