SCCM 2012 R2 SP1 CU2 Assett Intelligence

[Leon1983]

Hi,

 

I have been troubleshooting an issue with Microsoft tech support and just do not seem to be getting anywhere, so any advice would be appreciated.

 

I would like to run an accurate report (14A) of our Microsoft Volume licenses however noticed that there were many products missing. Even after importing a new license summary, the new products seem to be present within the SQL database, but do not reflect in the report.

 

I imported the licenses using method 1 at the following URL;

https://blogs.technet.microsoft.com/configurationmgr/2012/08/15/support-tip-importing-mvls-information-into-an-asset-intelligence-catalog-fails-with-failed-to-import-licensing-data-into-the-site-database/

thinking that this would add the extra products but it does not on the report.

 

Could this potentially be related to a connect issue to our SQL server? After reading the following post it has been mentioned that having an SCCM database on a remote server is known to be troublesome;

https://www.windows-noob.com/forums/topic/13658-migrate-from-2008r2-to-2012r/

 

Regards

 

Leon

 

 

 

[GarthMJ]

Yes have a remote SQL server is troublesome, hence why I never recommend it. However I doubt that remote SQL is your problem.

 

You will need to give more details to your problem.

[Leon1983]

Hi Garth,

 

Many thanks for your response.

 

I noticed that there were a considerable number of products missing from the report "License 14A - Microsoft Volume Licensing reconciliation report" so proceeded to download a license summary from the Microsoft Volume Licenses Service Center and proceeded to import using the above method, and it appeared successful.

 

The problem is the new products are not appearing on the report which I would like to create a subscription for my manager on a regular basis so we can ensure that we are compliant with the licenses we have available under our EA.

 

Our SCCM is 2012 R2 SP1 CU 2 and is within a single site hierarchy.

 

Please let me know what further information you require

[Leon1983]

Turns out that even an Escalation Engineer at Microsoft couldn't fix this, so was provided some alternative reports I could run to achieve the aim. Specifically Software 02D

 

For anyone out there having this issue - I wouldn't waste you time trying to have it fixed...