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.FileVersionfrom v_R_System
join v_GS_SoftwareFile on v_GS_SoftwareFile.ResourceID= v_R_System.ResourceIdjoin v_FullCollectionMembership fcm on fcm.resourceid=v_r_system.resourceid
WHERE fcm.Collectionid=@ColIDandFileName='iexplore.exe'
order byNetbios_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?
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
Hello,
I created a custom report with a collection prompt (SCCM 2012 r2) as seen here:
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
Share this post
Link to post
Share on other sites