All Systems Report produces only one machine!

[maravig]

Hello,

I created a custom report with a collection prompt (SCCM 2012 r2) as seen here:

select distinct v_R_System.Netbios_Name0, v_R_System.User_Name0, v_GS_SoftwareFile.FileName, v_GS_SoftwareFile.FileVersion 
from v_R_System 
join v_GS_SoftwareFile on v_GS_SoftwareFile.ResourceID = v_R_System.ResourceId 
join v_FullCollectionMembership fcm on fcm.resourceid=v_r_system.resourceid
WHERE fcm.Collectionid= @ColID
and FileName = 'iexplore.exe'
order by Netbios_Name0

Everything works, except I only get 1 machine as output! I originally didn't have a collection ID prompt, but it didn't make any difference. I did have to rebuild SCCM 3 weeks ago without the aid of any backup (long story). I turned on software inventory, turned on just about everything (especially SMS_Softwareinstalled, etc), used Right Click Tools, ran hardware and software inventory and still zip. Am I missing anything blatantly obvious?

 

Thanks,

Jeff

[GarthMJ]

This is going to happen with one of three reasons,

 

• Software Inventory is not enabled (and IMO it should never be in the first place)
• After your site restore you didn’t fix up clients
• You site restore didn’t work. I’m not sure how you restored a site without a back up!