Oturum Aç
 
Ana SayfaKütüphaneEğitimIndirinSorun GidermeForumlar
BT Uzmanları için Kaynaklar >
> 
> 
Asset Intelligence 14A Licensing Report Inventory

Yanıt Asset Intelligence 14A Licensing Report Inventory

  • 23 Nisan 2012 Pazartesi 20:35
     
     
    Oylamak İçin Oturum Aç
    0

    I have come across quite a few different postings regarding Licensing Report 14A Inventory showing as quantity 0, but I don't see any resolutions that are appropriate to my situation. I am running SCCM 2007 R3, have deployed my AI sync point, updated my catalog, installed KB2483225 and run a hardware inventory sync on some of my client machines. I see an inventory being reported back in my 14B licensing report; however 14A is still showing an inventory of for all MVLS products. I imported my MVLS summary from Microsoft and am working on trying to get some numbers for our upcoming True Up.

    Any help provided would be greatly appreciated!

     

Tüm Yanıtlar

  • 09 Haziran 2012 Cumartesi 21:57
    Moderatör
     
     
    Oylamak İçin Oturum Aç
    0
    Did you ever figure this out?

    http://www.enhansoft.com/

     
  • 10 Haziran 2012 Pazar 01:26
     
     
    Oylamak İçin Oturum Aç
    0
    Unfortunately not. We were able to complete our True Up with the information I was able to collect off the SCCM agents and custom queries, however I'd still like to find a resolution..
     
  • 10 Haziran 2012 Pazar 13:26
    Moderatör
     
     
    Oylamak İçin Oturum Aç
    0

    Can you give us more details as to what is showing a 0 value for license? Is it everything or just something? Are you getting any errors when you import the MVLS?

    http://www.enhansoft.com/

     
  • 11 Haziran 2012 Pazartesi 12:53
     
     
    Oylamak İçin Oturum Aç
    0
    My MVLS imported without any problems and other reports are showing inventory counts fine, it's just this report, which is showing a 0 inventory count for all items listed on the report.
     
  • 12 Haziran 2012 Salı 22:35
    Moderatör
     
      Kod İçerir
    Oylamak İçin Oturum Aç
    0
    Does this query give you any results? 
    select MLSProductPool, MLSFamilyName, VersionCode, EffectiveQuantity, UnresolvedQuantity
	 from v_AI_MVLS

    http://www.enhansoft.com/

     
  • 02 Temmuz 2012 Pazartesi 14:56
     
     
    Oylamak İçin Oturum Aç
    0
    It gives me results, but the results aren't any different than running the 14A report, other than 14A has more output columns.
     
  • 02 Temmuz 2012 Pazartesi 15:08
    Moderatör
     
     
    Oylamak İçin Oturum Aç
    0

    That query will show you exactly what was imported into CM07. If you are not seeing the data you are expecting then it is because it is not getting imported into CM07. Try importing the MVLS again.

    http://www.enhansoft.com/

     
  • 02 Temmuz 2012 Pazartesi 15:17
     
     
    Oylamak İçin Oturum Aç
    0
    The problem with the report is that I'm not seeing anything for the "Inventoried Quantity". All products contain a value of 0, which isn't coming from our MVLS.
     
  • 02 Temmuz 2012 Pazartesi 15:44
    Moderatör
     
     
    Oylamak İçin Oturum Aç
    0

    Are you seeing all the number being shift to the left or right?

    http://www.enhansoft.com/

     
  • 02 Temmuz 2012 Pazartesi 18:41
     
     
    Oylamak İçin Oturum Aç
    0
    No. See screenshot below.
     
  • 02 Temmuz 2012 Pazartesi 19:06
    Moderatör
     
      Kod İçerir
    Oylamak İçin Oturum Aç
    0

    Is both AI and Software Metering enabled?

    Do you get anything with this query?

    select t2.MLSFamilyName, t2.VersionCode, t2.VersionSequence, count(MPC0) as [InventoryCount] from
		(select MPC, MLSFamilyName, VersionCode, VersionSequence
		from v_LU_MSProd where VersionSequence >= 1) t2
		left outer join
		(select ResourceID, MPC0 from v_GS_INSTALLED_SOFTWARE_MS 
		where MPC0 is not NULL 
		group by ResourceID, MPC0) t1
		on t1.MPC0 = t2.MPC
	group by t2.MLSFamilyName, t2.VersionCode, t2.VersionSequence
Having count(MPC0) > 0
order by 4 desc

    http://www.enhansoft.com/

     
  • 02 Temmuz 2012 Pazartesi 19:13
     
     
    Oylamak İçin Oturum Aç
    0

    Yes, we’re using both AI and Software Metering and I have information for both services. When I run the query you’ve provided I get results for InventoryCount of all products. I’d say it’s obvious after running some different reports that we have all the information within our SCCM database , it’s just not pulling it together in this particular report for some reason.

     
  • 02 Temmuz 2012 Pazartesi 19:30
    Moderatör
     
     Yanıt
    Oylamak İçin Oturum Aç
    0

    The query I post before is directly from the 14a report, it is what give you your install base.. so…. I recommend digging into the report more and see what is going on.

    http://www.enhansoft.com/

     
  • 13 Şubat 2013 Çarşamba 14:19
     
     
    Oylamak İçin Oturum Aç
    0
    I'm having the same problem. I know that I have many licenses of Office 2010 Professional Plus installed but my inventory still shows as 0. I have gone into SQL and looked directly at the views called by this report and those views do correctly show the office licenses. They just don't come over to the report properly.